首先是连接池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();
}
然后线程池的话,有个线程现场
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();
}