1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
| <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.laisc.securitydemo003.mapper.UserMapper">
<insert id="insertUser" parameterType="com.laisc.securitydemo003.entity.User"> insert into myuser (username, password, role) VALUES (#{username}, #{password}, #{role}) </insert>
<resultMap id="myfinduser" type="com.laisc.securitydemo003.entity.User"> <id property="id" column="id"/> <result property="username" column="username"/> <result property="password" column="password"/> <result property="role" column="role"/> </resultMap> <select id="findOneUser" resultMap="myfinduser" parameterType="com.laisc.securitydemo003.entity.User"> select myuser.id id, myuser.username username, myuser.password password, myuser.role role from myuser where username = #{username} </select>
<select id="findManyUser" resultMap="myfinduser" parameterType="com.laisc.securitydemo003.entity.User"> select myuser.id id, myuser.username username, myuser.password password, myuser.role role from myuser where username = #{username} </select>
<select id="findManyUser2" resultType="com.laisc.securitydemo003.entity.User" parameterType="com.laisc.securitydemo003.entity.User"> select myuser.id id, myuser.username username, myuser.password password, myuser.role role from myuser where username = #{username} </select>
<select id="findManyUser3" resultType="Map" parameterType="com.laisc.securitydemo003.entity.User"> select myuser.id id, myuser.username username, myuser.password password, myuser.role role from myuser where username = #{username} </select>
<select id="findManyUser4" resultType="Map" parameterType="Map"> select myuser.id id, myuser.username username, myuser.password password, myuser.role role from myuser where username = #{username} </select>
<update id="updateUserPasswordAndRole" parameterType="com.laisc.securitydemo003.entity.User"> update myuser <set> myuser.password=#{password}, myuser.role=#{role} </set> where username = #{username} </update>
<update id="updateUser" parameterType="com.laisc.securitydemo003.entity.User">-- 不更新值为空的数据 update myuser <set> <if test="id != null and id != -1 ">id=#{id},</if> <if test="password != null and password != '' ">password=#{password},</if> <if test="role != null and role != '' ">role=#{role},</if>
</set> where username = #{username} </update>
<delete id="deleteUser" parameterType="String"> delete from myuser where username = #{username} </delete>
</mapper>
|