oracle_10课件.ppt

第十章JDBC操作oracle数据库;10.1基本的数据库准备;手动建立ODBC数据源;import java.sql.*; public class example61{ public static void main(String args[]){ Connection con; Statement sql; ResultSet rs; try{ Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);} catch(ClassNotFoundException e){ System.out.println( +e); } try{ con=DriverManager.getConnection(jdbc:odbc:test1,scott,tiger); sql=con.createStatement(); rs=sql.executeQuery(select * from emp); while(rs.next()) { System.out.println( 姓名：+rs.getString(1)); System.out.println( 性别：+rs.getString(2)); System.out.println( 电子邮箱：+rs.getString(3)); } con.close(); } catch(SQLException e){ System.out.println(e); } } }; 设置驱动相关环境; 重要的接口; JDBC访问数据库的基本步骤; JDBC访问数据库的基本步骤;;;; 使用PreparedStatement; 使用CallableStatement;;;;public class test10_1 { Connection conn=null; try { Class.forName(oracle.jdbc.driver.OracleDriver); String url=jdbc:oracle:oci8:@; conn=DriverManager.getConnection(url,system,zhongguo); Statement st=conn.createStatement(); ResultSet rs=st.executeQuery(select * from myaddress); while(rs.next()) { out.println( +rs.getString(1)); out.println( +rs.getString(2)); out.println( +rs.getString(3)); out.println(br); } } catch(Exception e) { out.println(some error); out.println(e.getMessage()); } finally { conn.close(); } };10.3JDBC数据库驱动对象;/*01*/import java.sql.*; /*02*/public class MyOracleDriverReg /*03*/{ /*04*/ static /*05*/ { /*06*/ new MyOracleDriverReg(); /*07*/ } /*08*/ public MyOracleDriverReg() /*09*/ { /*10*/ try /*11*/ { /*12*/ oracle.jdbc.driver.OracleDriver mydriver=null; /*13*/ mydriver=new oracle.jdbc.driver.OracleDriver() ; /*14*/ DriverManager.registerDriver(mydriver); /*15*/ }catch(Exception e){}; /*16*/ } /*17*/};;import java.sql.*; class dbAccess { public static void main(String args [])throws SQLException {