JDBC详解_PPT.pptVIP

例1、使用JDBC-ODBC桥驱动程序 前提 运行程序的计算机上安装了ODBC驱动；配置了数据源；装有JDK 步骤 1.加载驱动 Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); 2.得到连接Connection ct = DriverManager.getConnection(jdbc.odbc:testConnectOracle, scott, tiger); 3.创建语句对象Statement sm = ct.createStatement(); 4.获取结果ResultSet rs = sm.executeQuery(select * from emp); 5.处理结果while (rs.next()) {System.out.println(用户名： +rs.getString(2));} 6.关闭对象rs.close();smclose();cn.close(); 例2、使用纯JDBC驱动 try { Class.forName(oracle.jdbc.driver.OracleDriver); Connection ct = DriverManager.getConnection(jdbc:oracle:thin:@:1521:orcl, scott, tiger); Statement sm = ct.createStatement(); ResultSet rs = sm.executeQuery(select * from emp); while (rs.next()) { System.out.println(用户名： +rs.getString(2)); } } catch (Exception e) { e.printStackTrace(); } finally{ //关闭对象 } } } 使用预编译语句对象提高性能（DML语句） PreparedStatement pstmt = conn.prepareStatement (insert into EMP (EMPNO, ENAME) values (?, ?)); // Add LESLIE as employee number 1500 pstmt.setInt (1, 1500); // The first ? is for EMPNO pstmt.setString (2, LESLIE); // The second ? is for ENAME pstmt.execute (); // Add MARSHA as employee number 507 pstmt.setInt (1, 507); // The first ? is for EMPNO pstmt.setString (2, MARSHA); // The second ? is for ENAME pstmt.execute (); // Close the statement pstmt.close(); con.close(); Conection Statement PrepareStatement CallableStatement Data Type Result prepareCall createStatementl prepareStatementl excuteQuery excuteUpdate getXXXX 整数 五、数据库、jdbc、java类型之间的映射 六、JDBC中的流处理 三种流 binary stream－Used for RAW bytes of data. This corresponds to the getBinaryStream() method. ASCII stream－Used for ASCIIbytes in ISO-Latin-1 encoding. This corresponds to the getAsciiStream() method. Unicode stream－Used for Unicode bytes with the UTF-16 encoding. This corresponds to the getUnicodeStream() method. 如果一次查询返回多个列，其中有一个或多个流，则在前面的留处理结束前，后面的列不能处理。如果遇到不想处理的流，则可以直接将该流close()。建议按顺序读取数据；注意流一旦读取就不能再读了； 流处理LO