1、配置Tomcat的文档配置(Tomcat/conf/context.xml):
<Context cookies="true">
<Resource name="jdbc/database"
auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/数据库名"
/>
</Context>
2、把mysql驱动放在Tomcat的lib里面
3、配置Web程序的web.xml,jdbc/database为数据源名称,可以为任意名,用来在Java程序中查找该数据源
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5"
xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
<resource-ref>
<res-ref-name>jdbc/database</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
4、获取连接(注意包的导入)
import java.sql.Connection;
import java.sql.SQLException;
import java.util.*;
import javax.naming.*;
import javax.sql.DataSource;
public class ConnectionManager{
public Connection getConnection()
{
Connection con=null;
try {
Context ic=new InitialContext();
DataSource source=(DataSource)ic.lookup("java:comp/env/jdbc/database");
try {
con=source.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (NamingException e1) {
e1.printStackTrace();
}
return con;
}
}
需要连接数据库时就可调用此方法使用con