insert.sql

来自「公务员工资系统软件工程文档及源代码——JAVA编写（包括整个分析设计代码实现全过」· SQL 代码 · 共 344 行 · 第 1/2 页

INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500005'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500006'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500007'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500008'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0700001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0700002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0700003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0900001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0900002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0300002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0300003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0300004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0400001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0900003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0400002'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0400003'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0100001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0900004'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500012'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500011'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'2', 'B0300001'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500010'); 
INSERT INTO QX_GROUP_LIST ( GID, IID ) VALUES ( 
'1', 'B0500009'); 
commit;
 
 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'2', '公务信息管理', NULL, NULL, NULL, NULL, 0, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'3', '不良信息管理', NULL, NULL, NULL, NULL, 0, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'4', '公务员管理', NULL, NULL, NULL, NULL, 0, 4); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'5', '统计报表', NULL, NULL, NULL, NULL, 0, 5); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'6', '工作用表', NULL, NULL, NULL, NULL, 0, 6); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'7', '法规制度管理', NULL, NULL, NULL, NULL, 0, 7); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'8', '单位登记', 'dw/dw_xxcx.jsp', NULL, NULL, NULL, 1, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'9', '单位减少', 'dw/dw_jscx.jsp', NULL, NULL, 'B0100001', 1, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'10', '已减少单位恢复', 'dw/dw_jscxhf.jsp', NULL, NULL, 'B0100001', 1, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'11', '执法检查信息查询', 'dw/zf_jcxxcx.jsp', NULL, NULL, 'B0100001', 2, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'12', '新增案件', 'dw/zf_jccx.jsp', NULL, NULL, 'B0100001', 2, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'13', '案件列表', 'aj/aj_list.jsp', NULL, NULL, 'B0100001', 2, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'14', '案卷管理', NULL, NULL, NULL, NULL, 2, 4); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'15', '新增不良信息', 'bl/bl_ajcx.jsp', NULL, NULL, NULL, 3, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'16', '查改不良信息', NULL, NULL, NULL, NULL, 3, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'17', '报送信息查询', NULL, NULL, NULL, NULL, 3, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'18', '公务员登记', 'JCYGL/jcy_ry_cx_select.jsp', NULL, NULL, 'B0500001', 4, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'19', '公务员审批', 'JCYGL/jcy_ry_sp_select.jsp', NULL, NULL, 'B0500004', 4, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'20', '公务单位管理', 'JCYGL/jcy_dw_select.jsp', NULL, NULL, 'B0500007', 4, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'21', '公务员口令维护', 'qxgl/qx_klgl.jsp', NULL, NULL, 'B0500008', 4, 4); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'22', '公务员权限管理', 'qxgl/qx_index.htm', NULL, NULL, 'B0500006', 4, 5); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'23', '劳动保障公务案件统计表', NULL, NULL, NULL, NULL, 5, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'24', '劳动保障公务专项工作统计表', NULL, NULL, NULL, NULL, 5, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'25', '劳动保障公务效果统计表', NULL, NULL, NULL, NULL, 5, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'26', '量化考核（人员管理）', NULL, NULL, NULL, NULL, 6, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'27', '全市案件情况', NULL, NULL, NULL, NULL, 6, 2); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'28', '全市企业案件发生情况', NULL, NULL, NULL, NULL, 6, 3); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'29', '举报件办理情况汇总表', NULL, NULL, NULL, NULL, 6, 6); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'30', '举报件办理情况明细表', NULL, NULL, NULL, NULL, 6, 7); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'1', '用人单位信息管理', NULL, NULL, NULL, NULL, 0, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'31', '开展对用人单位参加社会保险执法大检查情况统计表', NULL, NULL, NULL, NULL, 6
, 4); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'32', '劳动保障公务组织统计表', NULL, NULL, NULL, NULL, 6, 5); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'33', '新增法规制度', 'gzzd/fg_xxlr.jsp', NULL, NULL, 'B0100001', 7, 1); 
INSERT INTO QX_TREE_INF ( ID, MESSAGE, URL, IMAGE, COLOR, IID, LEVER,
SX ) VALUES ( 
'34', '查改法规制度', 'gzzd/fg_xxcx.jsp', NULL, NULL, 'B0100001', 7, 2); 
commit;
 
 
INSERT INTO QX_USER_GROUP ( GID, USERID ) VALUES ( 
'1', 'admin'); 
INSERT INTO QX_USER_GROUP ( GID, USERID ) VALUES ( 
'00346', '2'); 
INSERT INTO QX_USER_GROUP ( GID, USERID ) VALUES ( 
'2', '1'); 
commit;