jsp实现对mysql数据库的操作

<%@ page import="java.sql.*" %>
<%@ page import="com.mysql.jdbc.Driver" %>

String url = "jdbc:mysql://localhost:3306/your_database_name";
String username = "your_username";
String password = "your_password";

Connection conn = DriverManager.getConnection(url, username, password);

String sql = "SELECT * FROM your_table_name";
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
    // 处理结果集
}

String sql = "INSERT INTO your_table_name (column1, column2, ...) VALUES (?, ?, ...)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, value1);
stmt.setString(2, value2);
// ...
stmt.executeUpdate();

String sql = "UPDATE your_table_name SET column1 = ?, column2 = ... WHERE condition";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setString(1, newValue1);
stmt.setString(2, newValue2);
// ...
stmt.executeUpdate();

String sql = "DELETE FROM your_table_name WHERE condition";
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);

if (rs != null) {
    rs.close();
}
if (stmt != null) {
    stmt.close();
}
if (conn != null) {
    conn.close();
}