jsp增删改查mysql

<%@ page import="java.sql.*" %>
<%
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try {
        // 加载JDBC驱动
        Class.forName("com.mysql.jdbc.Driver");
        // 建立数据库连接
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");
        // 创建Statement对象
        stmt = conn.createStatement();
        
        // 执行查询操作
        rs = stmt.executeQuery("SELECT * FROM users");
        while (rs.next()) {
            out.println(rs.getInt("id") + "\t" + rs.getString("name") + "<br>");
        }
        
        // 执行插入操作
        int rowsAffected = stmt.executeUpdate("INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')");
        out.println("Inserted " + rowsAffected + " row(s).");
        
        // 执行更新操作
        rowsAffected = stmt.executeUpdate("UPDATE users SET email = 'jane@example.com' WHERE name = 'Jane Doe'");
        out.println("Updated " + rowsAffected + " row(s).");
        
        // 执行删除操作
        rowsAffected = stmt.executeUpdate("DELETE FROM users WHERE id = 1");
        out.println("Deleted " + rowsAffected + " row(s).");
    } catch (ClassNotFoundException | SQLException e) {
        out.println("Error: " + e.getMessage());
    } finally {
        // 关闭结果集、Statement和数据库连接
        if (rs != null) rs.close();
        if (stmt != null) stmt.close();
        if (conn != null) conn.close();
    }
%>