Java，基于SSM,省市区三级联动后台查询（单表），附（建表语句+查询Sql）

最新推荐文章于 2024-07-07 03:46:50 发布

qiangxuan520

最新推荐文章于 2024-07-07 03:46:50 发布

阅读量4.6k

点赞数

分类专栏： java 文章标签：省市区三级联动

本文链接：https://blog.csdn.net/qiangxuan520/article/details/83177273

版权

java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1、建表语句

CREATE TABLE "hxdb"."sys_area" (
"id" varchar(64) COLLATE "default" NOT NULL,
"code" varchar(64) COLLATE "default",
"province" varchar(64) COLLATE "default",
"city" varchar(64) COLLATE "default",
"district" varchar(64) COLLATE "default",
"parent" varchar(64) COLLATE "default"
)
WITH (OIDS=FALSE);

2、查询Sql语句

WITH RECURSIVE cte AS (
   SELECT
       ID,
       code,
       province,
       city,
       district,
       parent
   FROM
       hxdb.sys_area A
   WHERE
       parent = '1'
   UNION ALL
       SELECT
           K . ID,
           K .code,
           K .province,
           K .city,
           K .district,
           K .parent
       FROM
           hxdb.sys_area K
       INNER JOIN cte C ON C .parent = K . ID
) SELECT
   ID,
   code,
   province,
   city,
   district,
   parent
FROM
   hxdb.sys_area cte
WHERE
   province != ''
OR city != ''
OR district != ''