怎么在jsp查看mysql数据库中的信息

<%@ page import="java.sql.*" %>
<%
  Connection conn = null;
  Statement stmt = null;
  try {
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);
    stmt = conn.createStatement();
    
    // 执行SQL查询或操作
    // ...
    
    // 关闭连接和语句
    stmt.close();
    conn.close();
  } catch (Exception e) {
    e.printStackTrace();
  }
%>

<%@ page import="java.sql.*" %>
<%
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  try {
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);
    stmt = conn.createStatement();
    
    String sql = "SELECT * FROM your_table_name";
    rs = stmt.executeQuery(sql);
    
    // 在JSP页面上显示查询结果
    while (rs.next()) {
      out.println("ID: " + rs.getInt("id") + "<br>");
      out.println("Name: " + rs.getString("name") + "<br>");
      // ...
    }
    
    // 关闭结果集、语句和连接
    rs.close();
    stmt.close();
    conn.close();
  } catch (Exception e) {
    e.printStackTrace();
  }
%>