作者:七月漂香 | 来源:互联网 | 2023-06-22 14:42
一.xml层
BEGIN
]]>
INSERT
INTO A_TABLE A
(
A.ID,
A.SECURITYNO,
A.BATCHNO,
A.ISDELETE
)
VALUES
(SEQ_SEC.nextval,#secCodeList[]#,#batchNo#,‘0‘);
END;
]]>
二.action层
//批量生成
for (int i = 0; i sb.append(scu.createSecCode(productNo));
sb.append(",");
System.out.println("i="+i);
}
String securityNo = sb.toString();
securityNo=securityNo.substring(0,securityNo.length() -1);
//ibatis批量入库
Map mapList=new HashMap();
mapList.put("securityNo", securityNo);
mapList.put("batchNo", batchNo);
batchService.addSecCodeList(mapList);
三.serviceImpl层
/**
*批量入库
*/
public String addSecCodeList(Map map){
String securityNo=ConvertUtils.obj2Str(map.get("securityNo"),"");
String [] sn=securityNo.split(",");
map.put("secCodeList", sn);
return batchDao.addSecCodeList(map);
}
四.daoImpl层
/**
*批量入库
*/
public String addSecCodeList(Map map){
try {
super.getSqlMapClientTemplate().insert("addSecCodeList", map);
return "true";
} catch (DataAccessException e) {
e.printStackTrace();
return "false";
}
}
ibaits数组形式批量入库