tomcat下配置数据源

步骤如下

?? 1.? 先将驱动程序添加到tomcat下commmons/lib下。
?? 2.? 在con/server.xml中<host></host>添加下面内容
??
???? <Context path="/TestUpload" docBase="D:\Tomcat 5.0\webapps\TestUpload" debug="0" reloadable="true" crossContext="true">
??????????? <Resource name="mysql" auth="Container" type="javax.sql.DataSource"/>
???????????? <ResourceParams name="jdbc/mysql">
???????????? <parameter>
???????????? <name>factory </name>
???????????? <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>driverClassName </name>
???????????? <value>com.mysql.jdbc.Driver</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>url</name>
???????????? <value>jdbc:mysql://localhost:3306/wangjinbin?characterEncoding=GBK</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>username</name>
???????????? <value>root</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>password</name>
???????????? <value>root</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>maxActive</name>
???????????? <value>50</value>
???????????? </parameter>
???????????? <parameter>
???????????? <name>maxIdle</name>
??????????? <value>50</value>
??????????? </parameter>
??????????? <parameter>
??????????? <name>maxWait</name>
??????????? <value>100</value>
??????????? </parameter>
??????????? </ResourceParams>
??????????? </Context>?

????? 注意TestUpload是我的工程名，jdbc/mysql是我的数据源名称。
??? 3.在web.xml添加如下内容：
???
???
?????
?????? <!-- 配置数据源 -->?
???????? <resource-ref>?
???????? <res-ref-name>jdbc/mysql</res-ref-name>
???????? <res-type>javax.sql.DataSource</res-type>
???????? <res-auth>Container</res-auth>
???????? </resource-ref>
??
??? 4.获得连接
???
???
??????? initCtx = new InitialContext();
???? Context ctx = (Context) initCtx.lookup("java:comp/env");
???? ?Object obj = (Object) ctx.lookup("jdbc/mysql");???
???? ?javax.sql.DataSource ds = (javax.sql.DataSource)obj;
???? ? Connection?? conn = ds.getConnection();
???? ?
???? ?
???? ?
???? ? 全部结束!