dbpool.java

基于j2ee中structs写软件

package com.util;

import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;


public class DBPool {
	private static DBPool instance=null;
	public static synchronized Connection getConnection(){
		if(instance==null){
			instance=new DBPool();
		}
		return instance._getConnection();	
	}
	private DBPool(){
		super();
	}
	private Connection _getConnection(){
		try{
			String sDBDriver=null;
			String sConnection=null;
			String sUser=null;
			String sPassword=null;
			Properties p=new Properties();
			InputStream is=getClass().getResourceAsStream("com.yourcompany.struts/db.properties");
			p.load(is);
			sDBDriver=p.getProperty("DBDriver",sDBDriver);
			sConnection=p.getProperty("Connection",sConnection);
			sUser=p.getProperty("User", "");
			sPassword=p.getProperty("Password", "");
			Properties pr=new Properties();
			pr.put("user", sUser);
			pr.put("password", sPassword);
			pr.put("characterEncoding", "GB2312");
			pr.put("useUnicode", "TRUE");
			Class.forName(sDBDriver).newInstance();
			return DriverManager.getConnection(sConnection,pr);
		}catch(Exception e){
			System.out.print(e);
			return null;
		}
	}
	public static void dbClose(Connection conn,Statement sm,ResultSet rs)throws SQLException{
		rs.close();
		sm.close();
		conn.close();
	}

}