1. 获取省市区列表-数据库
创建t_dict_district表如下所示:
2. 省市区列表-实体类
创建一个District实体类:
package com.cy.store.entity;
public class District extends BaseEntity{
private Integer id;
private String parent;
private String code;
private String name;
}
3. 持久层
根据父代号进行查询
1. mapper接口:
package com.cy.store.mapper;
import com.cy.store.entity.District;
import java.util.List;
public interface DistrictMapper {
/**
* 根据父代号查询区域信息
* @param parent 父代号
* @return 某个父区域下所有的区域信息
*/
List<District> findByParent(String parent);
}
2. sql映射文件
<?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.cy.store.mapper.DistrictMapper">
<select id="findByParent" resultType="com.cy.store.entity.District">
select id,parent,code,`name` from t_dict_district where parent=#{parent}
</select>