使用jsp mysql配置

db.url=jdbc:mysql://localhost:3306/mydatabase
db.username=root
db.password=123456

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%
    // 加载数据库配置
    Properties props = new Properties();
    try (InputStream in = application.getResourceAsStream("/WEB-INF/db.properties")) {
        props.load(in);
    } catch (IOException e) {
        out.println("无法加载数据库配置文件");
        return;
    }

    // 获取连接信息
    String url = props.getProperty("db.url");
    String username = props.getProperty("db.username");
    String password = props.getProperty("db.password");

    // 连接数据库
    Connection conn = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        out.println("数据库连接成功！");

        // 执行查询
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");
        while (rs.next()) {
            out.println(rs.getString("columnName"));
        }
    } catch (ClassNotFoundException | SQLException e) {
        out.println("数据库连接失败：" + e.getMessage());
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>