id, name, province, city, area, address, phoneNum, postal, user_id, defaultAess select from cab_address where user_id = #{userId,jdbcType=VARCHAR} order by defaultAess desc,id desc delete from cab_address where id = ${id} and user_id = #{userId} insert into cab_address id, name, province, city, area, address, phoneNum, postal, user_id, create_time,update_time, #{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{province,jdbcType=VARCHAR}, #{city,jdbcType=VARCHAR}, #{area,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR}, #{phonenum,jdbcType=VARCHAR}, #{postal,jdbcType=VARCHAR}, #{userId,jdbcType=VARCHAR}, sysdate(),sysdate(), update cab_address name = #{name,jdbcType=VARCHAR}, city = #{city,jdbcType=VARCHAR}, province = #{province,jdbcType=VARCHAR}, area = #{area,jdbcType=VARCHAR}, address = #{address,jdbcType=VARCHAR}, phoneNum = #{phonenum,jdbcType=VARCHAR}, postal = #{postal,jdbcType=VARCHAR}, defaultAess=#{defaultAess,jdbcType=INTEGER}, update_time = sysdate(), where id = #{id,jdbcType=INTEGER} and user_id=#{userId} update cab_address set defaultAess = 1 where id = #{id} and user_id = #{userId} update cab_address set defaultAess = 0 where user_id = #{userId}