tomcat mysql连接池配置

<dependencies>
    <dependency>
        <groupId>com.zaxxer</groupId>
        <artifactId>HikariCP</artifactId>
        <version>5.0.1</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.26</version>
    </dependency>
</dependencies>

<Context>
    <Resource name="jdbc/MyDB"
              auth="Container"
              type="javax.sql.DataSource"
              factory="com.zaxxer.hikari.HikariJNDIFactory"
              minimumIdle="5"
              maximumPoolSize="20"
              connectionTimeout="30000"
              idleTimeout="600000"
              maxLifetime="1800000"
              jdbcUrl="jdbc:mysql://localhost:3306/mydatabase"
              username="myuser"
              password="mypassword"
              driverClassName="com.mysql.cj.jdbc.Driver"/>
</Context>

Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/MyDB");
Connection conn = ds.getConnection();

try (Connection conn = ds.getConnection()) {
    // 使用连接
} catch (SQLException e) {
    e.printStackTrace();
}