* @throws SQLException 抛出数据库异常
*/
private void allocatingTask(List<ScheduleInfo> aliveList) throws SQLException{
StringBuilder aliveSchedule = new StringBuilder();
for (int i = 0; i < aliveList.size(); ++i) {
ScheduleInfo scheduleInfo = aliveList.get(i);
if (config.getScheduleName().equals(scheduleInfo.getSchedulename())) {
// 将最新的序号同步到数据库
Object[] arguments = { i,
config.getScheduleName()};
QueryHelper.update("UPDATE jd_ofc_schedule SET seqno = ? WHERE schedulename = ?", arguments);
config.setSeqno(i);
}
aliveSchedule.append(scheduleInfo.getId());
aliveSchedule.append(";");
}
config.setAliveSchedule(aliveSchedule.toString());
config.setScheduleNum(aliveList.size());
}