public int updateTqcBatch(String statment, Object obj)
throws DataAccessIntegrityViolationException, DataAccessException {
SqlMapClient sqlmapclient = this.getSqlMapClient();
int o = 0;
List<TqcAlarm> list = null;
try {
if (null == obj) {
throw new DataAccessException("the obj value is null");
}
if (!(obj instanceof List)) {
throw new UnsupportedOperationException("the obj should be List instance");
} else {
list = (List<TqcAlarm>) obj;
}
// 开启批处理
sqlmapclient.startBatch();
for (TqcAlarm alarm : list) {
o = getSqlMapClientTemplate().update(statment, alarm);
}
// 批处理执行
sqlmapclient.executeBatch();
return o;
} catch (SQLException e) {
throw new DataAccessException(e);
} catch (Exception e) {
throw new DataAccessException(e);
}
}
public boolean insertRankingHistory(UserDTO dto) throws Exception {
boolean result = false;
try {
sqlClient.startTransaction();
sqlClient.startBatch();
sqlClient.insert("UserInfo.insertRankingHistory", dto);
sqlClient.executeBatch();
sqlClient.commitTransaction();
result = true;
} catch (Exception e) {
logger.error("sql Exception : " + e.getMessage());
throw new Exception("TwitterRankDAO.insertRankingHistory:" + e.getMessage());
} finally {
sqlClient.endTransaction();
}
return result;
}
public boolean insertUserList(List<UserDTO> list) throws Exception {
boolean result = false;
try {
// 트랜잭션 시작
sqlClient.startTransaction();
// 배치작업 준비 시작
sqlClient.startBatch();
for (UserDTO dto : list) {
sqlClient.insert("UserInfo.insertUserList", dto);
}
// 배치작업 실행.
sqlClient.executeBatch();
// 정상 완료 후 커밋
sqlClient.commitTransaction();
result = true;
} catch (Exception e) {
logger.error("sql Exception : " + e.getMessage());
throw new Exception("TwitterRankDAO.getUserList:" + e.getMessage());
} finally { // 문제 발생시 트랜잭션 종료(작업 적용안함)
sqlClient.endTransaction();
}
return result;
}