jsp mysql数据库池

<%@ page import="java.sql.*" %>
<%@ page import="org.apache.commons.dbcp2.*" %>
<%@ page import="org.apache.commons.pool2.impl.GenericObjectPoolConfig" %>

<%
    // 配置连接池
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/mydatabase");
    dataSource.setUsername("username");
    dataSource.setPassword("password");

    // 设置连接池参数
    dataSource.setInitialSize(5);
    dataSource.setMaxTotal(20);
    dataSource.setMaxIdle(10);
    dataSource.setMinIdle(5);

    // 获取连接
    Connection conn = dataSource.getConnection();

    // 执行SQL查询
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");

    // 处理结果集
    while (rs.next()) {
        out.println(rs.getString("columnName"));
    }

    // 关闭资源
    rs.close();
    stmt.close();
    conn.close();

    // 关闭连接池（在实际应用中，通常在应用关闭时才关闭连接池）
    dataSource.close();
%>