附加信息：以下有关程序数据库表的创建，是不是我建的数据库表有什么问题啊！ create table ACTION(ACTION_ID varchar(3) not null primary key, TITLE varchar(100) not null,PATH varchar(100) not null,PARAMETTER varchar(100) not null);
create table class(CLASS_ID varchar(8) not null primary key,TITLE varchar(30) not null);
create table FUNCTIONS(FUNCTION_ID varchar(3) not null primary key,NAME varchar(50) not null, TITLE varchar(50) not null);
create table ROLES(ROLE_ID varchar(3) not null primary key,NAME varchar(50) not null,TITLE varchar(50) not null);
create table TEACHER_CLASS(TEACHER_ID varchar(8) not null,CLASS_ID varchar(8) not null);
create table SELECTED(QUESTION_ID varchar(5) not null,CONTENT varchar(200) not null,ITEM varchar(200) not null);
create table FUNCTION_ACTION(function_id varchar(3) not null,action_id varchar(3) not null);
create table ROLE_FUNCTION(role_id varchar(3) not null,function_id varchar(3) not null);
create table SELECT_QUESTION(PAPER_ID varchar(3) not null,QUESTION_ID varchar(5) not null primary key,TITLE varchar(200) not null,ANSWER varchar(2) not null, SCORE int not null);
create table STUDENT(NAME varchar(20) not null,PASSWORD varchar(20) not null,FULLNAME varchar(20) not null,CLASS_ID varchar(8) not null);
create table TEACHER(TEACHER_ID varchar(8) not null primary key,NAME varchar(20) not null,PASSWORD varchar(20) not null,FULLNAME varchar(20) not null);
create table TEST_PAPER(PAPER_ID varchar(3) not null primary key,TITLE varchar(200) not null, EXAM_TIME int not null);
create table USERINFO(NAME varchar(20) not null,PASSWORD varchar(20) not null,FULLNAME varchar(20) not null);
create table YESNO_QUESTION(TITLE varchar(200) not null,ANSWER varchar(4) not null, SCORE int not null,PAPER_ID varchar(3) not null);
// 得到用户的角色信息 Cache cache = CacheFactory.getCache(); Role role = (Role) cache.get(u.getUserType()); if (role == null) { throw new ExamSystemException("Couldn't find the role!"); }
// 进行用户执行功能的判断 Set <Function> functions = role.getFunctions(); for (Function function : functions) { Set <Action> actions = function.getActions(); for (Action action : actions) { if (path.equals(action.getPath()) && method.equals(action.getParameter())) { request.setAttribute(StrutsConstants.REQUEST_CHECK_FLAG, true); return true; } } }
