ins_dm.sql

公务员工资系统软件工程文档及源代码——JAVA编写（包括整个分析设计代码实现全过程）

--清空代码表
DELETE FROM DM_MX;
DELETE FROM DM_LX;


--通用代码以0开头
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0001','区县');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0002','街道');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0003','户籍类别');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0004','性别');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0005','是否');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0006','民族');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0007','专业类型');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('0','0008','专业明细');


--B01,单位管理部分代码
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1001','单位类别');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1002','单位性质');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1003','单位状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1004','所属行业');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1005','单位类型');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1006','单位减少原因');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('1','1007','单位变更字段');


--B02,执法检查信息部分代码
INSERT INTO DM_LX(LB,DMM,MC) VALUES('2','2001','检查途径');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('2','2002','工时制度');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('2','2003','专项检查名称');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('2','2004','年检是否合格');


--B03,案件部分代码
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3001','案件类别');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3002','案件处理情况');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3003','案件办理方式');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3004','群众举报途径');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3005','社会保险费征缴形式');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3006','删除状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3007','案卷状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3008','举报人类型');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('3','3009','督促类型');



--B05,公务员部分代码
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5001','组织培训部门');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5002','公务员职务');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5003','公务员所属编制');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5004','公务员政治面貌');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5005','公务员文化程度');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5006','公务员证件类别');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5007','公务员是否街乡');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5008','公务员证件注销原因');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5009','公务员状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5010','公务员减少状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5011','公务员授权状态');
INSERT INTO DM_LX(LB,DMM,MC) VALUES('5','5012','公务员审核结果');
commit;

/*****************
通用代码以0开头
*****************/
--区县代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','001','市处');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','101','东城');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','102','西城');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','103','崇文');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','104','宣武');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','105','朝阳');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','106','丰台');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','107','石景山');     
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','108','海淀');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','109','门头沟');     
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','111','房山');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','221','昌平');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','222','顺义');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','223','通州');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','224','大兴');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','226','平谷');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','227','怀柔');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','228','密云');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','229','延庆');       
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','231','经济开发区'); 
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0001','320','外埠');


--街道代码

--东城街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101101','东城区建国门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101102','东城区东华门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101103','东城区朝阳门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101104','东城区东四街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101105','东城区景山街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101106','东城区北新桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101107','东城区交道口街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101108','东城区安定门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101109','东城区东直门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','101110','东城区和平里街道');
--西城街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102116','西城区新街口街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102117','西城区德外街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102118','西城区展览路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102119','西城区丰盛街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102120','西城区福绥境街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102121','西城区厂桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102122','西城区二龙路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102123','西城区月坛街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102124','西城区阜外街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','102125','西城区西长安街街道');
--崇文街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103141','崇文区前门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103142','崇文区崇文门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103143','崇文区东花市街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103144','崇文区龙潭街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103145','崇文区体育馆路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103146','崇文区天坛街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','103147','崇文区永外街道');
--宣武街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104163','宣武区牛街街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104164','宣武区广内街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104165','宣武区广外街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104166','宣武区白纸坊街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104167','宣武区陶然亭街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104168','宣武区天桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104169','宣武区大栅栏街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104170','宣武区椿树街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','104171','宣武区清河街道');
--朝阳街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105186','朝阳区管庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105187','朝阳区八里庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105188','朝阳区呼家楼街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105189','朝阳区六里屯街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105190','朝阳区团结湖街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105191','朝阳区三里屯街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105192','朝阳区小关街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105193','朝阳区香河园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105194','朝阳区麦子店街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105195','朝阳区安贞街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105196','朝阳区左家庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105197','朝阳区建外街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105198','朝阳区亚运村街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105199','朝阳区双井街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105200','朝阳区朝外街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105201','朝阳区劲松街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105202','朝阳区垡头街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105203','朝阳区酒仙桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105204','朝阳区潘家园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105205','朝阳区和平街街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105206','朝阳区机场街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105207','朝阳区望京街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105208','朝阳区南磨房地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105209','朝阳区将台地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105210','朝阳区太阳宫地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105211','朝阳区高碑店地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105212','朝阳区大屯地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105213','朝阳区小红门乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105214','朝阳区楼梓庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105215','朝阳区南皋乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105216','朝阳区王四营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105217','朝阳区平房乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105218','朝阳区东风乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105219','朝阳区洼里乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105220','朝阳区来广营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105221','朝阳区金盏乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105222','朝阳区黄港乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105223','朝阳区孙河乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105224','朝阳区长营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105225','朝阳区管庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105226','朝阳区黑庄户乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105227','朝阳区三间房乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105228','朝阳区崔各庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105229','朝阳区豆各庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105230','朝阳区东坝乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','105231','朝阳区十八里店乡');
--海淀街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108243','海淀区海淀街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108244','海淀区羊坊店街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108245','海淀区紫竹院街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108246','海淀区马连洼街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108247','海淀区西三旗街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108248','海淀区甘家口街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108249','海淀区中关村街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108250','海淀区北下关街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108251','海淀区花园路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108252','海淀区学院路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108253','海淀区万寿路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108254','海淀区八里庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108255','海淀区青龙桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108256','海淀区清河街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108257','海淀区双榆树街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108258','海淀区清华园街道');