/**
* Update the query.
*
* @param id
* @param query
* @return
*/
public int updateQuery(long id, Query query) {
String sql = "update `query` set `finish_time`=?, `state`=?, `result`=? where `id`=? ";
QueryRunner qr = this.createQueryRunner();
Connection conn = null;
int affectedRows = 0;
try {
conn = this.getDBConnection(true);
affectedRows =
qr.update(conn, sql, query.getEndTime(), query.getState(), query.getResult(), id);
} catch (IOException e) {
logger.error(e.getMessage());
} catch (SQLException e) {
logger.error(e.getMessage());
} finally {
DbUtils.closeQuietly(conn);
}
return affectedRows;
}
