`
wengsibo
  • 浏览: 80394 次
  • 性别: Icon_minigender_1
  • 来自: 福建
社区版块
存档分类
最新评论

spring+ibatis的批量提交

阅读更多
public int addSendMsg(final Msg msg) {
		this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
			public Object doInSqlMapClient(SqlMapExecutor executor)
					throws SQLException {
				executor.startBatch();
				int batch = 0;
				String[] tel_nbrs = msg.getTel_nbrs().split(",");
				if(tel_nbrs.length <= 0)return 0;
				for (int i = 0; i < tel_nbrs.length; i++) {
					// 参数1为:ibatis中需要执行的语句的id
					String content = msg.getContent();
					msg.setTel_nbr(tel_nbrs[i]);
					executor.insert("msg-info.sendMsg", msg);
				}
				executor.executeBatch();	//提交
				return 1;
			}
		});
		return 1;
	}



分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics