1:配置tomcat
配置conf下的context.xml 文件
<?xml version='1.0' encoding='utf-8'?>
<Context reloadable="true">
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/test"/>
</Context>
在代码里面 用
Context context = new InitialContext();
DataSource dataSource = (DataSource) context
.lookup("java:comp/env/jdbc/mysql");
conn = dataSource.getConnection();
记得要关闭connection