将JSP表中的更改保存到数据库中

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

<%
    // 获取表单数据
    String id = request.getParameter("id");
    String name = request.getParameter("name");
    String age = request.getParameter("age");

    // 数据库连接信息
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";

    // 建立数据库连接
    Connection conn = null;
    PreparedStatement stmt = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);

        // 执行数据库操作
        String sql = "UPDATE mytable SET name=?, age=? WHERE id=?";
        stmt = conn.prepareStatement(sql);
        stmt.setString(1, name);
        stmt.setInt(2, Integer.parseInt(age));
        stmt.setInt(3, Integer.parseInt(id));
        stmt.executeUpdate();

        out.println("数据保存成功！");
    } catch (Exception e) {
        e.printStackTrace();
        out.println("数据保存失败！");
    } finally {
        // 关闭数据库连接
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>