/**
* 接口层
* Created by zhangjh on 2016-6-11 22:58:51
*/
@RestController
public class SysCityController extends BaseController<SysCity> {
@Resource(name = "sysCityServiceImpl")
private ISysCityService sysCityServiceImpl;
/**
* 新增
*
* @return
*/
@SystemControllerLog(description = "新增")
@RequestMapping(value = "/sysCity", method = RequestMethod.POST)
@IgnoreSecurity
public Response create(@Valid @RequestBody SysCity sysCity) {
sysCityServiceImpl.add(sysCity);
Response response = buildResponea(sysCity);
return response;
}
/**
* @param businessKey
* @return
*/
@SystemControllerLog(description = "查询详细信息")
@RequestMapping(value = "/sysCity/{businessKey}", method = RequestMethod.GET)
@IgnoreSecurity
public Response queryByBusinessKey(@PathVariable("businessKey") String businessKey) {
SysCity sysCity =sysCityServiceImpl.queryInfoByNatrualKey(businessKey);
Response response = buildResponea(sysCity);
return response;
}
/**
* @param businessKey
* @return
*/
@SystemControllerLog(description = "删除")
@RequestMapping(value = "/sysCity/{businessKey}", method = RequestMethod.DELETE)
@IgnoreSecurity
public Response deleteByBusinessKey(@PathVariable("businessKey") String businessKey) {
SysCity sysCity = null;
sysCityServiceImpl.del(businessKey);
Response response = buildResponea(sysCity);
return response;
}
/**
* @param sysCity
* @return
*/
@SystemControllerLog(description = "更新")
@RequestMapping(value = "/sysCity/{businessKey}", method = RequestMethod.PUT)
@IgnoreSecurity
public Response update(@PathVariable("businessKey") String businessKey, /**@Valid*/ @RequestBody SysCity sysCity) {
sysCityServiceImpl.edit(sysCity);
Response response = buildResponea(sysCity);
return response;
}
/**
*
* @param infos List<SysCity>
* @return
*/
@SystemControllerLog(description = "批量更新")
@RequestMapping(value = "/sysCity", method = RequestMethod.PUT)
@IgnoreSecurity
public Response updateBatch(@RequestBody List<SysCity> infos) {
sysCityServiceImpl.updateBatch(infos);
Response response = buildResponea(null);
return response;
}
/**
* @return 查询集合
*/
@SystemControllerLog(description = "查询列表")
@RequestMapping(value = "/comCompanys", method = RequestMethod.POST)
@IgnoreSecurity
public Response search(HttpServletRequest request, @RequestBody SysCity sysCity) {
Response response = buildSearchJsonMap(sysCity,request,sysCityServiceImpl);
return response;
}
}
/**
* 实体bean
* Created by zhangjh on 2016-6-11 22:58:51
*/
public class SysCity extends BaseForm{
private String cityName;
private String state;
private int id;
private int cityId;
private int provinceId;
public String getCityName(){
return this.cityName;
}
public void setCityName(String cityName){
this.cityName = cityName;
}
public String getState(){
return this.state;
}
public void setState(String state){
this.state = state;
}
public int getId(){
return this.id;
}
public void setId(int id){
this.id = id;
}
public int getCityId(){
return this.cityId;
}
public void setCityId(int cityId){
this.cityId = cityId;
}
public int getProvinceId(){
return this.provinceId;
}
public void setProvinceId(int provinceId){
this.provinceId = provinceId;
}
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cnfwsy.interfaces.mapper.SysCityMapper">
<sql id="searchInfoSql">
id AS id,
city_name,
state,
id,
city_id,
province_id
</sql>
<select id="queryInfo" resultType="com.cnfwsy.interfaces.bean.SysCity">
select
<include refid="searchInfoSql"/>
FROM t_sys_city a
WHERE
city_id = #{cityId}
limit 1
</select>
<select id="listInfosCounts" resultType="Integer">
SELECT COUNT(*)
FROM t_sys_city a
where del_flag=0
</select>
<select id="listFilteredInfosCounts" resultType="Integer">
SELECT COUNT(*)
FROM t_sys_city
where del_flag=0
<if test="cityName !=null and cityName != ''">
and city_name =#{cityName}
</if>
<if test="state !=null and state != ''">
and state =#{state}
</if>
<if test="id !=null and id != ''">
and id =#{id}
</if>
<if test="cityId !=null and cityId != ''">
and city_id =#{cityId}
</if>
<if test="provinceId !=null and provinceId != ''">
and province_id =#{provinceId}
</if>
</select>
<select id="searchInfos" resultType="com.cnfwsy.interfaces.bean.SysCity">
SELECT
<include refid="searchInfoSql"/>
FROM t_sys_city a
WHERE del_flag=0
<if test="cityName !=null and cityName != ''">
and city_name =#{cityName}
</if>
<if test="state !=null and state != ''">
and state =#{state}
</if>
<if test="id !=null and id != ''">
and id =#{id}
</if>
<if test="cityId !=null and cityId != ''">
and city_id =#{cityId}
</if>
<if test="provinceId !=null and provinceId != ''">
and province_id =#{provinceId}
</if>
#{limit}
</select>
<update id="updateInfo">
update
t_sys_city a
<set>
<if test="cityName !=null and cityName != ''">
city_name = #{cityName},
</if>
<if test="state !=null and state != ''">
state = #{state},
</if>
<if test="cityId !=null and cityId != ''">
city_id = #{cityId},
</if>
<if test="provinceId !=null and provinceId != ''">
province_id = #{provinceId},
</if>
</set>
WHERE
city_id = #{cityId}
</update>
<update id="del">
update t_sys_city a
set del_flag=1
where
city_id = #{cityId}
</update>
<insert id="add">
insert into
t_sys_city(city_name,state,city_id,province_id)
values (#{cityName},#{state},#{cityId},#{provinceId})
</insert>
</mapper>