jsp中mysql查询数据库

<%@ page import="java.sql.*" %>
<%@ page import="com.mysql.jdbc.Driver" %>

<%
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";

Connection conn = null;
try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
    e.printStackTrace();
}
%>

<%
Statement stmt = null;
ResultSet rs = null;
try {
    stmt = conn.createStatement();
    String sql = "SELECT * FROM mytable";
    rs = stmt.executeQuery(sql);
    while (rs.next()) {
        // 处理查询结果
        String column1 = rs.getString("column1");
        int column2 = rs.getInt("column2");
        // ...
    }
} catch (SQLException e) {
    e.printStackTrace();
} finally {
    try {
        if (rs != null) {
            rs.close();
        }
        if (stmt != null) {
            stmt.close();
        }
        if (conn != null) {
            conn.close();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
%>