前两种为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();
}