clienttest.java

使用java语言开发的数据库连接池程序

package com.chunkyo.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class ClientTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		DBConnectionManager dbManager = new DBConnectionManager();
		Connection conn1 = null;
		Connection conn2 = null;
		try{
		
		conn1 = dbManager.getConnection("oraclePool");
		conn2 = dbManager.getConnection("oraclePool");
		String sql1 = "select count(*) from bhmc_user";
		String sql2 = "select count(*) from dealer";
		
		Statement stat1 = conn1.createStatement();
		ResultSet resultSet1 = stat1.executeQuery(sql1);
		Statement stat2 = conn2.createStatement();
		ResultSet resultSet2 = stat2.executeQuery(sql2);
		while(resultSet1.next()){
			System.out.println("user count is :" + resultSet1.getInt(1));
		}
		while(resultSet2.next()){
			System.out.println("dealer count is :" + resultSet2.getInt(1));
		}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			dbManager.release();
		}
	}

}