JDBC的操作数据库汇总.docVIP

一、SQL语言回顾 1、Select select * from T where … 2、Insert insert into T values(…) 3、Create create table T(…) 4、Delete delete from T where… 5、Update update T set t1=… and t2=.. where t3=… 6、Drop drop table T 二、JDBC编程步骤 1、Load the Driver Class.forName( )|Class.forName( ).newInstance( )|new DriverName( ) 实例化时自动向DriverManager注册，不需显式调用DriverManager.registerDriver方法 2、Connect to the DataBase DriverManager.getConnection( ) 3、Execute the SQL Connection.CreateStatement( ) Statement.executeQuery( ) Statement.executeUpdate( ) 4、Retrieve the result data 循环取得结果while(rs.next( )) 5、Show the result data 将数据库中的各种类型转换为Java中的类型(getXXX)方法 6、Close Close the resultset ./ close the statement / close the connection 三、JDBC操作oracle数据库 1、 JDBC连接oracle数据库： import java.sql.*; public class TestJDBC { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName(oracle.jdbc.driver.OracleDriver); //new oracle.jdbc.driver.OracleDriver(); Connection conn = DriverManager.getConnection(jdbc:oracle:thin:@:1521:solid, scott, tiger); } } 2、 向数据库中取字段，遍历数据库，并显示出相应字段： import java.sql.*; public class TestJDBC { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName(oracle.jdbc.driver.OracleDriver); //new oracle.jdbc.driver.OracleDriver(); Connection conn = DriverManager.getConnection(jdbc:oracle:thin:@:1521:solid, scott, tiger); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from dept); while(rs.next()) { System.out.println(rs.getString(deptno)); System.out.println(rs.getInt(deptno)); } rs.close(); stmt.close(); conn.close(); } } 3、 捕捉相关异常，完善JDBC编程： import java.sql.*; public class TestJDBC { public static void main(String[] args) throws ClassNotFoundException, SQLException { ResultSet r