DBCP工具类

package jdbc;


import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;
/*
 * JDBC工具类  连接数据库  关闭资源
 */
public class DBCPUtils {
	private static String driverClass;
	private static String url;
	private static String username;
	private static String password;
	private static Connection con;
	private static InputStream in = null;
	static {
		try {
			readProperties();
			Class.forName(driverClass);
			con = DriverManager.getConnection(url, username, password);
		} catch (Exception e) {
			// TODO: handle exception
			throw new RuntimeException(e.getStackTrace()+"连接数据库失败");
		}finally {
			if(in != null) {
				try {
					in.close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
	}
	//返回connection数据库的连接
	public static Connection getConnection() {
		return con;
	}
	
	//读取properties文件
	public static void readProperties() throws Exception{
		in =  JDBCConfig.class.getClassLoader().getResourceAsStream("database.propertise");
		Properties pro = new Properties();
		pro.load(in);
		driverClass = pro.getProperty("driverClass");
		url = pro.getProperty("url");
		username = pro.getProperty("username");
		password = pro.getProperty("password");
	}
	
	
	//关闭资源 针对查询的资源删除
	public static void close
	(ResultSet rs , Statement stat , Connection con ) {
		if(rs != null) {
			try {
				rs.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		
		if(stat != null) {
			try {
				stat.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		if(con != null) {
			try {
				con.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	

}

propertise文件

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybase
username=root
password=root