读书人

spring+ibatis的批量交付

发布时间: 2012-09-15 19:09:29 作者: rapoo

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中需要执行的语句的idString content = msg.getContent();msg.setTel_nbr(tel_nbrs[i]);executor.insert("msg-info.sendMsg", msg);}executor.executeBatch();//提交return 1;}});return 1;}



读书人网 >软件架构设计

热点推荐