下面是使用JDBC进行增删改查操作的具体代码实现,使用了预处理语句(PreparedStatement):

  1. 导入必要的类:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
  1. 建立数据库连接:
Connection conn = null;
try {
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
    e.printStackTrace();
}
  1. 插入数据:
String insertQuery = "INSERT INTO table_name (column1, column2, ...) VALUES (?, ?, ...)";
try {
    PreparedStatement pstmt = conn.prepareStatement(insertQuery);
    pstmt.setString(1, value1);
    pstmt.setString(2, value2);
    // ...
    pstmt.executeUpdate();
    pstmt.close();
} catch (SQLException e) {
    e.printStackTrace();
}
  1. 更新数据:
String updateQuery = "UPDATE table_name SET column1 = ?, column2 = ?, ... WHERE condition";
try {
    PreparedStatement pstmt = conn.prepareStatement(updateQuery);
    pstmt.setString(1, newValue1);
    pstmt.setString(2, newValue2);
    // ...
    pstmt.executeUpdate();
    pstmt.close();
} catch (SQLException e) {
    e.printStackTrace();
}
  1. 删除数据:
String deleteQuery = "DELETE FROM table_name WHERE condition";
try {
    PreparedStatement pstmt = conn.prepareStatement(deleteQuery);
    // ...
    pstmt.executeUpdate();
    pstmt.close();
} catch (SQLException e) {
    e.printStackTrace();
}
  1. 查询数据:
String selectQuery = "SELECT column1, column2, ... FROM table_name WHERE condition";
try {
    PreparedStatement pstmt = conn.prepareStatement(selectQuery);
    // ...
    ResultSet rs = pstmt.executeQuery();
    while (rs.next()) {
        // 处理查询结果
        String value1 = rs.getString("column1");
        String value2 = rs.getString("column2");
        // ...
    }
    rs.close();
    pstmt.close();
} catch (SQLException e) {
    e.printStackTrace();
}
  1. 关闭数据库连接:
try {
    if (conn != null) {
        conn.close();
    }
} catch (SQLException e) {
    e.printStackTrace();
}

请注意,以上代码中的"table_name"需要替换为具体的表名,"column1, column2, ..."需要替换为具体的列名,"condition"需要替换为具体的条件。另外,需要根据实际情况修改数据库连接的URL、用户名和密码

使用jdbc对数据库进行增删改查的具体代码实现要使用预处理不是用·statement

原文地址: https://www.cveoy.top/t/topic/im39 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录