ins_dm.sql

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

INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229647','延庆县康庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229648','延庆县永宁镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229649','延庆县沈家营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229650','延庆县张山营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229651','延庆县四海镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229652','延庆县香营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229653','延庆县八达岭镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229654','延庆县刘斌堡镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229655','延庆县大庄科乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229656','延庆县千家店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229657','延庆县旧县镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229658','延庆县井庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229659','延庆县珍珠泉乡');
--密云街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228551','密云县巨各庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228552','密云县河南寨镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228553','密云县东邵渠镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228554','密云县西田各庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228555','密云县古北口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228556','密云县北庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228557','密云县十里堡镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228558','密云县密云镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228559','密云县石城镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228560','密云县高岭镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228561','密云县新城子镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228562','密云县大城子镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228563','密云县冯家峪镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228564','密云县溪翁庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228565','密云县穆家峪镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228567','密云县不老屯镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228568','密云县太师屯镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228569','密云县');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','228570','密云县檀营乡');
--大兴街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224479','大兴区旧宫镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224480','大兴区黄村镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224481','大兴区林校街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224482','大兴区兴丰街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224483','大兴区清源街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224484','大兴区北臧村镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224485','大兴区榆垡镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224486','大兴区礼贤镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224487','大兴区安定镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224488','大兴区魏善庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224489','大兴区青云店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224490','大兴区西红门镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224491','大兴区瀛海镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224492','大兴区亦庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224493','大兴区长子营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224494','大兴区采育镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','224495','大兴区庞各庄镇');
--开发区街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','231673','北京经济技术开发区');
--外埠街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','320701','外埠');


--户籍类别代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0003','01','本市城镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0003','02','外地城镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0003','03','本市农民');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0003','04','外地农民');


--性别代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0004','01','男');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0004','02','女');


--是否代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0005','01','是');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0005','02','否');


--民族代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','01','汉族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','02','蒙古族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','03','回族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','04','藏族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','05','维吾尔');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','06','苗族族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','07','彝族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','08','壮族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','09','布依族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','10','朝鲜族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','11','满族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','12','侗族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','13','瑶族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','14','白族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','15','土家族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','16','哈尼族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','17','哈萨克族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','18','傣族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','19','黎族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','20','傈傈族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','21','佤族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','22','畲族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','23','高山族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','24','拉祜族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','25','水族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','26','东乡族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','27','纳西族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','28','景颇族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','29','柯尔克孜族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','30','土族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','31','达斡尔族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','32','仫佬族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','33','羌族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','34','布朗族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','35','撒拉族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','36','毛难族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','37','仡佬族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','38','锡伯族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','39','阿昌族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','40','普米族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','41','塔吉克族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','42','怒族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','43','乌孜别克族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','44','俄罗斯族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','45','鄂温克族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','46','崩龙族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','47','保安族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','48','裕固族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','49','京族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','50','塔塔尔族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','51','独龙族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','52','鄂伦春族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','53','赫哲族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','54','门巴族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','55','珞巴族');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0006','56','基诺族');


--专业类型
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','010000','信息工程技术类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','020000','工业工程技术类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','030000','种植养殖类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','040000','轻工、纺织、食品加工类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','050000','环境保护类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','060000','城市和基础设施建设类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','070000','管理类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','080000','经济类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','090000','金融类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','100000','财会类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','110000','商贸类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','120000','法律类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','130000','教育与科学研究类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','140000','新闻出版、平面媒体类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','150000','文化艺术类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','170000','体育、娱乐休闲');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','180000','医药卫生');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','190000','中介咨询类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','200000','通用人才类');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0007','990000','其他类（本分类编码表以外人才）');
--专业名细
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010101','电磁场与微波技术');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010102','物理电子与光电子技术');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010103','微电子技术');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010104','电子材料与元器件');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010201','计算机硬件');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010202','计算机软件');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010203','计算机网络');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010204','计算机应用');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010205','计算机系统分析');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010206','计算机系统集成');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010301','有线通信');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010302','无线通讯');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010303','微波通信');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010304','光通讯');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','010305','卫星通讯');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','019901','其他信息技术');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020101','机械设计与制造');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020102','金属加工工艺');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020103','重型机械制造');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020104','运输机械制造');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020105','精密机械制造');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020106','仪器仪表制造');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020107','腐蚀防护技术');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020201','钢铁冶金');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020202','有色金属冶金');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020203','高分子材料');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020204','复合材料');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020205','建筑材料');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020299','其他材料');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020301','无机化工');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020302','有机化工');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020303','石油化工');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020304','精细化工');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020305','化学制药');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020306','生物化学工程');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020399','其他');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020401','勘探');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020402','采矿');
INSERT INTO DM_MX(DMM,DM,MC) VALUES ('0008','020403','选矿');