查询:
<select id="selectByAccount" resultMap="BaseResultMap">
SELECT * FROM qy_admin
<where>
<if test="account!=null">
account=#{account}
</if>
<if test="add_time != null">
AND add_time=#{add_time}
</if>
</where>
</select>
更新:
<update id="updateAccount">
UPDATE qy_admin
<set>
<if test="add_time!=null">add_time=#{add_time}
</if>
</set>
where account=#{account}
</update>