直接上代码
//测试类
public class Draft {
public static void main(String args[]){
Connection conn=Fconn.getPoolConn();
System.out.println(conn.toString());
}
}
//jsp测试页
<%
Connection conn=Fconn.getPoolConn();
out.println(conn.toString());
%>
//从池中获取连接功能类,测试程序中我用下面的工厂获得连接
public class GetConnectionFromPool {
private Connection conn=null;
public Connection getMySQLConnection(){
try{
String datasourcename="java:comp/env/jdbc/HanLinMysql";
Context cont=new InitialContext();
DataSource datasource=(DataSource)cont.lookup(datasourcename);
this.conn=datasource.getConnection();
}catch(Exception e){
//this.conn=null;
}
return this.conn;
}
public Connection getSQLServerConnection(){
try{
String datasourcename="java:comp/env/jdbc/HanLinSQLServer/hanlinsale";
Context cont=new InitialContext();
DataSource datasource=(DataSource)cont.lookup(datasourcename);
this.conn=datasource.getConnection();
}catch(Exception e){
//this.conn=null;
}
return this.conn;
}
}
//连接工厂
public class Fconn {
public static Connection getPoolConn(){
Connection conn=null;
GetConnectionFromPool pool=new GetConnectionFromPool();
conn=pool.getSQLServerConnection();
return conn;
}
}