package book.database.pool;

import java.sql.Connection;

public class DatabasePoolTest {

	public static JDBCInfo getJDBCInfo(){
		JDBCInfo jdbc = new JDBCInfo();
		jdbc.setDriver("com.mysql.jdbc.Driver");
		jdbc.setName("MySQL");
		jdbc.setUrl("jdbc:mysql://127.0.0.1:3306/studentdb");
		jdbc.setUser("test");
		jdbc.setPassword("test");
		jdbc.setMaxconn(10);
		return jdbc;
	}
	
	public static void main(String[] args) {
		JDBCInfo jdbc = getJDBCInfo();
		String sql = "SELECT * FROM student_basic";
		DataConnectMgr mgr =  DataConnectMgr.getInstance(jdbc);
		//從數(shù)據(jù)庫連接池中獲取連接
		Connection con = mgr.getConnection(jdbc.getName());
        try {
        	System.out.println("正在使用剛剛獲得的數(shù)據(jù)庫連接");
            java.sql.Statement sm = con.createStatement();
            sm.executeQuery(sql);
            //do something
            sm.close();
        } catch (java.sql.SQLException e) {
        	System.err.println("連接數(shù)據(jù)庫出錯！");
        } finally {
        	//釋放連接到數(shù)據(jù)庫連接池
        	mgr.freeConnection(jdbc.getName(), con);
        }
        mgr.release();
	}
}