在web.xml文件中配置
<resource-ref>
<description>student dbs</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
servet.xml中:
<GlobalNamingResources>
<!-- Editable user database that can also be used by
UserDatabaseRealm to authenticate users
-->
<Resource name="UserDatabase" auth="Container"
type="org.apache.catalina.UserDatabase"
description="User database that can be updated and saved"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"
pathname="conf/tomcat-users.xml" />
<Resource name ="jdbc/mysql"
auth ="Container"
type ="javax.sql.DataSource"
maxActive ="100"
maxIdle ="30"
maxWait ="60"
wait_timeout ="18800"
timeBetweenEvictionRunsMillis ="300000"
minEvictableIdleTimeMillis ="600000"
username ="root"
password ="root"
driverClassName ="com.mysql.jdbc.Driver"
url ="jdbc:mysql://localhost:3306/student?comautoReconnect=true&failOverReadOnly=false"
removeAbandoned ="true"
removeAbandonedTimeout ="60"
logAbandoned ="true" />
</GlobalNamingResources>
<Context path="/student" docBase="C:\Users\huang\workspace\student\WebRoot\" debug="0" reloadable="false" crossContext="true" >
<ResourceLink
name="jdbc/mysql"
type="javax.sql.DataSource"
global="jdbc/mysql"/>
</Context>