mybaties的副配置代码（简单的增删改查语句）

mybaties的副配置代码（简单的增删改查语句）

<?xml version="1.0" encoding="UTF-8" ?> select * from users where uid = #{uid} username,password,nickname,age,gender,phone,createTime,updateTime,lastLogin,userStatus,remark insert into users() values(#{name},#{password},#{nickname},#{age},#{gender},#{phone},#{createTime},#{updateTime},#{lastLogin},#{userStatus},#{remark})

<!-- 修改操作-->    <update id="updateUser">        update users        <!-- 加上判断，为空的就不修改数据,解决固定化sql问题-->        <set>            <if test="name != null">username = #{name},</if>            <if test="password != null">password = #{password},</if>            <if test="nickname != null">nickname = #{nickname},</if>            <if test="age != null">age = #{age},</if>            <if test="gender != null">gender = #{gender},</if>            <if test="phone != null">phone = #{phone},</if>            <if test="createTime != null">createTime = #{createTime},</if>            <if test="updateTime != null">updateTime = #{updateTime},</if>            <if test="lastLogin != null">lastLogin = #{lastLogin},</if>            <if test="userStatus != null">userStatus = #{userStatus},</if>            <if test="remark != null">remark = #{remark},</if>        </set>        where uid = #{uid}        <!--        update users set        password = #{password},        nickname = #{nickname},        age = #{age},        gender = #{gender},        phone = #{phone},        createTime = #{createTime},        updateTime = #{updateTime},        lastLogin = #{lastLogin},        userStatus = #{userStatus},        remark = #{remark},        where uid = #{uid}-->    </update>    <!--删除操作-->    <delete id="delUser">        delete from users where uid = #{uid}    </delete></mapper>