JavaEEWEB工程师讲训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加载 HYPERLINK 水草玛瑙 驱动 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获得连接