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();
}
public int createBatch(Batch batch) throws Throwable {
PreparedStatement statement =
conn.prepareStatement(
"INSERT INTO `yamaloo`.`batch` (`SiteID`, `Status`) VALUES (?, ?);",
PreparedStatement.RETURN_GENERATED_KEYS);
statement.setInt(1, batch.getSiteID());
statement.setString(2, batch.getStatus().toString());
statement.executeUpdate();
ResultSet rs = statement.getGeneratedKeys();
rs.next();
int batchID = rs.getInt(1);
statement.close();
return batchID;
}
