jsp连接mysql数据库实验内容

<%@ page import="java.sql.*" %>

<%
String url = "jdbc:mysql://localhost:3306/数据库名称";
String username = "数据库用户名";
String password = "数据库密码";
Connection conn = null;
try {
    Class.forName("com.mysql.jdbc.Driver"); // 加载MySQL JDBC驱动
    conn = DriverManager.getConnection(url, username, password); // 建立数据库连接
} catch (Exception e) {
    e.printStackTrace();
}
%>

<%
Statement stmt = null;
ResultSet rs = null;
try {
    stmt = conn.createStatement();
    rs = stmt.executeQuery("SELECT * FROM 表名");
    
    // 处理查询结果
    while (rs.next()) {
        String column1 = rs.getString("列名1");
        String column2 = rs.getString("列名2");
        // ... 其他列
        out.println(column1 + " - " + column2 + "<br>");
    }
} catch (Exception e) {
    e.printStackTrace();
} finally {
    // 关闭数据库连接和结果集
    try { if (rs != null) rs.close(); } catch (SQLException e) { e.printStackTrace(); }
    try { if (stmt != null) stmt.close(); } catch (SQLException e) { e.printStackTrace(); }
    try { if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); }
}
%>