Tomcat mysql 配置数据源

把驱动拷贝到/common/lib下，然后改server.xml和web.xml,
server.xml加如下(</host>里)：
<Context path="/ycportal" docBase="mydocBase"
debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/mydatasource"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydatasource">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value></value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/mydatabase?useUnicode=true&characterEncoding=gb2312</value>
</parameter>
</ResourceParams>
</Context>
web.xml:

<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/mydatasource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>