天天看点

360mysql连接池_tomcat+mysql连接池的配置

在TOMCA下的Catalina\localhost目录的工程xml,编写如下代码:

factory

org.apache.commons.dbcp.BasicDataSourceFactory

maxWait

5000

maxActive

20

password

password

url

jdbc:mysql://localhost:3306/mysql

driverClassName

com.mysql.jdbc.Driver

maxIdle

10

username

root

在工程目录WebContent\WEB-INF下的web.xml中添加:

DB Connection

jdbc/mysql

javax.sql.DataSource

Container

java代码实现:

InitialContext initctx=new InitialContext();

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

DataSource ds=(DataSource)ctx.lookup("jdbc/mysql");

Connection cn = ds.getConnection();

Statement st = cn.createStatement();