ibatis

ibatis"/>

ibatis

ibatis配置批量插入数据

​        //JAVA代码List<QiaodaCvAnalysis> qList=new ArrayList<QiaodaCvAnalysis>();for(int i=0;i<10;i++){QiaodaCvAnalysis  dAnalysis=new QiaodaCvAnalysis();String i_vivian=String.valueOf(i);dAnalysis.setResumeId(i_vivian);dAnalysis.setPositionRank(i);qList.add(dAnalysis);}try {decomposevservice.addTest(qList);} catch (Exception e) {String msg = e.getMessage();System.out.println(msg);// TODO: handle exception}

ibatisXML

<typeAlias alias="QiaodaCvAnalysis"type="com.transing.arithmetic.bo.decomposeCV.QiaodaCvAnalysis" />
<insert id="addQiaodaCvAnalysisTest" parameterClass="java.util.ArrayList" ><![CDATA[insert into test(resumeId,toBachelor,updateTime)values]]><iterate  conjunction="," >(#QiaodaCvAnalysis[].resumeId#,#QiaodaCvAnalysis[].toBachelor#,now())</iterate> ON DUPLICATE KEY UPDATE toBachelor=values(toBachelor);</insert>

 ON DUPLICATE KEY UPDATE toBachelor=values(toBachelor);  //若批量插入的数据有重复的，则直接修改该记录