jsp配置测试Tomcat HikariCP 连接池

 META-INF\context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context  path="/tomcathikaricp">
    <Resources allowLinking="true" />
    <Resource name="jdbc/tomcat"
              auth="Container"
              type="javax.sql.DataSource"
              factory="com.zaxxer.hikari.HikariJNDIFactory"
              minimumIdle="5"
              maximumPoolSize="10"
              connectionTimeout="300000"
              dataSource.user="root"
              dataSource.password="root"
              dataSourceClassName="com.mysql.cj.jdbc.MysqlDataSource"
              dataSource.url="jdbc:mysql://localhost:3306/tomcat?characterEncoding=UTF-8" />
</Context>

WEB-INF\web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app>
    <resource-ref>
        <description>DB_Connection</description>
        <res-ref-name>jdbc/tomcat</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

</web-app>

WEB-INF\lib下放置mysql-connector-java-5.1.47-bin.jar

tomcatpool.jsp

<%@page language="java" pageEncoding="gbk"%>
<%@page import="java.sql.Connection"%>
<%@page import="javax.naming.Context"%>
<%@page import="javax.naming.InitialContext"%>
<%@page import="javax.sql.DataSource"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<%
    //连接池的获取
    Connection conn = null;
    DataSource ds = null;
    ResultSet rs = null;
    Statement stmt = null;
    Context initCtx = new InitialContext();
    ds = (DataSource) initCtx.lookup("java:comp/env/jdbc/tomcat");
    if (ds != null) {
        out.println("已经获得DataSource!");
        out.println("<br>");
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            String sql = "select * from tomcat";
            rs = stmt.executeQuery(sql);
            out.println("以下是从数据库中读取出来的数据:<br>");
            while (rs.next()) {
                out.println("<br>");
                out.println(rs.getString("tomcat"));
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            conn.close();
            rs.close();
            stmt.close();
        }
    }

%>