電子實驗報告劉抗洪

實驗報告實驗日期:課程名稱：JSP程序設(shè)計班級：學(xué)號：姓名：實驗名稱：使用JDBC連接數(shù)據(jù)庫。（其中需要舉出至少三種數(shù)據(jù)庫連接的方法）。完成數(shù)據(jù)全部查詢操作。照片：實驗?zāi)康模簩嶒炂鞑模簩嶒灢襟E:第一種方法：連接SQLServer2005數(shù)據(jù)庫〃導(dǎo)入一些與文件有關(guān)的代碼importjava.sql.Connection;in^ortjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;publicclassDB(//數(shù)據(jù)醫(yī)連接SQLSeser2005數(shù)揖庫privateStringurl=Rjdbc:aqlserver://IocaIhost:1133;Databa5eName=TR5tR;指導(dǎo)老師點評:評予等級:指導(dǎo)老師簽名:評予等級:指導(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!);八細麒軸/publicvoidCieateConn()(t班〃觸連隹隹翅由屬性也指就撤據(jù)隹師號指超錄掰睥的酈咤相密科conn=DriYerHanager.getC(?!]nectiQn(urlruseinaine,password);}catch(Exceptione)(e.piintStackTracef);("獲取數(shù)據(jù)庫連接失?。　?；八獲取先atement對象，/publicvoidgetStmt()(CreateConn();//調(diào)用匚reatiC，:」，()方法，連接期國5try(〃調(diào)用Connectiot：類實例的croatoStatement()方法獲取一個Stagmant類對款stmt=conn.createStatement();}catch(Exceptione){e.printstackTrace();創(chuàng)建Statement對象失敗!M);廠對數(shù)據(jù)庫迸行增加、修改和刪除等操作,由雙語句決定*/publicbooleanexecuteUpdate(Stringsql)(booleanmark=false;try1getStmt();〃創(chuàng)注一個:f對象mtiCount=stmt.GxecutGUpdate(3ql);//執(zhí)行更郛操作.并獲取所影響的記錄數(shù)if(icount>0)//更新數(shù)據(jù)摩成功mark5true;elsemark1false;)catch(Exceptione)(G.printStackTrace();mark=false;returnmark;)八點詢數(shù)據(jù)庫,由匈語句決定?/publicResultSGtexecutGQuery(Stringsql)(ResultSetrs=nxill;trylgetStmt();〃創(chuàng)建一個；La，?：it類對象rs=stmt.exGcut?Query(sql);//亙詢效據(jù)庫獲取符合條件的記錄,并將結(jié)奧8s給生合一Jcatch(Exceptione)(e.printStackTraceO;returnrs;importjava.sql.1;publicclassJDBCMysql〃騾動程序名publicstatic〃數(shù)據(jù)摩用戶名importjava.sql.1;publicclassJDBCMysql〃騾動程序名publicstatic〃數(shù)據(jù)摩用戶名publicstatic//MySQL帳號publicstatic//HySQLCHpublicstaticfinalStringfinalStringfinalStringfinalStringDBDRIVER=wCGm.my3q;.jdbc.Driver";DBURL=**jdbczniysql://localhost:3306/llwuliu";DBUSER?"root"；DBPASS="root"；Connectionconn=null;//此接口用來連接數(shù)據(jù)庫Statementstmt=null;//此接口用來操作數(shù)據(jù)庫(增、刪、改、查)ResultSetres=null;//此接口用來保存數(shù)據(jù)庫蜜詢操作的結(jié)果集合try(Class.forName(DBDRIVER);〃反射出一個mysql的馬區(qū)動類conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);〃System.out.println("MySq]數(shù)據(jù)庫已經(jīng)正常連接："+conn);}catch(ClassNotFoundExceptione)(Sy$tMO%pHMlD(喂有找蹦動類)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ù)庫res=null;}if(stmt!=null){stmt.close();//關(guān)閉數(shù)據(jù)庫stmt=null;}if(conn!=null){conn.close{);//關(guān)閉數(shù)據(jù)庫conn=null;)}catch(Exceptione){System.out.printin(”數(shù)據(jù)庫關(guān)閉錯誤!H);))1第三種數(shù)據(jù)庫連接：連接ACCESS數(shù)據(jù)庫?'1?ajftlanguage=wjavdwimport=*rjcjva.uti2.*wpageEncod:ng=nGBK"<二@pageimport=*java.sql.*"*>々加我驅(qū)動程序publicstaticfinalStringDBDRIVER=**3un.jdbc.odbc.JclbcOdbcDriver**;〃數(shù)據(jù)庫連接字符串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ù)一個對象反過來生成一介類！！conn=DriverManager.getConnection(url,DBUSER,DBPASS);//jdbc:subproto