public void updateBatch(Batch batch) throws Throwable { PreparedStatement statement = conn.prepareStatement( "UPDATE `yamaloo`.`batch` SET `Status` = ?, `CrawlBeginTime` = ?, `CrawlEndTime` = ? WHERE `BatchID` = ?"); statement.setString(1, batch.getStatus().toString()); statement.setTimestamp(2, batch.getCrawlBeginTime()); statement.setTimestamp(3, batch.getCrawlEndTime()); statement.setInt(4, batch.getBatchID()); statement.executeUpdate(); statement.close(); }