Working with Databases - Java 8 Recipes - page 442

// Returns row-count or 0 if not successful
int result = stmt.executeUpdate(sql);
if (result > 0){
System.out.println("-- Record created
--");
} else {
System.out.println("!! Record NOT Created
!!");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
private static void performRead(){
String qry = "select recipe_number, recipe_name,
description from recipes";
try (Connection conn = createConn.getConnection();
Statement stmt = conn.createStatement();)
{
ResultSet rs = stmt.executeQuery(qry);
while (rs.next()) {
String recipe
= rs.getString("RECIPE_NUMBER");
String name = rs.getString("RECIPE_NAME");
String desc = rs.getString("DESCRIPTION");
System.out.println(recipe + "\t" + name
+ "\t" + desc);
}
} catch (SQLException e) {
e.printStackTrace();
}
}