🌷①使用JDBC实现对数据库的增删改查操作:
🌷②使用Hibernate实现对数据库的增删改查操作:
🌷③使用MyBatis实现对数据库的增删改查操作:
🌷④使用Spring Data JPA实现对数据库的增删改查操作:
①使用JDBC实现对数据库的增删改查操作:
// 连接数据库
Connection conn = DriverManager.getConnection(url, username, password);
// 插入数据
String sql = "INSERT INTO user(name, age) VALUES (?, ?)";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Tom");
pstmt.setInt(2, 18);
pstmt.executeUpdate();
// 更新数据
String sql = "UPDATE user SET age = ? WHERE name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setInt(1, 20);
pstmt.setString(2, "Tom");
pstmt.executeUpdate();
// 删除数据
String sql = "DELETE FROM user WHERE name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Tom");
pstmt.executeUpdate();
// 查询数据
String sql = "SELECT * FROM user WHERE name = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "Tom");
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("id:" + id + ", name:" + name + ", age:" + age);
}