eclipse JDBC连接数据库及jsp操作数据库数据详细教程.docx

《eclipse JDBC连接数据库及jsp操作数据库数据详细教程.docx》由会员分享，可在线阅读，更多相关《eclipse JDBC连接数据库及jsp操作数据库数据详细教程.docx（23页珍藏版）》请在课桌文档上搜索。

1、找如你是一个对这些东西一窍不通的同学,而且已经在网上查阅了各种资料,还是没做til来加么我吊学母CX文或川以是个终结.MyEcIipseRunWndow环境win7ESqlser还有svR*mywVmvTaeKatauccM*yCoeratUtkM悠mzr*ejnMJ6HfiZXMlTc*Mfrtfawy*(4TyWt*M*WM*v*MV119VWMjMMPJMdnQHeMt*He，jup3224nnMxx*MOTt，rewy,wcrn.twvwh*vbwr*WMtuwf*mv,.tOB*JHUttl./1，MMdCBM*mwemvc8MKIZSPsiKMflM”(BKEtrer*eXE*M*

2、y05*aUOsrMwvMDw(4mrvutrwMMBMMM*IWhmfMf WMfYflttfTCftVMicv*9*gandSTC Mtf*cM*MtargonTcnotnw*IWg!RCPreferences.在冲出的窗I选择MyEclipsc-ApplicationScncrs-Tomcat6（这里选择的tomcat必莒是你已羟胜利安奘的版本）,选择TomcatHomeDirector,右边的Bmwsc”如图Preferencestypefilterte5ctJavaIsMyEdosc三Ap5caboServersTomcat6108.囹.(S国*用ffi.bb.闺08.倒田囹囹BeT

3、igerGefOrtmo1Qasish1.JBoss2JBOSS3JBoss43tty4Mty5xi53Jonas4JRun4OracteASOrion1Orlon2Resin2Resn3SunJaVaSystemAcokattonServSunJavaSystemApplicationServtSunJovaSystemArokotKxiSorvcTOmCdt4TomcatSTomcatServerOEnabteDiMbteTorrtCatIReslorc(efAUUppyIomcatbTomccServerErWeQ5UcI纵QWTOmCaHomeDrectory更l,选疥Eo选齐选择/O

4、racleASOnon13tOrionZR5n2好RK3tSmJavaSystemApatonSetvS3avaSystemApkationServeSunJavaSystemApp4ationServe磁Tcmcat4王T8K&5ITomcate王WeaOggTonxatServernaWaODttabteTocncatHomeDirectoryTomcat8aseDirectoryTomcatTempDrectoryOptionalProgram2qUrnenbC:ITCmCt6.0UITCnK6.0C:ITOnKat6.0telyI族IICanCel选中TomCat6中的JDK一项.这里

5、要特殊留意,默认的是JRE的运行环境，这里要设定成JDKMr否则，MyEdiPSC无法正常部属WCb版用.也无法正常运行IbmartJR务蒙.我们点击Add按钮ereesJDKTcmcatJDKnameIyel.5.0J)6IOptionalJavaVMAfgjrrfent5typeftkcrtext5JavaSystemApPkatSServe*SunAavaSystemARkatigServeTomcat4TomcatSTaOiiavmvnnrr.rMg-nProjectWebProject占VZebServiceProject 1.General品&CVS方e*Java i卷Myfdip

6、e iHQnDevctopmcrtOgho*vAllVzard5.什yreiiCd一领人制111已的，小女也知人WCn心,j（他按默认，选舞Fin认h”完成工程的创建。NewJ2EEWebProjectCreateWebprojectJZfESpwifkaUonlevdOJZEE1.30l4凶AWM*HTM(AdvancedTemplMes)lKJSP(AdverxedTe11dXVAeb.xml附即所三lm.KSm.*，0v0pagelanguagenyavawmport三,java.utll.,rpageEncodlng=,ISO-8859-1,F*Stringpathrequest.ge

7、cConcextPath();StringbasePath三request.gecSchere()+,rzr*+requesc.getServerName()+,r:basehref=,=basePathffKyJSP,KyJsp.jsp,startingpage!一ThisismyJSPpage,单击工具栏中的部泌按钮，如图,MargateSearchProjectMyEdlPSeRunWdowHelp玷的度闻囱国Id少Q,qDepfloyFEdseJ2EEPro)ecttoServer.JICMyJsp.)sppageIangUageNjavalmport三wjava.ucil.*,Str

8、ingpath=request.getContetPath();M-tjvCmj-2cw*11HTuJf新建的工程WcbIest.选择“Add”添加pfoymenitsXManageDeploymentsFNewDeployment出口的（版瑞）Server选项上选并IbmCat6（Ibn心t6必而是你己经DepbyandUndePioJ2EEprojects.配置胜利的服务器）,其他选择默认,选择“Finish”完成服务器的选择，（留意Deploy1.ocation选项，欣认把该工程发布到T0MCAT,IOME%wcbapps1泊卜）oejru口UJtJ1.1.11ycuuw,uuw11cN

9、CyJSP抑口：NTomcat6Startj,ConfigureServerBStop%pagelanguage=,rjava,fimpo出Configure%-Sv%rOtv*=*-Qr,IQotrQwC*tQVtDofl*，、Edt$er，erCameacr，Deioytype:0ExptodsdArchive(devebmertmode)0PaCkdgedArcNve(productionmode)Dely1.ocation:C:Tomcat6.0webapsWebTestEnShICancel出现如下图的界面，衣示该工程部署胜利，选择“0K”完成剖deploymentsManageDe

10、ploymentsDepbyarjundeployJ2EEprojects.眼芬涔后动后,我们可以在限制台上看到服务器启动的信息.如下图表示服分港启动胜利SoireeOcsgnD5nSourcoIEPrecwbtozilaPreviewProWemsTasksWebBreWSer三Consote、ServersXX.：tomc6ServerRemoteJavaAppikationC:Javojdkl,5.0.06bryvw.exe(Oct9,20082:01:28PM)一，*Q.，*wv*，37wv.*w-wwf者息：ReloadingcontextZUebTescJ2008-10-914:3

11、6:17org.apache.coyote.http11.Http11Protocolpausefn.:PausingCoyoteHTTP/1.1onhttp-8080008-10-914:36:19org.apache.catalma.core.ScandardServicestopf三:StoppingserviceCatalina2008-10-914:36:19org.pche.catalma.core.ApplicationContextlog(S息:Session1.istener:ContextDestroyecl()2008-10-914:36:19otg.apache.Cat

12、alina.core.App1IcationContextlog信息:Context1.istener:ContextDestroyedO2008-10-914:36:19org.apache.coyote.http11.HttpllProtocoldestroy信息：StoppingCoyoteHTTP/1.1onhttp-8OO瞅力蓄杉切向，后RJ附诙益，仕埴理於痴人，SUItWWIrTMlII.衣小冽爪肛利。yJsp.jsprstartingpageMicrosoftInternetExplorer文件(E)编辑也)查看也)收藏()工具(I)帮助(由。后退W囹4Q搜索收藏夹，HIlt(Q

13、)蜀http:/bcatost:8080/WebTest/MyJsp.jspThisismyJSPpage.ZJ，cprclcrences-java-lnstallcdJREs如图：QPreferences按进去，然后按Edi3AddExieuUJARs然后选择你放的第动，路径就配置好了.如图:（我的驱动SqIjdbujar是刚在C盘temp文件夹下了gEditJREJREDefinitionSpecifyattributesforaJREJREhome:JREname:DefaultVMArguments:E:Jdvdjdkl.6.0Directory.jdkl.6.0IVariables.

14、JREsystemlibraries: 5C:tempsqljdbc.jar 毡E：Vavajdkl.6.0relibresourccs.jarE:Javadkl.6.0relibrt.pr 岛E:Javajdkl.6.0jrelibjsse.jar E：Vavajdkl.6.0rclibjcejar：窗E:Jevadkl.6.0jrelibcharsets.jarmE:Javajdkl.6.0jrelibextdnsns.jarSE:Javajdkl.6.0relibextlocaledata.jar晨E:Javadkl.6.0relibext$unjcejrovider.jarRE:Jav

15、adkl.6.0relibextsunmscapi.jarEiJavaidkl.6.0ireibextsu11Dkcsll.iarAddExternalJARs.Javadoc1.ocation.SourceAttachment.IRemove!UIDownRestoreDefaultFinishCancelFinish-Xk就行九FileEditSourceRefactorNaQ。二三:PaCkE上TyPIBvWebTest右击Wcb1cst-buildpath-con11gurcbuildpath.propertiestoewoestJavaBuildPithResourceBMiIdEu

16、ildPmh)wCodeSt/eJ*vsCompiler/MEditorJgdolocationMyfclipieProjectRerenceRurVDebugSettirgsWebContentSettirgsWebP*9EdiUX点Sc*tProjrt*MUbfri*jeOffndExportBuidd“pathorderand*aport*dnr:(ExportedentrieserecorAddExternalJARs选择sqljdbc驱动按ok就行f1PropeniforWebTwttypehfttfWsorcBuUersJaWBuildPathJaVaCodeStyleJawCom

17、pilerJavaEditorJavado9EditQrJavaBuildPath.Source.Projects1.ibraries-vOrderandGportJARindcbMdrOntheMdpth:gqdbrsaJREtem1.ibrary(idklA0WebApp1.ibrariesAddJARjAddExtemelJARs.AddVmble.,AddUbrary-AddCsFoAdBAddExternalCUssWde-RemoveMiqreteMR.OKICncrivcr:加毂JDBC郭动StringibUR1.=wjibc:sqlM?rvcr:/localhosi:1433;

18、DaulbaSCNamC-ICSI1”；连接服务器和数据阵心l,你可能得修改一下DdUibaSeName的做，这个数据阵名必需是你刘200,里的StringUserName=*saw:默认用户名，跟你不同，你得改StringuscrPwd=hI23456789m;“密码,跟你不同,你得改ConnectiondbConn;Iry(Class.forName(drivcrNane):dbConn=DrivcrManager.gctConncction(dbUR1.ucrNamc,uscrPwd):Systcm.ut.prinwMycipMfcMpr一、，al9Big(-u*QQQ曲*,0夕口Uq.

19、*JWCYfQw赢口4I1QQBB一HoorototodpU/MZn.exv,trrek*,VMtrA4Wt3vSYWVS.Okg卜要位M刻比喋人简子们屏住呼吸拉F运行的那个绿色小：角!tvukcCCIcMZgymc9wmirrvyct(vfCiMJiEESUIMieAWebApplrr5!_ProMmZTkWebBrOWVbjOCoMMXffVEt*minMd*TettJ*vWbRoXCf33ConfMCtionSuccessful!里见卜边的那个ConnectionSuccessful!欢呼吧也年!下边是怆出数据库的数据的一个j卬代眄：%Connectioncon;Stringquery=

20、*select*froms;try(Class.forName(,com.microsoft.Sqlserver.jdbc.SQ1.ServerDriverM);catch(ClassNotFoundEceptione)out.print(e);)trycon三DriverManager.getConnection(jdbc:sqlserver:/localhost:1433;DatabaseName=testl-,-sa-,123456789);Statementstmt三con.CreateStatement();创注对象ResultSetresult=stmt.executeQuery(

21、query);/何结果的用queryStlnt.executeQuery(query)执行语句while(()(out.println(result.getString(l);out.pri11tl11(result.getString(2);out.println(result.getString(3);out.println(result.getString(4);out.println();)con.close();第1、Sj：11234567981j,.testl个你依据实际状况改写)catch(SQ1.Exceptione)out.print(e);%建立一个jsp文件MyJSPIJ

22、sp把代码考进去.运行tomcat(上边那个小三角的边已经介绍过/)然后在阅读器中蚪入我的会出现卜边的状况:；，T随主httplocalhost8080-xsi精益20天津三2盛德10北京三3东方红30北京三4丰泰盛20天津55为民30上海s9成德50石家庄tStudio直JS设计器(R)IS(T)E(W)社区(C)S%（三），曲目整5才正9fi三匕囱名表dbo.s搐要1.Sosnamestatusdty1哥益20天津*2SW北京S3东方红30北京4丰泰SS20天津SS力民30上海9国德50石京庄&NU1.1.UZNU1.1.NUUOoOoOooOooOooCnn=DriverMinager.

23、gelConnec(ion(dbUR1.UserNarne.UWrPWd):Systcm.out.println(*ConncctonSuccessful!*);假如连接胜利限制分输出ConnectionSuccessful!catch(Eixceplione)(c.prnlStackracc();步骤:放置驱动得到驱动用QagMName（驱动的类名,不同种不一样5创建连接ConnectionCOnn=DrivCrManager.gaCoimectionC.二）:三个参数是ip.用户名密码创建过程Statementst=conn.crcatcStatcmcnt():stm.cxccutcUpd

24、acc(qucry1);stm.closedw11.mic11s!l.sqlserver.jdtxr.SQ1.ServerDrivcr);加税呼动Connection8n=DrivcrManagEgctConncction(rlJsa,l234567S9);连接数据库Scaicmcntstmt=con.crcatcStatcmcnt();创建对象ResuhSeirvsult=s(mt.execuieQuerj,(quefy);有返回结果的JIJquerystml.exccu(eQuery(qucry)执行语句Whildrcsult.ncxt(Syslemu1.p11ntln(rcsuh.gelSlring(1):j:Istmt.executeUdace(queryI);没有返回结果的用updateStm1.executcQuery(query2):stmt.closc():con.closc();ICiHCh(SQ1.EXceP【沁nex)!citch(java.Iang.Exceplionex)cx.printStackTracc();学的是一种心态，一种无所设惧的心态，深信自己肯定能办成某件小！学计算机的孩子漂亮有三种：一是美BHll效的代码结构，二是巧夺天工的奇妙算法，三是眼和世界的你的笑容.加油电ill