3,492
社区成员
发帖
与我相关
我的任务
分享
"select * from (select t.* ,rownum row_num from PAY_PREPAYMENT_WT_SEND t where REMAIN_MONTH <> 0 order by id desc) a where a.row_num>"
+ start
+ " and a.row_num <= "
+ end;
SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
PreparedStatement pstmt = null;
try {
conn.setAutoCommit(false);
pstmt =
conn.prepareStatement(
"update PAY_PREPAYMENT_WT_SEND set REMAIN_MONTH = REMAIN_MONTH-1, LAST_UPDATE =?,COUNTNUM = COUNTNUM+1 WHERE id =?");
for (int i = 0; i < list.size(); i++) {
CTSHWTPayMentEntity pe = (CTSHWTPayMentEntity) list.get(i);
pstmt.setString(2, pe.getId());
pstmt.setTimestamp(
1,
Timestamp.valueOf(fmt.format(pe.getLast_update())));
pstmt.addBatch();
}
pstmt.executeBatch();
conn.commit();
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
try {
if (null != pstmt)
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}