tomcat中配置数据源

1、在cofig/server.xml中配置应用 

<Context path="/jndi" docBase="C:\workproduct\TestJNDI\web" debug="0"
       reloadable="true" crossContext="true" URIEncoding="UTF-8">
    <Resource
               name="jdbc/mysql"
               type="javax.sql.DataSource"
               password="2008"
               driverClassName="org.gjt.mm.mysql.Driver"
               maxIdle="2"
               maxWait="50"
               username="root"
               url="jdbc:mysql://localhost:3306/test"
               maxActive="4"/>
 </Context> 

2、在web.xml中加入

<resource-ref>
    <description>test connection</description>
    <res-ref-name>jdbc/mysql</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
 </resource-ref>

3、将mysql驱动包拷贝至lib目录中。

4、在web目录中新建页面，index.jsp，输入下列内容：

<%@ page
    language="java"
    contentType="text/html; charset=UTF-8"
    import=
      "java.io.*,
       java.sql.*,
       java.util.*,
       javax.servlet.*,
       javax.naming.*,
       javax.servlet.http.*,
       javax.sql.*"
%>
<%
     Context ctx=new InitialContext();
     DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/mysql");
     Connection conn = ds.getConnection();
     out.println(conn.toString());
     conn.close();
%>
hello!

5、浏览器上输入：http://localhost:8080/jndi/ 显示：jdbc:mysql://localhost:3306/test, UserName=root@localhost, MySQL-AB JDBC Driver hello!