jsp对mysql数据库的增删改查

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://数据库服务器地址:端口号/数据库名称";
    String username = "数据库用户名";
    String password = "数据库密码";

    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        Statement stmt = conn.createStatement();

        String sql = "INSERT INTO 表名 (列1, 列2, ...) VALUES ('值1', '值2', ...)";
        int rows = stmt.executeUpdate(sql);
        if (rows > 0) {
            out.println("数据插入成功！");
        } else {
            out.println("数据插入失败！");
        }

        stmt.close();
        conn.close();
    } catch (Exception e) {
        out.println("数据库连接错误：" + e.getMessage());
    }
%>

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://数据库服务器地址:端口号/数据库名称";
    String username = "数据库用户名";
    String password = "数据库密码";

    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        Statement stmt = conn.createStatement();

        String sql = "DELETE FROM 表名 WHERE 条件";
        int rows = stmt.executeUpdate(sql);
        if (rows > 0) {
            out.println("数据删除成功！");
        } else {
            out.println("数据删除失败！");
        }

        stmt.close();
        conn.close();
    } catch (Exception e) {
        out.println("数据库连接错误：" + e.getMessage());
    }
%>

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://数据库服务器地址:端口号/数据库名称";
    String username = "数据库用户名";
    String password = "数据库密码";

    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        Statement stmt = conn.createStatement();

        String sql = "UPDATE 表名 SET 列1='新值1', 列2='新值2', ... WHERE 条件";
        int rows = stmt.executeUpdate(sql);
        if (rows > 0) {
            out.println("数据修改成功！");
        } else {
            out.println("数据修改失败！");
        }

        stmt.close();
        conn.close();
    } catch (Exception e) {
        out.println("数据库连接错误：" + e.getMessage());
    }
%>

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://数据库服务器地址:端口号/数据库名称";
    String username = "数据库用户名";
    String password = "数据库密码";

    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        Statement stmt = conn.createStatement();

        String sql = "SELECT * FROM 表名";
        ResultSet rs = stmt.executeQuery(sql);

        while (rs.next()) {
            // 通过rs获取查询结果的各列数据
            String column1 = rs.getString("列1");
            String column2 = rs.getString("列2");
            // ...

            out.println("列1：" + column1 + "<br>");
            out.println("列2：" + column2 + "<br>");
            // ...
        }

        rs.close();
        stmt.close();
        conn.close();
    } catch (Exception e) {
        out.println("数据库连接错误：" + e.getMessage());
    }
%>