在Tomcat6中配置数据源

1.设置META-INF/context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/datasourcetest">
	<Resource name="jdbc/testdb"
            auth="Container"
            type="javax.sql.DataSource"
            username="username"
            password="password"
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/testdb"
            maxActive="8"
            maxIdle="4" />
</Context>

2.设置WEN-INF/web.xml,添加资源引用

<?xml version="1.0" encoding="UTF-8"?>
<web-app>
	<resource-ref>
		<res-ref-name>jdbc/testdb</res-ref-name>
		<res-type>javax.sql.DataSource</res-type>
		<res-auth>Container</res-auth>
		<res-sharing-scope>Shareable</res-sharing-scope>
	</resource-ref>
</web-app>

3.使用jndi获得数据源

Context context = new InitialContext();
DataSource source = (DataSource) context.lookup("java:comp/env/jdbc/testdb");
Connection conn = source.getConnection();

4.mysql驱动必须放在tomcat/lib中
记此以备忘