Java Reference
In-Depth Information
private static void performUpdate(){
String sql = "UPDATE RECIPES " +
"SET RECIPE_NUMBER = '13-5' " +
"WHERE RECIPE_NUMBER = '13-4'";
try (Connection conn = createConn.getConnection();
Statement stmt = conn.createStatement();)
{
int result = stmt.executeUpdate(sql);
if (result > 0){
System.out.println("-- Record Updated
--");
} else {
System.out.println("!! Record NOT Updated
!!");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
private static void performDelete(){
String sql = "DELETE FROM RECIPES WHERE
RECIPE_NUMBER = '11-5'";
try (Connection conn = createConn.getConnection();
Statement stmt = conn.createStatement();)
{
int result = stmt.executeUpdate(sql);
if (result > 0){
System.out.println("-- Record Deleted
--");
} else {
System.out.println("!! Record NOT
Deleted!!");
}
} catch (SQLException e) {
e.printStackTrace();
