在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();