Java EE EB工程师培训_5.docVIP

Java EE WEB工程师培训 发表于2009-6-8 06:22|来自 51CTO网页 [只看他] ? 设置可滚动ResultSet –为了获得可滚动ResultSet，我们必须用如下的方式来创建Statement或者PreparedSatement ? 滚动ResultSet –rs.previous –rs.relatice n –rs.absolute n –rs.getRow –rs.first –rs.last –rs.beforeFirst –rs.afterLast –rs.isFirst –rs.isLast –rs.isBeforeFirst –rs.isAfterLast ConnectionUtil.java package com.michael.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.util.Properties; public class ConnectionUtil 第一种方法 public Connection getConnection Connection conn null; try Class.forName加载水草玛瑙 驱动 Class.forName com.mysql.jdbc.Driver ; DriverManager获得连接 conn DriverManager.getConnection jdbc:mysql:localhost:3306jdbc_db , root , mysqladmin return conn; catch Exception e e.printStackTrace ; return null; 第二种方法 public Connection getConnection String driver,String url,String user,String password Connection conn null; try Class.forName加载驱动 Class.forName driver ; DriverManager获得连接 conn DriverManager.getConnection url,user,password ; return conn; catch Exception e e.printStackTrace ; return null; 第三种方法 public Connection openConnection String driver String url String user String password Properties prop new Properties ; Connection conn null; try 加载属性文件 prop.load this.getClass .getClassLoader .getResourceAsStream DBCperties ; driver prop.getProperty driver ; url prop.getProperty url ; user prop.getProperty user ; password prop.getProperty password ; Class.forName加载驱动 Class.forName driver ; DriverManager获得连接 conn DriverManager.getConnection url,user,password ; return conn; catch Exception e e.printStackTrace ; return null; TestResultSet.java package com.michael.jdbc; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestResultSet public static void test Connection conn new ConnectionUtil .openConnection ; try Statement stmt conn.createStatement ResultSet.TYPE_SCROLL_SENSITIVE, Re