jsp下载数据库

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%
    // 连接数据库
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    Connection conn = DriverManager.getConnection(url, username, password);

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

    // 生成CSV文件
    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    PrintWriter pw = new PrintWriter(baos);
    while (rs.next()) {
        pw.println(rs.getString("column1") + "," + rs.getString("column2"));
    }
    pw.flush();

    // 设置响应头
    response.setContentType("application/octet-stream");
    response.setHeader("Content-Disposition", "attachment; filename=mydata.csv");

    // 发送文件给客户端
    OutputStream os = response.getOutputStream();
    baos.writeTo(os);
    os.flush();
    os.close();

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

# 数据库连接池配置示例（使用Apache Commons DBCP）
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mydatabase
username=root
password=password
maxActive=100
maxIdle=30
maxWait=10000
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT 1
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
removeAbandoned=true
removeAbandonedTimeout=1800
logAbandoned=true