id, area_id, area, city_id select from sys_areas where city_id = #{cityId,jdbcType=VARCHAR} select from sys_areas where id = #{id,jdbcType=INTEGER} select from sys_areas delete from sys_areas where id = #{id,jdbcType=INTEGER} insert into sys_areas (id, area_id, area, city_id) values (#{id,jdbcType=INTEGER}, #{areaId,jdbcType=VARCHAR}, #{area,jdbcType=VARCHAR}, #{cityId,jdbcType=VARCHAR}) insert into sys_areas id, area_id, area, city_id, #{id,jdbcType=INTEGER}, #{areaId,jdbcType=VARCHAR}, #{area,jdbcType=VARCHAR}, #{cityId,jdbcType=VARCHAR}, update sys_areas area_id = #{areaId,jdbcType=VARCHAR}, area = #{area,jdbcType=VARCHAR}, city_id = #{cityId,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update sys_areas set area_id = #{areaId,jdbcType=VARCHAR}, area = #{area,jdbcType=VARCHAR}, city_id = #{cityId,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} SELECT area FROM sys_areas WHERE area_id=#{areaId}