JavaEEWEB工程师培训1.docVIP

Java EE WEB工程师培训 发表于2009-6-2 21:37|来自 51CTO网页 [只看他] 结果集的MetaData ? ResultSet的getMetaData方法返回结果集元数据对象ResultSetMetaData 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; } } TestMetaData.java package com.michael.jdbc;