ins_dm.sql

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

INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108259','海淀区燕园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108260','海淀区香山街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108261','海淀区田村路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108262','海淀区上地街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108263','海淀区北太平庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108264','海淀区永定路街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108265','海淀区聂各庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108266','海淀区永丰乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108267','海淀区北安河乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108268','海淀区苏家坨乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108269','海淀区温泉乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108270','海淀区上庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108271','海淀区东北旺乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108272','海淀区东升乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108273','海淀区四季青乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','108274','海淀区海淀乡');
--丰台街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106295','丰台区云岗街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106296','丰台区长辛店街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106297','丰台区卢沟桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106298','丰台区丰台镇街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106299','丰台区新村街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106300','丰台区南苑街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106301','丰台区东高地街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106302','丰台区大红门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106303','丰台区东铁营街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106304','丰台区方庄街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106305','丰台区右安门街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106306','丰台区西罗园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106307','丰台区太平桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106308','丰台区宛平街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106309','丰台区马家堡街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106310','丰台区和义街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106311','丰台区南苑乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106312','丰台区花乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106313','丰台区卢沟桥乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106314','丰台区长辛店乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','106315','丰台区王佐庄乡');
--石景山街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107341','石景山区八宝山街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107342','石景山区老山街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107343','石景山区八角街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107344','石景山区古城街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107345','石景山区苹果园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107346','石景山区金顶街街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107347','石景山区广宁村街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107348','石景山区五里坨街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','107349','石景山区鲁谷社区委员会');
--门头沟街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109364','门头沟区龙泉镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109365','门头沟区大峪街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109366','门头沟区城子街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109367','门头沟区东辛房街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109368','门头沟区大台街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109369','门头沟区王平镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109370','门头沟区军庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109371','门头沟区永定镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109372','门头沟区斋堂镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109373','门头沟区妙峰山镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109374','门头沟区清水镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109375','门头沟区雁翅镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','109376','门头沟区潭拓寺镇');
--房山街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111391','房山区城关街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111392','房山区良乡镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111393','房山区周口店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111394','房山区琉璃河镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111395','房山区窦店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111396','房山区石楼镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111397','房山区长沟镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111399','房山区张坊镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111400','房山区十渡镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111402','房山区阎村镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111419','房山区河北镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111420','房山区韩村河镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111424','房山区青龙湖镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111425','房山区长阳镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111426','房山区新镇街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111427','房山区燕山街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111428','房山区向阳街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111429','房山区栗园街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111430','房山区迎风街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111431','房山区东风街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111432','房山区星城街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111433','房山区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111434','房山区大石窝镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111435','房山区佛子庄乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111436','房山区南窖乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111437','房山区大安山乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111438','房山区史家营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111439','房山区霞云岭乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','111440','房山区蒲洼乡');
--通州街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223448','通州区北苑街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223449','通州区新华街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223450','通州区玉桥街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223451','通州区中仓街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223452','通州区永顺镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223453','通州区梨园镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223454','通州区潞城镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223455','通州区宋庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223456','通州区西集镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223457','通州区马驹桥镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223458','通州区漷县镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223459','通州区张家湾镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223460','通州区于家务乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223461','通州区永乐店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223462','通州区台湖镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','223463','通州乡镇');
--平谷街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226613','平谷区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226614','平谷城镇办事处');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226615','平谷区大华山镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226616','平谷区东高村镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226617','平谷区镇罗营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226618','平谷区夏各庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226619','平谷区刘店镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226620','平谷区南独乐河镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226621','平谷区峪口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226622','平谷区韩庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226623','平谷区马昌营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226624','平谷区靠山集镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226625','平谷区大兴庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226626','平谷区山东庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226627','平谷区黄松峪镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226628','平谷区王辛庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226629','平谷区熊儿寨乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226630','平谷区马坊镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','226631','平谷区城关镇');
--昌平街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221510','昌平区小汤山镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221511','昌平区沙河镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221512','昌平区阳坊镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221513','昌平区南口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221514','昌平区城北街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221536','昌平区马池口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221537','昌平区回龙观镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221538','昌平区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221539','昌平区昌平镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221540','昌平区长陵镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221541','昌平区十三陵镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221542','昌平区北七家镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221543','昌平区兴寿镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221544','昌平区南邵镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221545','昌平区百善镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221546','昌平区东小口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221547','昌平区流村镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','221548','昌平区崔村镇');
--怀柔街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227583','怀柔区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227584','怀柔区泉河街道办事处');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227585','怀柔区龙山街道办事处');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227586','怀柔区慕田峪旅游办事处');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227587','怀柔区怀柔镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227588','怀柔区北房镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227589','怀柔区杨宋镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227590','怀柔区庙城镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227591','怀柔区桥梓镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227592','怀柔区怀北镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227593','怀柔区雁栖镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227594','怀柔区九渡河镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227595','怀柔区渤海镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227596','怀柔区汤河口镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227597','怀柔区琉璃庙镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227598','怀柔区宝山镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227599','怀柔区长哨营乡');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','227560','怀柔区喇叭沟门乡');
--顺义街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222515','顺义区胜利街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222516','顺义区光明街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222517','顺义区仁和地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222518','顺义区天竺地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222519','顺义区后沙峪地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222520','顺义区南法信地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222521','顺义区马坡地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222522','顺义区牛山地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222523','顺义区杨镇地区');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222524','顺义区赵全营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222525','顺义区北石槽镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222526','顺义区高丽营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222527','顺义区李桥镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222528','顺义区张镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222529','顺义区北务镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222530','顺义区大孙各庄镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222531','顺义区木林镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222532','顺义区龙湾屯镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222533','顺义区南彩镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222534','顺义区北小营镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','222535','顺义区李遂镇');
--延庆街道代码
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229643','延庆县');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229644','延庆县延庆镇');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229645','延庆城镇办事处');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('0002','229646','延庆县大榆树镇');