java tomcat 连接池配置_tomcat连接池的配置 Java开发及编程思想

type="javax.sql.DataSource"/>

factory

org.apache.commons.dbcp.BasicDataSourceFactory

driverClassName

com.microsoft.jdbc.sqlserver.SQLServerDriver

url

jdbc:microsoft:sqlserver://218.246.85.65:1433;DatabaseName=ZCMIS

alue>

username

sa

password

sa

maxActive

30

maxIdle

10

maxWait

1000

把下面的东西加到web.xml中

DB Connection

jdbc/testDB

javax.sql.DataSource

Container

类的内部实现

try{

Context initCtx = new InitialContext();

Context ctx = (Context) initCtx.lookup("java:comp/env");

//获取连接池对象

Object obj = (Object) ctx.lookup("jdbc/testDB");

javax.sql.DataSource ds = (javax.sql.DataSource)obj;

Connection conn = ds.getConnection();

}

catch(Exception e)

{

System.out.print(e.toString());

}