Controller层
@RequiresPermissions ( "platform:district:view" )
@GetMapping ( )
public String district ( ModelMap mmap) {
String areaInfo = iSysConfigService. selectConfigByKey ( "areaInfo" ) ;
String[ ] split = areaInfo. split ( "-" ) ;
Map< String, Object> map= new HashMap < String, Object> ( ) ;
map. put ( "provinceId" , split[ 0 ] ) ;
map. put ( "cityId" , split[ 1 ] ) ;
map. put ( "areaId" , split[ 2 ] ) ;
String districts = iDistrictsService. findDistricts ( map) ;
mmap. put ( "district" , districts) ;
return prefix + "/district" ;
}
dao层
public String findDistricts ( Map< String, Object> map) ;
@Override
public String findDistricts ( Map< String, Object> map) {
String districts = districtsMapper. findDistricts ( map) ;
return districts;
}
public String findDistricts ( Map< String, Object> map) ;
mapper层
< ! -- 查询省市区-- >
< select id= "findDistricts" resultType= "java.lang.String" parameterType= "map" >
SELECT GROUP_CONCAT ( `name`) AS aaa FROM sys_districts WHERE id IN
( #{ provinceId} , #{ cityId} , #{ areaId} )
< / select>