一課資料網(wǎng)/在Java程序中通過(guò)JDBC操作數(shù)據(jù)庫(kù)一般分為以下幾個(gè)步驟。（1）將數(shù)據(jù)庫(kù)的JDBC驅(qū)動(dòng)加載到classpath中，在給予Java EE的Web應(yīng)用實(shí)際開(kāi)發(fā)過(guò)程中，通常要把目標(biāo)數(shù)據(jù)庫(kù)產(chǎn)品的JDBC驅(qū)動(dòng)復(fù)制到WEB-INF/lib下。（2）加載JDBC驅(qū)動(dòng)，并將其注冊(cè)到DriverManager中。下面是一些主流數(shù)據(jù)庫(kù)的JDBC驅(qū)動(dòng)加載注冊(cè)的代碼： /Oracle8/8i/9i數(shù)據(jù)庫(kù)（thin模式）Class.forName(oracle.jdbc.driver.OracleDriver).newInstance(); /Sql7.0/2000數(shù)據(jù)庫(kù)Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver).newInstance();/DB2數(shù)據(jù)庫(kù)Class.forName(com.ibm.db2.jdbc.app.DB2Driver).newInstance(); /Informix數(shù)據(jù)庫(kù)Class.forName(rmix.jdbc.IfxDriver).newInstance(); /Sybase數(shù)據(jù)庫(kù)Class.forName(com.sybase.jdbc.SybDriver).newInstance(); /MySQL數(shù)據(jù)庫(kù)Class.forName(com.mysql.jdbc.Driver).newInstance(); /PostgreSQL數(shù)據(jù)庫(kù)Class.forName(org.postgresql.Driver).newInstance();（3）建立數(shù)據(jù)庫(kù)連接，取得Connection對(duì)象。例如： /Oracle8/8i/9i數(shù)據(jù)庫(kù)（thin模式）String url=jdbc:oracle:thin:localhost:1521:orcl;String user=scott;String password=tiger;Connection conn=DDriverManager.getConnection(url,user,password); /Sql7.0/2000數(shù)據(jù)庫(kù)Stringurl=jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=pubs; String user=sa;String password=;Connection conn=DDriverManager.getConnection(url,user,password); /DB2數(shù)據(jù)庫(kù)String url=jdbc:db2:/localhost:5000/sample;String user=admin;String password=;Connection conn=DDriverManager.getConnection(url,user,password); /Informix數(shù)據(jù)庫(kù)Stringurl=jdbc:informix-sqli/localhost:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword;Connection conn=DDriverManager.getConnection(url);/Sybase數(shù)據(jù)庫(kù)String url=jdbc:sybase:Tds/localhost:5007/tsdata;Properties sysProps=System.getProperties();sysProps.put(user,userid);sysProps.put(password,user_password);Connection conn=DDriverManager.getConnection(url,sysProps);/MySQL數(shù)據(jù)庫(kù)String url=jdbc:mysql:/localhost:3306/testDB?user=root&password=&useUnicode=true&characterEncoding=gb2312;Connection conn= DriverManager.getConnection(url);/PostgreSQL數(shù)據(jù)庫(kù)String url =jdbc:postgresql:/localhost/testDB;String user=myuser;String password=mypassword;Connection conn= DriverManager.getConnection(url,user,password);（4）建立Statement對(duì)象或PreparedStatement對(duì)象。例如： /建立Statement對(duì)象Statement stmt=conn.creatStatement();/PreparedStatement對(duì)象String sql=select * from users where userName=? and password=?; PreparedStatement pstmt=conn.prepareStatement(sql);pstmt.setString(admin);pstmt.setString(liubin);（5）執(zhí)行SQL語(yǔ)句。例如：/執(zhí)行靜態(tài)SQL查詢String sql=select * from users;ResultSet rs=stmt.executeQuery(sql);/執(zhí)行動(dòng)態(tài)SQL查詢ResultSet rs=pstmt.executeQuery();/執(zhí)行insert,update,delete等語(yǔ)句，先定義sqlstmt.executeUpdate(sql);（6）訪問(wèn)結(jié)果記錄集ResultSet對(duì)象。例如：While(re.next()out.println(你的第一個(gè)字段內(nèi)容為：+rs.getString(1)out.println(你的第二個(gè)字段內(nèi)容為：+rs.getStrin