jsp查找mysql数据库

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String user = "username";
    String password = "password";
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, user, password);
        // 进行数据库操作
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>

<%@ page import="java.sql.*" %>
<%
    String sql = "SELECT * FROM users WHERE id = ?";
    try (Connection conn = DriverManager.getConnection(url, user, password);
         PreparedStatement pstmt = conn.prepareStatement(sql)) {
        pstmt.setInt(1, 123);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {
            // 处理结果集
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>