1、普通插入表数据
Dao层:
int add(String param1,String param2)
Mapper层:
<insert id="add" >
insert into table (param1,param2) values(#{param1},#{param2})
<insert>
2、插入数据并返回主键
Dao层:
int insertDeptReturnKey(@Param("dept")BnDept dept);
Mapper层:
<insert id="insertDeptReturnKey" parameterType="com.bnwisdom.entity.BnDept"> <selectKey resultType="java.lang.Long" keyProperty="dept.id" order="AFTER" > SELECT LAST_INSERT_ID() </selectKey> insert into bn_dept (code,real_code,dept_name,pcode) values (#{dept.code},#{dept.realCode},#{dept.deptName},#{dept.pcode}) </insert>
3、批量插入数据
Dao层:
int batchInsert(@Param("list")List<Map<String,Object>> list);
Mapper层:
<insert id="batchInsert" parameterType="java.util.Map"> INSERT INTO bn_dept( code,real_code,dept_name,pcode )VALUES <foreach collection="list" item="dept" separator=","> ( #{dept.code}, #{dept.realCode}, #{dept.deptName}, #{dept.pcode} ) </foreach> </insert>
二、其他通用mysql
1、将A表数据插入B表中
insert INTO B表(B表目标字段) select A表字段 from A表