Connection conn = null;
try {
  conn = dataSource.getConnection();
  conn.setAutoCommit(false);
  PreparedStatement ps1 = conn.prepareStatement("UPDATE item_repository SET quantity = ?");
  ps1.setInt(1, 0);
  ps1.execute();
  PreparedStatement ps2 = conn.prepareStatement("UPDATE item_repository SET price = ?, quantity = ?, barcode = ? WHERE id = ?");
  ...
  ps2.addBatch();
  ps2.executeBatch();
  conn.commit();
} finally {
  if (conn != null)
    conn.close();
}