/** * 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; }