使用jdbc对数据库进行增删改查的具体代码实现要使用预处理不是用·statement
下面是使用JDBC进行增删改查操作的具体代码实现,使用了预处理语句(PreparedStatement):
- 导入必要的类:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
- 建立数据库连接:
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();
}
- 插入数据:
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();
}
- 更新数据:
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();
}
- 删除数据:
String deleteQuery = "DELETE FROM table_name WHERE condition";
try {
PreparedStatement pstmt = conn.prepareStatement(deleteQuery);
// ...
pstmt.executeUpdate();
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
- 查询数据:
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();
}
- 关闭数据库连接:
try {
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
请注意,以上代码中的"table_name"需要替换为具体的表名,"column1, column2, ..."需要替换为具体的列名,"condition"需要替换为具体的条件。另外,需要根据实际情况修改数据库连接的URL、用户名和密码
原文地址: https://www.cveoy.top/t/topic/im39 著作权归作者所有。请勿转载和采集!