81,092
社区成员
发帖
与我相关
我的任务
分享
public int[] add_Batch_Leaguer(ArrayList al) throws Exception {
conn = da.getConnection();
LeaguerBean lb = new LeaguerBean();
String sql = "insert into YDZJ_COMMON_ENT_MEMBER_INFO(s_id,F_CALLOUT,F_LDTEL,FEE_FLAG,USER_NAME,NAME_INDEX,PHONENUM,SHORTNUM,POSITION,display_flag) values (?,?,?,?,?,?,?,?,?,?)";//sql
int[] a = new int[al.size()];
try {
conn.setAutoCommit(false);
stmt = conn.prepareStatement(sql);
for (int i = 0; i < al.size(); i++) {//这是多收件人是我从列表中获取的[id](比如为(1,2,3,4,5,6,7)),
lb = (LeaguerBean) al.get(i);
//这里是你需要绑定的参数
stmt.addBatch();
}
a = stmt.executeBatch();
conn.commit();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
da.close(conn, stmt, rs);
}
return a;
}