DBUtils工具

1、在jdbc库中创建user表

2、复制JDBCUtils.java文件到cn.itcast.chapter10.example包下
3、在包中创建baseDao类

package cn.itcast.chapter10.example;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.commons.dbutils.ResultSetHandler;

public class baseDao {
public static Object query(String sql,ResultSetHandler rsh,Object...params) throws SQLException {
	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	Object obj=null;
	try {
		conn=JDBCUtils.getConnection();
		pstmt=conn.prepareStatement(sql);
		for(int i=0;params!=null && i 
4、创建User类
 
package cn.itcast.chapter10.example;

public class User {
private int id;
private String name;
private String password;
public int getId() {
	return id;
}
public void setId(int id) {
	this.id=id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name=name;
}
public String getPassword() {
	return password;
}
public void setPassword(String password) {
	this.password=password;
}
}

 
5、创建ResultSetTest1、2、3、4这4个类
 
package cn.itcast.chapter10.example;
import java.sql.DatabasemetaData;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;


import java.sql.Connection;
public class example01 {
public static DataSource ds=null;
static {
	BasicDataSource bds=new BasicDataSource();
	bds.setDriverClassName("com.mysql.jdbc.Driver");
	bds.setUrl("jdbc:mysql://localhost:3306/jdbc");
	bds.setUsername("root");
	bds.setPassword("123456");
	bds.setInitialSize(5);
	bds.setMaxActive(5);
	ds=bds;
}
public static void main(String[] args) throws SQLException {
	Connection conn=ds.getConnection();
	DatabasemetaData metadata=conn.getmetaData();
	System.out.println(metadata.getURL()+",UserName="+metadata.getUserName()+","+metadata.getDriverName());
}
}

 
package cn.itcast.chapter10.example;

import java.io.InputStream;
import java.sql.DatabasemetaData;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

import java.sql.Connection;

public class example02 {
public static DataSource ds=null;
static {
	Properties prop=new Properties();
	try {
		InputStream in=new example02().getClass().getClassLoader().getResourceAsStream("dbcp.properties");
		prop.load(in);
		ds=BasicDataSourceFactory.createDataSource(prop);
	}catch (Exception e) {
		e.printStackTrace();
	}
}
public static void main(String[] args) throws SQLException{
	Connection conn=ds.getConnection();
	DatabasemetaData metadata=conn.getmetaData();
	System.out.println(metadata.getURL());
	System.out.println(metadata.getUserName());
	System.out.println(metadata.getDriverName());
}
}

 
package cn.itcast.chapter10.example;
 
import java.beans.PropertyVetoException;
 import java.sql.Connection;
 import java.sql.DatabasemetaData;
 import java.sql.SQLException;
 
import javax.sql.DataSource;
 
import com.mchange.v2.c3p0.ComboPooledDataSource;
 
public class example03 {
 public static DataSource ds=null;
 static {
 ComboPooledDataSource cpds=new ComboPooledDataSource();
 try {
 cpds.setDriverClass(“com.mysql.jdbc.Driver”);
 cpds.setJdbcUrl(“jdbc:mysql://localhost:3306/jdbc”);
 cpds.setUser(“root”);
 cpds.setPassword(“123456”);
 cpds.setInitialPoolSize(5);
 cpds.setMaxPoolSize(10);
 ds=cpds;
 }catch(PropertyVetoException e) {
 e.printStackTrace();
 }
 }
 public static void main(String[] args) throws SQLException{
 Connection conn=ds.getConnection();
 DatabasemetaData metadata=conn.getmetaData();
 System.out.println(metadata.getURL());
 System.out.println(metadata.getUserName());
 System.out.println(metadata.getDriverName());
 
}
 }
 

 
package cn.itcast.chapter10.example;
 
import java.sql.Connection;
 import java.sql.DatabasemetaData;
 import java.sql.SQLException;
 
import javax.sql.DataSource;
 
import com.mchange.v2.c3p0.ComboPooledDataSource;
 
public class example04 {
 public static DataSource ds=null;
 static {
 ComboPooledDataSource cpds=new ComboPooledDataSource(“dashuju”);
 ds=cpds;
 }
 public static void main(String[] args) throws SQLException{
 Connection conn=ds.getConnection();
 DatabasemetaData metadata=conn.getmetaData();
 System.out.println(metadata.getURL());
 System.out.println(metadata.getUserName());
 System.out.println(metadata.getDriverName());
 }
 }
 
6、实现效果