DAO中批量数据的插入
PreparedStatement insPstmt = null;
int rt = 0;
//sql文
StringBuffer insSql = new StringBuffer();
insSql.append(" INSERT INTO jsy_mst (" +
" jsycod, " +
" pstbng," +
" jsy001," +
" jsy002," +
" tkystrymd," +
" datetydte," +
" datetyttscod," +
" datetypgmcod)" +
" VALUES(?, ?, ?, ?, TO_DATE(?, 'YYYY/MM/DD'), now(), ?, ?)");
log.debug(insSql.toString());
try {
insPstmt = conn.prepareStatement(insSql.toString());
//SQL文参数设置
for (Iterator it = jsyList.iterator(); it.hasNext();) {
JsymstInfo info = (JsymstInfo) it.next();
int i = 1;
//
insPstmt.setString(i++, info.getJsycod());
insPstmt.setString(i++, info.getPstbng());
insPstmt.setString(i++, info.getJsy001());
insPstmt.setString(i++, info.getJsy002());
insPstmt.setString(i++, newLastStrYMD);
insPstmt.setString(i++, rysnoo);
insPstmt.setString(i++, pgmId);
insPstmt.addBatch();
}
//登录
log.debug("begin to execute....size:" + jsyList.size());
insPstmt.executeBatch();
log.debug("execute finished");
外部控制一次批量数据量
conn = ConnectionMgr.getConnection();
ETC2100_00DAO dao = new ETC2100_00DAO();
// 最新数据登录
// 每一万件登录一次。（OutOfMemoryError防止）
for (int i = 1; ; i++) {
List list = null;
boolean isBreak = false;
int cnt = 10000;
if (i * cnt >= upList.size()) {
list = upList.subList((i-1) * cnt, upList.size());
isBreak = true;
} else {
list = upList.subList((i-1) * cnt, i * cnt);
}
dao.batchInsertData(list, newStrYMD, info.getRysnoo(), pgmId, conn);
if (isBreak) {
break;
}
}
// commit
ConnectionMgr.commitConnection(conn);
这是我的程序。connection都是统一取得，释放的。
