dbcontrol.java

tapestry json 实现从数据库读取数据生成树

package com.datasource;
/**==========================================================================
 * 模块名:数据库连接池		文件名:DBControl.java
 * 功能描述: 控制连接池中连接数量的获取和回收,保证并发安全
 * @author ouzl; date:2008-04-09
 * =================================== 修改历史 =============================
 * 
 * =========================================================================
 */

import java.io.IOException;
import java.sql.Connection;
import java.util.Properties;

public class DBControl {

		private static DBControl dbc;
		
		private DBSource dbs = null;

		private String poolSize;

		private String url;

		private String user;

		private String passwd;

		private String driverClassName;



		Properties config = new Properties();

		private DBControl() {
			try {
				config.load(getClass().getResourceAsStream("jdbc.property"));
				this.url = config.getProperty("url").trim();
				this.user = config.getProperty("username").trim();
				this.passwd = config.getProperty("password").trim();
				this.driverClassName = config.getProperty("driverClassName").trim();
				this.poolSize = config.getProperty("poolsize").trim();
			} catch (IOException e) {
				System.out.println("=========没有找到配置文件=========");
				e.printStackTrace();
			} catch (Exception e) {
				System.out.println("=========未知异常(DBControl)=========");
				e.printStackTrace();
			}
			//为连接池创建初始数量的连接
			dbs = new JDBCDBSImp(url, user, passwd, driverClassName,Integer.parseInt(poolSize));
			
		}

		public static DBControl getInstance() {
			if(dbc == null){
				dbc = new DBControl();
			}
			return dbc;
		}

		public Connection getConn() {
			return this.dbs.getConnection();
		}
		
		public void putConn(Connection conn){
			this.dbs.putConnection(conn);
		}
}