mybatis怎么实现一次插入多条数据

前两种为mybatis框架里面的代码，第三种方法为纯java代码时jdbc操作

1.复制原有数据库中的n条记录直接插入

    <!--复制Menu表中的所有信息复制插入，传入参数为#{projectid}--><insert id="insertMenu" parameterType="int">INSERT INTO table_menu (projectid,id,fj,level,text,state,type) select #{projectid} as projectid,id,fj,level,text,state,type from table_menu where projectid=0;</insert>#{projectid}--><insert id="insertMenu" parameterType="int">INSERT INTO table_menu (projectid,id,fj,level,text,state,type) select #{projectid} as projectid,id,fj,level,text,state,type from table_menu where projectid=0;</insert>

 

2.传入参数是放在一个list里面的变量时

 

    <!--将所有信息插入PP表里面，传入参数为list,通过<foreach>来遍历list--><insert id="insert_PP" parameterType="java.util.ArrayList">insert into table_p_p (projectid,propertyid,value) VALUES<foreach collection="list" item="item" index="index" separator=",">(#{item.projectid},#{item.propertyid},#{item.value})</foreach></insert>传入参数为list,通过<foreach>来遍历list--><insert id="insert_PP" parameterType="java.util.ArrayList">insert into table_p_p (projectid,propertyid,value) VALUES<foreach collection="list" item="item" index="index" separator=",">(#{item.projectid},#{item.propertyid},#{item.value})</foreach></insert>

3.用java jdbc代码操作数据库时

 

每一条要执行的SQL语句先用字符串构造好，之后调用JDBC.exebatch方法

DBConnection db = DBConnection.getInstance();
Connection conn = null;
conn = db.getConnection();
if (conn != null) {
// 设置事务为非自动提交
conn.setAutoCommit(false);
PreparedStatement pstmt = conn.prepareStatement("");
// 添加执行sql
String sql="insert into t1(id,name) values(1,'a'),(2,'b'),(3,'c')";
pstmt_funcCall.addBatch(sql);
// 执行操作
pstmt.executeBatch();
// 提交事务
conn.commit();
pstmt.close();
conn.close();
}