在Tomcat中配置数据库连接池

在Tomcat的安装目录  apache-tomcat\conf\server.xml 中找到标签，并加入一个子标签具体配置如下：   

在Tomcat的安装目录  apache-tomcat\conf\Catalina\localhost中建立一个wx.xml文件   内容如下

建立数据库如下

建立web工程如下package test;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class hello extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType('text/html;charset=UTF-8'); PrintWriter out = response.getWriter(); try { javax.naming.Context ctx=new javax.naming.InitialContext(); javax.sql.DataSource ds=(javax.sql.DataSource)ctx.lookup('java:/comp/env/jdbc/webdb'); Connection conn=ds.getConnection(); PreparedStatement pstmt=conn.prepareStatement('select*from t_dictionary'); ResultSet rs=pstmt.executeQuery(); StringBuilder table=new StringBuilder(); table.append('

web.xml的配置      This is the description of my J2EE component    This is the display name of my J2EE component    hello    test.hello        hello    /servlet/hello 

测试如下