1、batis文件中写法:
<!--插入数据,返回主键的insert写法 -->
<insert id="insert_A" parameterType="Map" useGeneratedKeys="true" keyProperty="id">
insert into project_A
(pid,sid,row,nm,create_date,create_uid,create_uname,mod_date,mod_uid,mod_uname)
values
(#{pid},#{sid},#{row},#{nm},#{create_date},#{create_uid},#{create_uname},#{mod_date},#{mod_uid},#{mod_uname})
</insert>
<!--插入多字段,不许返回主键的写法 -->
<insert id="insert_B" parameterType="Map">
insert into project_B
<foreach collection="params.keys" item="key" open="(" close=")" separator=",">
${key}
</foreach>
values
<foreach collection="params.keys" item="key" open="(" close=")" separator=",">
#{params[${key}]}
</foreach>
</insert>
2、dao文件中写法:
Integer insert_B(@Param("params") Map param);
3、获得主键id:
param.put("is_hot", b010002Bean.getIs_hot());
b010002Service.insert_A(param);
String x = param.get("id").toString();
System.out.println("返回的id:"+x);