1.表设计
2.表SQL
1 CREATE TABLE `sys_dictionaries` ( 2 `ZD_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , 3 `NAME` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , 4 `BIANMA` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , 5 `ORDY_BY` int(10) NULL DEFAULT NULL , 6 `PARENT_ID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , 7 `JB` int(10) NULL DEFAULT NULL , 8 `P_BM` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL , 9 PRIMARY KEY (`ZD_ID`) 10 ) 11 ENGINE=InnoDB 12 DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci 13 ROW_FORMAT=COMPACT;
3.表字段说明
ZD_ID 唯一标识
NAME标识名称
BIANMA标识ID
ORDY_BY排序
PARENT_ID父级标识
JB级别
P_BM 父子级拼接标识
4.统一查询接口
5.统一查询接口SQL
1 SELECT 2 sd.`NAME`, 3 sd.BIANMA 4 FROM 5 sys_dictionaries sd 6 WHERE 7 sd.PARENT_ID IN ( 8 SELECT 9 d.ZD_ID 10 FROM 11 sys_dictionaries d 12 WHERE 13 d.P_BM = 'BILL_STATUS' 14 ) ;