MyBatis第二天

一丶MyBatis的CRUD操作【重点】

1丶查询

 1.1序号参数绑定

public Empmanager selsectId(String username);

<select id="selsectId" resultType="Empmanager">
            SELECT * FROM empmanager where username = #{age0}
        </select>

1.2注解参数绑定

public Empmanager ParamSelectId(@Param("username") String username,@Param("password") String password);

<select id="ParamSelectId" resultType="Empmanager">
            SELECT * FROM empmanager where username = #{username} and password = #{password}
        </select>

1.3Map参数绑定

public Empmanager mapSelectId(Map map);

<select id="mapSelectId" resultType="Empmanager">
            SELECT * FROM empmanager where username = #{username} and password = #{password}
        </select>

1.4对象绑定参数

public Empmanager empmanagerSelectId(Empmanager empmanager);

<select id="empmanagerSelectId" resultType="Empmanager">
            SELECT * FROM empmanager where username = #{username} and password = #{password}
        </select>

1.5模糊查询

public List<Empmanager> selsectId2(@Param("username") String username);

<select id="selsectId2" resultType="Empmanager">
            SELECT * FROM empmanager
            where username LIKE '%${username}%'
        </select>

<select id="selsectId2" resultType="Empmanager">
            SELECT * FROM empmanager
            where username LIKE concat(concat('%',#{username},'%'))
        </select>

2丶删除

public int delectId(String username);

<delete id="delectId" parameterType="String">
        delete from empmanager where username = #{username}
    </delete>

3丶修改

public int updateId(Empmanager empmanager);

<update id="updateId" parameterType="Empmanager">
        update empmanager SET password = #{password}
        where username = #{username}
    </update>

4丶添加

public int insertId(Empmanager empmanager);

<insert id="insertId" parameterType="Empmanager">
        insert into empmanager values (#{username},#{password});
    </insert>

5丶主键回填

5.1通过last_insert_id()查询主键

<insert id="insertId" parameterType="Empmanager">
        <selectKey keyProperty="username" resultType="String" order="AFTER">
            select last_insert_id()
        </selectKey>
            insert into empmanager values (#{username},#{password});
    </insert>

5.2通过uuid()查询主键

<insert id="insertId" parameterType="Empmanager">
        <selectKey keyProperty="username" resultType="String" order="BEFORE">
            select REPLACE(UUID(),'-','')
        </selectKey>
            insert into empmanager values (#{username},#{password});
    </insert>