教務(wù)查詢系統(tǒng)

簡介這個項目是一個簡單的教務(wù)查詢系統(tǒng)，該練手小項目希望能幫助到大家，熟悉SSM的整合開發(fā)使用技術(shù)IOC容器：SpringWeb框架：SpringMVCORM框架：Mybatis安全框架：Shiro數(shù)據(jù)源：C3P0日志：log4j前端框架：Bootstrap快速上手1、運行環(huán)境和所需工具 編譯器：eclipse 項目構(gòu)建工具：Maven 數(shù)據(jù)庫：Mysql JDK版本：jdk1.8 Tomcat版本：Tomcat8.x初始化項目 在你的Mysql中，創(chuàng)建一個數(shù)據(jù)庫名稱為 examination_system 的數(shù)據(jù)庫，并導(dǎo)入我提供的 .sql 文件, 進入src/main/resources修改perties配置文件,把數(shù)據(jù)庫登錄名和密碼，改為你本地的 使用 eclipse 導(dǎo)入項目，選擇Maven項目選項，一路點擊next就行，導(dǎo)入項目后，如果src目錄等，都沒顯示出來，別急先使用Maven構(gòu)建該項目 在 eclipse 中，配置我們的 Tomcat， 然后把使用Maven構(gòu)建好的項目添加到Tomcat中 運行登錄賬戶 管理員賬戶：admin 老師賬戶：1001 學(xué)生賬戶：10001 密碼均為：123功能模塊介紹1、登錄模塊功能使用Shiro權(quán)限管理框架，實現(xiàn)登錄驗證和登錄信息的儲存，根據(jù)不同的登錄賬戶，分發(fā)權(quán)限角色，對不同頁面url進行角色設(shè)置用戶、角色、菜單、用戶與角色關(guān)系、角色與菜單的關(guān)系用戶：用戶ID、用戶名、密碼、角色角色：角色ID、角色名、權(quán)限教師：ID、姓名、性別、出生日期、學(xué)歷、職稱、入職時間、院系學(xué)生：ID、姓名、性別、出生日期、入學(xué)時間、院系院系：ID、院系名稱課程：ID、課程名稱、開課老師、開課時間、開課地點、學(xué)時、課程類型、所屬院系、學(xué)分CREATE TABLE userlogin ( userID int(11) NOT NULL AUTO_INCREMENT, userName varchar(200) NOT NULL, password varchar(200) NOT NULL, role int(11) NOT NULL DEFAULT 2 COMMENT 角色權(quán)限, PRIMARY KEY (userID), KEY role (role), CONSTRAINT userlogin_ibfk_1 FOREIGN KEY (role) REFERENCES role (roleID) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;InnoDB 是MySQL的數(shù)據(jù)庫引擎之一，是一套放在 MySQL 后臺的完整數(shù)據(jù)庫系統(tǒng)AUTO_INCREMENT=1 自增鍵的起始序號為17DEFAULT CHARSET=utf8 數(shù)據(jù)庫默認編碼為utf-8- - Records of userlogin- -INSERT INTO userlogin VALUES (1, admin, 123, 0);INSERT INTO userlogin VALUES (8, 10001, 123, 2);INSERT INTO userlogin VALUES (9, 10002, 123, 2);INSERT INTO userlogin VALUES (10, 10003, 123, 2);INSERT INTO userlogin VALUES (11, 10005, 123, 2);INSERT INTO userlogin VALUES (12, 10004, 123, 2);INSERT INTO userlogin VALUES (13, 10006, 123, 2);INSERT INTO userlogin VALUES (14, 1001, 123, 1);INSERT INTO userlogin VALUES (15, 1002, 123, 1);INSERT INTO userlogin VALUES (16, 1003, 123, 1);CREATE TABLE role ( roleID int(11) NOT NULL, roleName varchar(20) NOT NULL, permissions varchar(255) DEFAULT NULL COMMENT 權(quán)限, PRIMARY KEY (roleID) ENGINE=InnoDB DEFAULT CHARSET=utf8;- - Records of role- -INSERT INTO role VALUES (0, admin, null);INSERT INTO role VALUES (1, teacher, null);INSERT INTO role VALUES (2, student, null);CREATE TABLE teacher ( userID int(11) NOT NULL AUTO_INCREMENT, userName varchar(200) NOT NULL, sex varchar(20) DEFAULT NULL, birthYear date NOT NULL, degree varchar(20) DEFAULT NULL COMMENT 學(xué)歷, title varchar(255) DEFAULT NULL COMMENT 職稱, grade date DEFAULT NULL COMMENT 入職時間, collegeID int(11) NOT NULL COMMENT 院系, PRIMARY KEY (userID), KEY collegeID (collegeID), CONSTRAINT teacher_ibfk_1 FOREIGN KEY (collegeID) REFERENCES college (collegeID) ENGINE=InnoDB AUTO_INCREMENT=1004 DEFAULT CHARSET=utf8;- - Records of teacher- -INSERT INTO teacher VALUES (1001, 劉老師, 女, 1990-03-08, 碩士, 副教授, 2015-09-02, 2);INSERT INTO teacher VALUES (1002, 張老師, 男, 1996-09-02, 本科, 普通教師, 2015-09-02, 1);INSERT INTO teacher VALUES (1003, 軟老師, 男, 1996-09-02, 碩士, 助教, 2017-07-07, 1);CREATE TABLE student ( userID int(11) NOT NULL AUTO_INCREMENT, userName varchar(200) NOT NULL, sex varchar(20) DEFAULT NULL, birthYear date DEFAULT NULL COMMENT 出生日期, grade date DEFAULT NULL COMMENT 入學(xué)時間, collegeID int(11) NOT NULL COMMENT 院系id, PRIMARY KEY (userID), KEY collegeID (collegeID), CONSTRAINT student_ibfk_1 FOREIGN KEY (collegeID) REFERENCES college (collegeID) ENGINE=InnoDB AUTO_INCREMENT=10007 DEFAULT CHARSET=utf8;- - Records of student- -INSERT INTO student VALUES (10001, 小黃, 男, 1996-09-02, 2015-09-02, 1);INSERT INTO student VALUES (10002, 小米, 女, 1995-09-14, 2015-09-02, 3);INSERT INTO student VALUES (10003, 小陳, 女, 1996-09-02, 2015-09-02, 2);INSERT INTO student VALUES (10004, 小華, 男, 1996-09-02, 2015-09-02, 2);INSERT INTO student VALUES (10005, 小左, 女, 1996-09-02, 2015-09-02, 2);INSERT INTO student VALUES (10006, 小拉, 女, 1996-09-02, 2015-09-02, 1);CREATE TABLE college ( collegeID int(11) NOT NULL, collegeName varchar(200) NOT NULL COMMENT 院系名稱, PRIMARY KEY (collegeID) ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO college VALUES (1, 計算機系);INSERT INTO college VALUES (2, 設(shè)計系);INSERT INTO college VALUES (3, 財經(jīng)系);CREATE TABLE course ( courseID int(11) NOT NULL, courseName varchar(200) NOT NULL COMMENT 課程名稱, teacherID int(11) NOT NULL, courseTime varchar(200) DEFAULT NULL COMMENT 開課時間, classRoom varchar(200) DEFAULT NULL COMMENT 開課地點, courseWeek int(200) DEFAULT NULL COMMENT 學(xué)時, courseType varchar(20) DEFAULT NULL COMMENT 課程類型, collegeID int(11) NOT NULL COMMENT 所屬院系, score int(11) NOT NULL COMMENT 學(xué)分, PRIMARY KEY (courseID), KEY collegeID (collegeID), KEY teacherID (teacherID), CONSTRAINT course_ibfk_1 FOREIGN KEY (collegeID) REFERENCES college (collegeID), CONSTRAINT course_ibfk_2 FOREIGN KEY (teacherID) REFERENCES teacher (userID) ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO course VALUES (1, C語言程序設(shè)計, 1001, 周二, 科401, 18, 必修課, 1, 3);INSERT INTO course VALUES (2, Python爬蟲技巧, 1001, 周四, X402, 18, 必修課, 1, 3);INSERT INTO course VALUES (3, 數(shù)據(jù)結(jié)構(gòu), 1001, 周四, 科401, 18, 必修課, 1, 2);INSERT INTO course VALUES (4, Java程序設(shè)計, 1002, 周五, 科401, 18, 必修課, 1, 2);INSERT INTO course VALUES (5, 英語, 1002, 周四, X302, 18, 必修課, 2, 2);INSERT INTO course VALUES (6, 服裝設(shè)計, 1003, 周一, 科401, 18, 選修課, 2, 2);CREATE TABLE selectedcourse ( courseID int(11) NOT NULL, studentID int(11) NOT NULL, mark int(11) DEFAULT NULL COMMENT 成績, KEY courseID (courseID), KEY studentID (studentID), CONSTRAINT selectedcourse_ibfk_1 FOREIGN KEY (courseID) REFERENCES course (courseID), CONSTRAINT selectedcourse_ibfk_2 FOREIGN KEY (studentID) REFERENCES student (userID) ENGINE=InnoDB DEFAULT CHARSET=utf8;- - Records of selectedcourse- -INSERT INTO selectedcourse VALUES (2, 10001, 12);INSERT INTO selectedcourse VALUES (1, 10001,