1 插入记录,将生成的主键值存储在id中,在java中用map.get('id')获取主键值。
<insert id="xx" parameterType="java.util.HashMap" resultType="java.util.HashMap" useGeneratedKeys="true" keyProperty="id">sql(参数获取方式#{map.key})</insert>
2 批量更新若干记录
<update id="xx" parameterType="java.util.HashMap">update ... where ids in (${ids}'')</update>
<update id="xx" parameterType="java.util.HashMap"> map.sqls=[sql1,sql2,sql3...]
<foreach collection="sqls" index="index" item="item">
${item}
</foreach>
</update>
3 查询记录
<select id="xx" resultType="java.util.HashMap"> select * from tb where id=#{paramName}</select>
4 删除记录
<delete id="deleteFPfile" parameterType="java.util.HashMap">DELETE FROM tb WHERE id=#{id}</delete>
5 子语句
<if test="x != null and x !='null' and x != ''"> AND COLNAME=#{paramName} </if>
6 自定义返回结果类型
<resultMap type=" Users" id="usersMap" autoMapping="true"> 定义对应的类,可以使用list<Users>
<id column="code" property="code"/>
<result column="pwd" property="pwd"/>
</resultMap>
<select id="finduser" resultType="java.util.HashMap" parameterType=" Users">
select * from user where ...
</select>
public List yyy( Users user){
List l=sessionTemplate.selectList("finduser", user);
return l;
}
<insert id="xx" parameterType="java.util.HashMap" resultType="java.util.HashMap" useGeneratedKeys="true" keyProperty="id">sql(参数获取方式#{map.key})</insert>
2 批量更新若干记录
<update id="xx" parameterType="java.util.HashMap">update ... where ids in (${ids}'')</update>
<update id="xx" parameterType="java.util.HashMap"> map.sqls=[sql1,sql2,sql3...]
<foreach collection="sqls" index="index" item="item">
${item}
</foreach>
</update>
3 查询记录
<select id="xx" resultType="java.util.HashMap"> select * from tb where id=#{paramName}</select>
4 删除记录
<delete id="deleteFPfile" parameterType="java.util.HashMap">DELETE FROM tb WHERE id=#{id}</delete>
5 子语句
<if test="x != null and x !='null' and x != ''"> AND COLNAME=#{paramName} </if>
6 自定义返回结果类型
<resultMap type=" Users" id="usersMap" autoMapping="true"> 定义对应的类,可以使用list<Users>
<id column="code" property="code"/>
<result column="pwd" property="pwd"/>
</resultMap>
<select id="finduser" resultType="java.util.HashMap" parameterType=" Users">
select * from user where ...
</select>
public List yyy( Users user){
List l=sessionTemplate.selectList("finduser", user);
return l;
}