📄 init.orasql
字号:
values('M09','类别管理','M0','1','','','09');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M0901','类别管理','M09','2','/ClsMngOperatorAction.do?operatorFlag=1','/agt/public/images/pzgl_pzfy.gif','09');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M10','配置管理','M0','1','','','10');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1001','配置服务器','M10','2','/agt/sysconfig/ModifyApp.jsp','/agt/public/images/xxjh_wxfjh.gif','10');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1002','知识库配置','M10','2','/agt/sysconfig/ModifyKBS.jsp','/agt/public/images/ksgl_ks_spx.gif','10');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1003','配置分页','M10','2','/agt/sysconfig/ModifyPage.jsp','/agt/public/images/zxks_ksrwlb.gif','10');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M11','课程管理','M0','1','','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1101','课程资料','M11','2','/agt/mertmng/MertMngUp.jsp','/agt/public/images/xxjh_bfkjh.gif','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110101','资料上传','M1101','3','/agt/mertmng/MertMngUp.jsp','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110102','按类别查询','M1101','3','/agt/public/jsp/QueryByClass.jsp?classID=05&pagePath=/MertMngOperatorAction.do?operatorFlag=12','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110103','按条件查询','M1101','3','/agt/mertmng/MertMngSearch.jsp','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1102','课程','M11','2','','/agt/public/images/zlgl_zlsc.gif','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110201','课程添加','M1102','3','/agt/lessonmng/LessonAdd.jsp','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110202','草稿箱','M1102','3','/LessonOperatorAction.do?operatorFlag=12&state=0','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110203','审查箱','M1102','3','/LessonOperatorAction.do?operatorFlag=11&state=1','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110204','审批箱','M1102','3','/LessonOperatorAction.do?operatorFlag=10&state=3','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110205','发布课程列表','M1102','3','/LessonOperatorAction.do?operatorFlag=20','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110206','按类别查询','M1102','3','/agt/public/jsp/QueryByClass.jsp?classID=05&pagePath=/LessonOperatorAction.do?operatorFlag=21','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M110207','按条件查询','M1102','3','/agt/lessonmng/LessonSearch.jsp','','11');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M12','日程管理','M0','1','','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1201','日程制定','M12','2','/agt/schedule/scheduleAdd.jsp','/agt/public/images/zlgl_cgx.gif','12');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1202','日程查询','M12','2','/agt/schedule/scheduleSearch.jsp','/agt/public/images/ksgl_cl_cxcl.gif','12');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1203','我的日程','M12','2','/ScheduleOperatorAction.do?operatorFlag=8','/agt/public/images/xxjh_dqzrrjh.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M13','课程学习','M0','1','','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1301','按类别查询资料','M13','2','/agt/public/jsp/QueryByClass.jsp?classID=05&pagePath=/MertMngOperatorAction.do?operatorFlag=12','/agt/public/images/zlgl_kccx.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1302','按条件查询资料','M13','2','/agt/mertmng/MertMngSearch.jsp','/agt/public/images/xxjh_jhcx.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1303','发布课程列表','M13','2','/LessonOperatorAction.do?operatorFlag=20','/agt/public/images/ksgl_ks_scx.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1304','按类别查询课程','M13','2','/agt/public/jsp/QueryByClass.jsp?classID=05&pagePath=/LessonOperatorAction.do?operatorFlag=21','/agt/public/images/pzgl_pzfy.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1315','按条件查询课程','M13','2','/agt/lessonmng/LessonSearch.jsp','/agt/public/images/ksgl_ks_fbkslb.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M14','在线考试','M0','1','','','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1401','考试任务列表','M14','2','/OnlineExam.do?opeType=2','/agt/public/images/pykj_djlb.gif','00');
insert into t_AGT_Menu(MenuID,MenuName,ParentMenuID,MenuLevel,Url,Icon,AuthID)
values('M1402','按类别查找','M14','2','/agt/public/jsp/QueryByClass.jsp?classID=04&pagePath=/OnlineExam.do?opeType=1','/agt/public/images/ksgl_sj_lbcx.gif','00');
---模块数据 moduleID需要确定----------
insert into t_Pm_Module(ModuleID,ModuleName,TableName) values('50','业务代表管理','t_AGT_Auth');
--------角色 由后台实现,测试数据---------
insert into t_Pm_Role(RoleID,RoleName,Description) values('01','答案管理员','答案管理员');
insert into t_Pm_Role(RoleID,RoleName,Description) values('02','课程考试管理员','课程考试管理员');
insert into t_Pm_Role(RoleID,RoleName,Description) values('03','业务管理员','业务管理员');
insert into t_Pm_Role(RoleID,RoleName,Description) values('04','评卷教师','评卷教师');
insert into t_Pm_Role(RoleID,RoleName,Description) values('05','系统管理员','系统管理员');
-------角色具有的权限 由后台实现,测试数据---------
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('01','50','01');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('01','50','02');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('01','50','03');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('02','50','06');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('02','50','07');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('02','50','09');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('02','50','10');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('03','50','04');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('03','50','05');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('03','50','11');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('04','50','08');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','01');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','02');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','03');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','04');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','05');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','06');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','07');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','08');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','09');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','10');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','11');
insert into t_Pm_RoleAuth(RoleID,ModuleID,AuthID) values('05','50','12');
--------员工角色 由后台实现,测试数据---------
insert into t_Pm_StaffRole(StaffNo,RoleID) values('1','01');
insert into t_Pm_StaffRole(StaffNo,RoleID) values('2','02');
insert into t_Pm_StaffRole(StaffNo,RoleID) values('3','03');
insert into t_Pm_StaffRole(StaffNo,RoleID) values('4','04');
insert into t_Pm_StaffRole(StaffNo,RoleID) values('5','05');
commit;
----------------测试数据----------------------
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('01','试题类别','说明','00');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0101','试题类别-1','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0102','试题类别-2','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0103','试题类别-3','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0104','试题类别-4','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0105','试题类别-5','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0106','试题类别-6','说明','01');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0201','课程类别-1','说明','02');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0202','课程类别-2','说明','02');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0203','课程类别-3','说明','02');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0301','试卷类别-1','说明','03');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0302','试卷类别-2','说明','03');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0303','试卷类别-3','说明','03');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0401','考试类别-1','说明','04');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0402','考试类别-2','说明','04');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0403','考试类别-3','说明','04');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('040201','考试类别-21','说明','0402');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('040301','考试类别-31','说明','0403');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0501','资料类别-1','说明','05');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0502','资料类别-2','说明','05');
insert into t_AGT_TESTCLASS(CLASSID,CLASSTITLE,CLASSContent,FCLASSID) values('0503','资料类别-3','说明','05');
----------------测试数据----------------------
commit;
--------一期中的表-------测试数据--------------
create table t_Pm_CityAuth
(
StaffNo VARCHAR2(10), --员工工号
CityID VARCHAR2(2) --地市编号
);
insert into t_Pm_CityAuth(StaffNo,CityID) values ('1','01');
insert into t_Pm_CityAuth(StaffNo,CityID) values ('2','02');
insert into t_Pm_CityAuth(StaffNo,CityID) values ('3','03');
insert into t_Pm_CityAuth(StaffNo,CityID) values ('4','04');
insert into t_Pm_CityAuth(StaffNo,CityID) values ('5','05');
insert into t_Pm_CityAuth(StaffNo,CityID) values ('0','00');
------------------------------⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -