springmvc下的省市县三级联动

jquery 操作前端；

// 获取省份列表
function getProvinceList(target) {
    $(target).html("");
    $(target).append('<option value="-1">请选择</option>');
    $.ajax({
        async : false,
        dataType : "JSON",
        type : 'POST',
        url : "select/queryProvince",
        data : {},
        success : function(data) {
            if (data && data.length > 0) {
                for ( var i = 0, len = data.length; i < len; i++) {
                    var option = $('<option value="' + data[i].id + '">'
                            + data[i].areaDesignation + '</option> ');
                    $(target).append(option);
                }
            }
        }
    });
}
// 获取城市列表
function getCityList(target, provinceId) {
    $(target).html("");
    if (provinceId != 10 && provinceId != 11 && provinceId != 18
            && provinceId != 31) {
        $(target).append('<option value="-1">请选择</option>');
    }
    $.ajax({
        async : false,
        dataType : "JSON",
        type : 'POST',
        url : "select/queryCityByProvinceId",
        data : {
            provinceId : provinceId
        },
        success : function(data) {
            if (data && data.length > 0) {
                for ( var i = 0, len = data.length; i < len; i++) {
                    var option = $('<option value="' + data[i].id + '">'
                            + data[i].areaDesignation + '</option> ');
                    $(target).append(option);
                }
            }
        }
    });
}
// 获取区县列表
function getCountyList(target, cityId) {
    $(target).html("");
    $(target).append('<option value="-1">请选择</option>');
    $.ajax({
        async : true,
        dataType : "JSON",
        type : 'POST',
        url : "select/queryCountyByCityId",
        data : {
            cityId : cityId
        },
        success : function(data) {
            if (data && data.length > 0) {
                for ( var i = 0, len = data.length; i < len; i++) {
                    var option = $('<option value="' + data[i].id + '">'
                            + data[i].areaDesignation + '</option> ');
                    $(target).append(option);
                }
            }
        }
    });
}

controller层

@Controller
@RequestMapping("/select")
public class SelectController extends BaseController {

    @Resource
    private SelectService selectService;

    @RequestMapping(value="queryProvince",produces="application/json;charset=UTF-8")
    @ResponseBody
    public List<Map<String, Object>> queryProvince(){
        return selectService.queryProvince();
    }

    @RequestMapping(value="queryCityByProvinceId",produces="application/json;charset=UTF-8")
    @ResponseBody
    public List<Map<String, Object>> queryCityByProvinceId(int province_id){
        return selectService.queryCityByProvinceId(province_id);
    }

    @RequestMapping(value="queryCountyByCityId",produces="application/json;charset=UTF-8")
    @ResponseBody
    public List<Map<String, Object>> queryCountyByCityId(int city_id){
        return selectService.queryCountyByCityId(city_id);
    }

    @RequestMapping(value="queryTrade",produces="application/json;charset=UTF-8")
    @ResponseBody
    public List<Map<String, Object>> queryTrade(){
        return selectService.queryTrade();
    }

}

service实现层

@Service("selectService")
public class SelectServiceServiceImpl implements SelectService {

    @Resource
    private SelectMapper selectMapper;

    public List<Map<String, Object>> queryProvince() {
        return selectMapper.queryProvince();
    }

    public List<Map<String, Object>> queryCityByProvinceId(int province_id) {
        return selectMapper.queryCityByProvinceId(province_id);
    }

    public List<Map<String, Object>> queryCountyByCityId(int city_id) {

        return selectMapper.queryCountyByCityId(city_id);
    }

    public List<Map<String, Object>> queryTrade() {
        return selectMapper.queryTrade();
    }
}

dao层

public interface SelectMapper {

    List<Map<String, Object>> queryProvince();

    List<Map<String, Object>> queryCityByProvinceId(int province_id);

    List<Map<String, Object>> queryCountyByCityId(int city_id);

    List<Map<String, Object>> queryTrade();

}

dao层实现层

<?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...dao.SelectMapper">
    <select id="queryProvince" resultType="java.util.Map">
        SELECT id,area_designation FROM area_info WHERE LEVEL = 3
    </select>
    <select id="queryCityByProvinceId" resultType="java.util.Map" parameterType="java.lang.Integer">
        SELECT id,area_designation FROM area_info WHERE LEVEL = 4 AND pre_id = #{province_id}
    </select>
    <select id="queryCountyByCityId" resultType="java.util.Map" parameterType="java.lang.Integer">
        SELECT id,area_designation FROM area_info WHERE LEVEL = 5 AND pre_id = #{city_id}
    </select>
    <select id="queryTrade" resultType="java.util.Map">
        SELECT id,trade_category FROM trade_info WHERE is_used = 1
    </select>
</mapper>