JSP/Servlet 线程池

首先是连接池c3p0货dbcp都行，他们都是实现了DataSource ，是他的实现类。
然后线程池的话，有个线程现场
threadLocal<Connection> local=new threadLocal<Connection>();
public static Connection getConnection ()throws Exception
{
Connection conn=local.get();
if(conn==null ||  conn.isClosed())
{
conn=driverManager.getConnection("jdbc:.....","sa","server");
local.set(conn);
}
return local.get();
}
public static void main (string[] args)

{
Connection conn1=getConnection();
Connection conn2=getConnection();
System.out.println(conn1==conn2);//可以得出结果是true
conn1.close();

}