使用jndi
1.tomcat/conf/server.xml
在host标签内加上
<!-- mysql连接池配置 -->
<Context docBase="D:\apache-tomcat-5.5.25\webapps\Test" path="/test" reloadable="true">
<Resource name="jdbc/test" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2" maxWait="5000"
removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" username="" password="" url="jdbc:mysql://127.0.0.1:3306/abroad_test?autoReconnect=true&autoReconnectForPools=true" maxActive="100"/>
<Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false">
<Store className="org.apache.catalina.ses