testdatasource.java

java编写的数据库连接池,内有详细的使用说明

package db;

import java.sql.*;

public class TestDataSource {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		
		String sql = "select * from t";
		Connection conn = null;
		
		try {
			
			conn = ConnectionSource.getConnection();
			
			Statement s = conn.createStatement();
			
			ResultSet rs = s.executeQuery(sql);
			
			while(rs.next()){
				System.out.println(rs.getString("louName"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			
		}finally{
			if(conn != null){
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}

}