中国省市区列表MySQLl数据库脚本

中国省市区列表MySQLl数据库脚本

链接：https://pan.baidu.com/s/10CTYSF2JWRXwkRQA7rZRmQ

提取码：lsak

省市区的数据实体类

package com.xiaoxiannv.store.entity;

import java.util.Objects;

/**
 * 省市区的数据实体类
 */
public class District extends BaseEntity {
    private Integer id;
    private String parent;
    private String code;
    private String name;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getParent() {
        return parent;
    }

    public void setParent(String parent) {
        this.parent = parent;
    }

    public String getCode() {
        return code;
    }

    public void setCode(String code) {
        this.code = code;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;
        if (!super.equals(o)) return false;
        District district = (District) o;
        return Objects.equals(id, district.id) && Objects.equals(parent, district.parent) && Objects.equals(code, district.code) && Objects.equals(name, district.name);
    }

    @Override
    public int hashCode() {
        return Objects.hash(super.hashCode(), id, parent, code, name);
    }

    @Override
    public String toString() {
        return "District{" +
                "id=" + id +
                ", parent='" + parent + '\'' +
                ", code='" + code + '\'' +
                ", name='" + name + '\'' +
                '}';
    }
}

获取省市区列表持久层

package com.xiaoxiannv.store.mapper;

import com.xiaoxiannv.store.entity.District;

import java.util.List;

public interface DistrictMapper {
    /**
     * 根据父代号查询区域信息
     *
     * @param parent 父代号
     * @return 某个父区域下的所有区域列表
     */
    List<District> findByParent(String parent);
}

持久层映射xml文件

<?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.xiaoxiannv.store.mapper.DistrictMapper">
    <select id="findByParent" resultType="com.xiaoxiannv.store.entity.District">
        SELECT *
        FROM district
        WHERE parent = #{parent}
    </select>

</mapper>

获取省市区列表业务层

package com.xiaoxiannv.store.service;

import com.xiaoxiannv.store.entity.District;

import java.util.List;

public interface DistrictService {
    /**
     * 根据父代号来查询区域信息（省市区）
     *
     * @param parent 父代号
     * @return 多个区域的信息
     */
    List<District> getByParent(String parent);
}

package com.xiaoxiannv.store.service.impl;

import com.xiaoxiannv.store.entity.District;
import com.xiaoxiannv.store.mapper.DistrictMapper;
import com.xiaoxiannv.store.service.DistrictService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class DistrictServiceImpl implements DistrictService {
    @Autowired
    private DistrictMapper districtMapper;

    @Override
    public List<District> getByParent(String parent) {
        List<District> list = districtMapper.findByParent(parent);
        /**
         * 在进行网络数据传输时，为了尽量避免无效数据的传递，可以将无效数据设置null，可以节省流量，另一方面提升了效率
         */
        for (District d : list) {
            d.setId(null);
            d.setParent(null);
        }
        return list;
    }
}

获取省市区列表控制层

package com.xiaoxiannv.store.controller;

import com.xiaoxiannv.store.entity.District;
import com.xiaoxiannv.store.service.DistrictService;
import com.xiaoxiannv.store.util.JsonResult;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
@RequestMapping("districts")
@Api(tags = "获取省市区列表", value = "DistrictController")
public class DistrictController extends BaseController {
    @Autowired
    private DistrictService districtService;


    //districts开头的请求都被拦截到getByParent（）方法
    @RequestMapping({"/", ""})
    @ApiOperation("省市区列表")
    public JsonResult<List<District>> getByParent(String parent) {
        List<District> data = districtService.getByParent(parent);
        return new JsonResult<>(ok, data);
    }
}