電子實(shí)驗(yàn)報(bào)告劉抗洪

實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)日期:課程名稱：JSP程序設(shè)計(jì)班級(jí)：學(xué)號(hào)：姓名：實(shí)驗(yàn)名稱：使用JDBC連接數(shù)據(jù)庫(kù)。（其中需要舉出至少三種數(shù)據(jù)庫(kù)連接的方法）。完成數(shù)據(jù)全部查詢操作。照片：實(shí)驗(yàn)?zāi)康模簩?shí)驗(yàn)器材：實(shí)驗(yàn)步驟:第一種方法：連接SQLServer2005數(shù)據(jù)庫(kù)〃導(dǎo)入一些與文件有關(guān)的代碼importjava.sql.Connection;in^ortjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicclassDB(//數(shù)據(jù)醫(yī)連接SQLSeser2005數(shù)揖庫(kù)privateStringurl=Rjdbc:aqlserver://IocaIhost:1133;Databa5eName=TR5tR;指導(dǎo)老師點(diǎn)評(píng):評(píng)予等級(jí):指導(dǎo)老師簽名:評(píng)予等級(jí):指導(dǎo)老師簽名:privateStringurl=pjdbc:sqlseiver://localho5t:1433;Databa5etae=Te5ti;〃艇鐲腳耨役privateString￡1188113110=*00!?jicrosoft.sqlsemr.jdbc.SQLServerDriver1;privatesuing蛾曬即也”;privateStringpas5ward="]23356,,;“WWcwmectio而HprivateConnectionC0nn=null;//再粘土tatement據(jù)privateStatementstrotrnull;「耐瞬幽publicDB()(tryl〃螂黜廨鼠classJorNnetclassName),n翎instance。;Icatch(Exceptione)(e.piintStackTraceO;Sy業(yè)me此piintlnf皿瞰髀蠣悅5!);八細(xì)麒軸/publicvoidCieateConn()(t班〃觸連隹隹翅由屬性也指就撤據(jù)隹師號(hào)指超錄掰睥的酈咤相密科conn=DriYerHanager.getC(?!]nectiQn(urlruseinaine,password);}catch(Exceptione)(e.piintStackTracef);("獲取數(shù)據(jù)庫(kù)連接失??！”)；八獲取先atement對(duì)象，/publicvoidgetStmt()(CreateConn();//調(diào)用匚reatiC，:」，()方法，連接期國(guó)5try(〃調(diào)用Connectiot：類實(shí)例的croatoStatement()方法獲取一個(gè)Stagmant類對(duì)款stmt=conn.createStatement();}catch(Exceptione){e.printstackTrace();創(chuàng)建Statement對(duì)象失敗!M);廠對(duì)數(shù)據(jù)庫(kù)迸行增加、修改和刪除等操作,由雙語(yǔ)句決定*/publicbooleanexecuteUpdate(Stringsql)(booleanmark=false;try1getStmt();〃創(chuàng)注一個(gè):f對(duì)象mtiCount=stmt.GxecutGUpdate(3ql);//執(zhí)行更郛操作.并獲取所影響的記錄數(shù)if(icount>0)//更新數(shù)據(jù)摩成功mark5true;elsemark1false;)catch(Exceptione)(G.printStackTrace();mark=false;returnmark;)八點(diǎn)詢數(shù)據(jù)庫(kù),由匈語(yǔ)句決定?/publicResultSGtexecutGQuery(Stringsql)(ResultSetrs=nxill;trylgetStmt();〃創(chuàng)建一個(gè)；La，?：it類對(duì)象rs=stmt.exGcut?Query(sql);//亙?cè)冃?jù)庫(kù)獲取符合條件的記錄,并將結(jié)奧8s給生合一Jcatch(Exceptione)(e.printStackTraceO;returnrs;importjava.sql.1;publicclassJDBCMysql〃騾動(dòng)程序名publicstatic〃數(shù)據(jù)摩用戶名importjava.sql.1;publicclassJDBCMysql〃騾動(dòng)程序名publicstatic〃數(shù)據(jù)摩用戶名publicstatic//MySQL帳號(hào)publicstatic//HySQLCHpublicstaticfinalStringfinalStringfinalStringfinalStringDBDRIVER=wCGm.my3q;.jdbc.Driver";DBURL=**jdbczniysql://localhost:3306/llwuliu";DBUSER?"root"；DBPASS="root"；Connectionconn=null;//此接口用來(lái)連接數(shù)據(jù)庫(kù)Statementstmt=null;//此接口用來(lái)操作數(shù)據(jù)庫(kù)(增、刪、改、查)ResultSetres=null;//此接口用來(lái)保存數(shù)據(jù)庫(kù)蜜詢操作的結(jié)果集合try(Class.forName(DBDRIVER);〃反射出一個(gè)mysql的馬區(qū)動(dòng)類conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);〃System.out.println("MySq]數(shù)據(jù)庫(kù)已經(jīng)正常連接："+conn);}catch(ClassNotFoundExceptione)(Sy$tMO%pHMlD(喂有找蹦動(dòng)類)catch(SQLExceptione)|SysteiuOuL叩口5(“隨岸跳頰”)；JtrytSystM◎t.pri眥—朝喘內(nèi)就用"—stat=conn,createstatsmentO;Stringsql="SElJiCT?trainfo11;res=stmt.execut?Query(sql>;while(res.next(H(Systen.out.printIn("IH:Ntres.getlnt(1)?"姓名:"?res.getString(2)密碼：w4-re3.getstring(3)+"年齡：”+r03.gNint<4));)System.out.println(*???**?,**10加新內(nèi)容*w);sql=-INSERTINTOinfo(name,pass,age)VALUES「高手'，?skilful',24)”；stwt.?xecuteUpdate(sql);sql="SELECT*FROMinfo"；res=stmt.oxecuteQuery(sql>;while(res.next())(System,out.printin"^res.getlnt<1)+"姓名："res.getstring(2)+”res.getString(3)+"年齡："res.getlnt(4));)catch(SQLExceptionel){el.printStackTrace();)try(if(res!=null){res.close();//關(guān)閉數(shù)據(jù)庫(kù)res=null;}if(stmt!=null){stmt.close();//關(guān)閉數(shù)據(jù)庫(kù)stmt=null;}if(conn!=null){conn.close{);//關(guān)閉數(shù)據(jù)庫(kù)conn=null;)}catch(Exceptione){System.out.printin(”數(shù)據(jù)庫(kù)關(guān)閉錯(cuò)誤!H);))1第三種數(shù)據(jù)庫(kù)連接：連接ACCESS數(shù)據(jù)庫(kù)?'1?ajftlanguage=wjavdwimport=*rjcjva.uti2.*wpageEncod:ng=nGBK"<二@pageimport=*java.sql.*"*>々加我驅(qū)動(dòng)程序publicstaticfinalStringDBDRIVER=**3un.jdbc.odbc.JclbcOdbcDriver**;〃數(shù)據(jù)庫(kù)連接字符串publicstaticStringDBURL=njdbc:odbc;Driver=(MicrosoftAccessDriver上唧)哦畤//Access施朝陛能瓠腔publicstaticfinalString咖SER="n俯闞懶翦施嬲publicstaticfinalStringDBPASS=""Connectionccnn=null;PreparedStatenentpstn=null;//ResultSetrs=null;booleanflag=false;String由path=application.getRealPath(rt\\：atabase\\DatataseIndb");Stringurl=DBURL+dbpath;Class.forName(DBDRIVER);〃java反射機(jī)制，也就是說(shuō)，根據(jù)一個(gè)對(duì)象反過(guò)來(lái)生成一介類??！conn=DriverManager.getConnection(url,DBUSER,DBPASS);//jdbc:subproto