Mybatis---动态sql

insert动态sql

<insert id="saveUser">
        INSERT INTO  user_table
        //表明会在前后自动补上（）且结尾是，则会帮我们删除
        <trim prefix="（" suffix=")" suffixOverrides=",">
            <if test="nickname != null">
                nickname,
            </if>
            <if test="phone != null">
                phone,
            </if>
            <if test="age != null">
                age,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="nickname != null">
                #{nickname},
            </if>
            <if test="phone != null">
                #{phone},
            </if>
            <if test="age != null">
                #{age},
            </if>
           
        </trim>
    </insert>

update

    <update id="updateUserInfo">
        update user_table
        <set>
            <if test="nickname != null">nickname=#{nickname},</if>
            <if test="phone!= null">phone=#{phone},</if>
            <if test="age != null">age=#{age},</if>
        </set>
        where user_id = #{userID}
    </update>

select

    <select id="getUser" resultType="com.twoblog.twoblogmaster.POJO.PO.User">
        select nickname,phone,age
        <where>
            <if test = "username != null and username != ''">
                ut.username = #{username}
            </if>
            <if test="password != null and password != ''">
                AND ut.password = #{password}
            </if>
        </where>
    </select>