Author homepage: Ye Weiyang 5788
Introduction: High-quality creators in the Java field, Java projects, learning materials, technical mutual assistance
Get the source code at the end of the article
Project Introduction
The administrator role includes the following functions:
Administrator login, administrator management, announcement information management, student management, teacher management, teaching material management, teaching material delivery management, teaching material storage management, teaching material order management, class query, teaching material order statistics and other functions.
The teacher role includes the following functions:
Teacher role home page, teacher role login, view textbook details, textbook order, view announcement information, view submitted textbook orders, etc.
A student role contains the following functions:
Student role home page, view textbook details, order textbooks, view announcement information, view submitted textbook orders, log in student role, modify personal information, etc.
Due to the small scale of this program, it can be used for course design and graduation design learning demonstration
environmental needs
1. Operating environment: preferably java jdk 1.8, we run on this platform. Other versions are also theoretically possible.
2.IDE environment: IDEA, Eclipse,Myeclipse are all available. Recommend IDEA;
3.tomcat environment: Tomcat 7.x,8.x,9.x versions are available
4. Hardware environment: Windows 7/8/10 with 1G memory or more; or Mac OS;
5. Database: MySql 5.7 version;
technology stack
HTML+CSS+JavaScript+jsp+mysql
Instructions for use
1. Use Navicat or other tools to create a database with the corresponding name in mysql, and import the sql file of the project;
2. Use IDEA/Eclipse/MyEclipse to import the project. When importing Eclipse/MyEclipse, if it is a maven project, please select maven; if it is a maven project, please execute the maven clean;maven install command after the import is successful, and then run;
3. Change the database configuration in the application.yml configuration file in the project to your own configuration;
4. Run the project, enter localhost:8080/login.jsp to log in
run screenshot
related code
class management controller
@Controller @RequestMapping("/class") public class ClassController { @Autowired private ClassLeaderServer classLeaderServer = null; @Autowired private ManagerServer managerServer=null; @RequestMapping("/index") public String showPage() { return "class/classIndex"; } @RequestMapping("/welcome") public String welcome(HttpServletRequest request) { return "managers/welcome"; } @RequestMapping("/changeinfo") public String changeinfo() { return "class/changeinfo"; } //Already distributed list @RequestMapping("/grantlist") public String grantList(HttpServletRequest request) { User user = (User) request.getSession().getAttribute("session"); List<Order> orders = classLeaderServer.selectAllPassOrder(user.getUsername()); request.setAttribute("books", orders); return "teacher/grantlist"; } //Modification of monitor information @RequestMapping("/classleaderinfo") public String changeClassLeaderInfo(HttpServletRequest request, @RequestParam(required = false) String username , @RequestParam(required = false) String classid, @RequestParam(required = false) String department, @RequestParam(required = false) String email, @RequestParam(required = false) Integer po) { User user = (User) request.getSession().getAttribute("session"); request.setAttribute("username", user.getUsername()); if (po != null && po == 1) { managerServer.updateClassLeaderInfo(user.getUsername(), classid, department, email); request.setAttribute("message", "update completed!"); } return "class/changeinfo"; } }
management controller
@Controller @RequestMapping("/managers") public class ManagerController { @Autowired private ManagerServer managerServer = null; //Admin Home @RequestMapping("/index") public String showPage(HttpServletRequest request) { return "managers/managerIndex"; } //Order Home @RequestMapping("/order-list") public String show1(HttpServletRequest request) { List<Order> orders = managerServer.selectAllOrder(); request.setAttribute("orders", orders); return "managers/order-list"; } //teacher list @RequestMapping("/teacherlist") public String show2(HttpServletRequest request) { List<Teacher> teachers = managerServer.getAllTeacher(); request.setAttribute("teachers", teachers); return "managers/teacherlist"; } //monitor list @RequestMapping("/class-list") public String classLeaderList(HttpServletRequest request) { List<ClassLeader> classLeaders = managerServer.getAllClassLeader(); request.setAttribute("classLeader", classLeaders); return "managers/classlist"; } //change Password @RequestMapping(value = "/changepassword", method = RequestMethod.POST) public String changePassword(HttpServletRequest request) throws UnsupportedEncodingException { request.setCharacterEncoding("UTF-8"); String oldpassword = request.getParameterValues("oldpass")[0]; String newPass = request.getParameterValues("newpass")[0]; String newPass1 = request.getParameterValues("repass")[0]; String username = request.getParameterValues("username")[0]; String kind = request.getParameterValues("kind")[0]; boolean flag = managerServer.checkDataAndUpdate(username, oldpassword, newPass, newPass1, kind); if (flag) request.setAttribute("message", "Successfully modified"); else request.setAttribute("message", "fail to edit,Please check"); return "managers/member-password"; } //modify data @RequestMapping("member-edit") public String editPage(HttpServletRequest request) { return "managers/member-edit"; } //Change teacher password @RequestMapping("member-password") public String editPasswordPage(HttpServletRequest request, @RequestParam String username) { request.setAttribute("username", username); return "managers/member-password"; } //delete users @RequestMapping(value = "/delete", method = RequestMethod.POST) public void delete(HttpServletRequest request, @RequestParam String id, @RequestParam String kind) { if (id != null) { managerServer.delete(id, kind); } } //Modify monitor password @RequestMapping(value = "member-password2") public String editPasswordPage2(HttpServletRequest request, @RequestParam String username) { request.setAttribute("username", username); return "managers/member-password2"; } @RequestMapping("/welcome") public String show3(HttpServletRequest request) { return "managers/welcome"; } //Approve order @RequestMapping("/approval") public void approval(HttpServletRequest request, @RequestParam int id, @RequestParam int state, @RequestParam int num) { managerServer.approval(id, state); if (state == 1) { managerServer.deduction(id, num); } } //List to be released @RequestMapping("/wait-list") public String waitPage(HttpServletRequest request) { List<GrantBooks> grantBooks = managerServer.getBooks(); request.setAttribute("grant", grantBooks); return "managers/wait-list"; } //get book list @RequestMapping("/books") public String books(HttpServletRequest request) { List<Book> books = managerServer.books(); request.setAttribute("books", books); return "managers/books"; } //increase book inventory @RequestMapping(value = "/addbook") public String addBook(HttpServletRequest request, String place, String time) { if (place != null && time != null) { } return "managers/addbook"; } //POST submission to change number of books @RequestMapping("/changebooknum") public String changeBookNum(HttpServletRequest request, @RequestParam int id, @RequestParam int num) { managerServer.changeBookNum(id, num); return "managers/changebooknum"; } //get edit book page @RequestMapping("/getchangenumPage") public String getChangePage(HttpServletRequest request, int id) { request.setAttribute("id", id); return "managers/changebooknum"; } //add new book @RequestMapping("/addnewbook") public String addNewBook(@RequestParam(value = "bookname", required = false) String bookName, @RequestParam(value = "booknum", required = false) Integer bookNum, @RequestParam(value = "press", required = false) String press, @RequestParam(value = "price", required = false) Double price) { if (bookName != null) { managerServer.addNewBook(bookName, bookNum, press, price); } return "managers/addnewbook"; } //Modification of monitor information @RequestMapping("/classleaderinfo") public String changeClassLeaderInfo(HttpServletRequest request, @RequestParam(required = false) String username , @RequestParam(required = false) String classid, @RequestParam(required = false) String department, @RequestParam(required = false) String email, @RequestParam(required = false) Integer po) { if (classid != null) { request.setAttribute("username", username); request.setAttribute("classid", classid); request.setAttribute("department", department); request.setAttribute("email", email); } if (po != null && po == 1) { managerServer.updateClassLeaderInfo(username, classid, department, email); request.setAttribute("message", "update completed!"); } return "managers/classleaderinfo"; } //distribute books @RequestMapping("/sendbook") public String sendBook(HttpServletRequest request, @RequestParam Integer id, @RequestParam(required = false) String time, @RequestParam(required = false) String place) { if (id != null) { request.setAttribute("id", id); } if (time != null) { managerServer.sendBook(id, time, place); request.setAttribute("message", "ok"); } return "managers/sendbook"; } //Already distributed list @RequestMapping("/grantlist") public String grantList(HttpServletRequest request) { List<Order> orders = managerServer.selectAllPassOrder(); request.setAttribute("books", orders); return "managers/grantlist"; } //Teacher information modification @RequestMapping("/teacherinfo") public String changeTeacherInfo(HttpServletRequest request, @RequestParam(required = false) String username , @RequestParam(required = false) String classid, @RequestParam(required = false) String department, @RequestParam(required = false) Integer po, @RequestParam(required = false) String email) { if (classid != null) { request.setAttribute("username", username); request.setAttribute("classid", classid); request.setAttribute("department", department); request.setAttribute("email", email); } if (po != null && po == 1) { managerServer.updateTeacherInfo(username, department, email); String[] cs = classid.split("\\,"); System.out.println(cs); int userId=managerServer.selectTeacherId(username); managerServer.deleteClass(userId); for (int i = 0; i < cs.length; i++) { managerServer.updateClasses(userId,cs[i]); } request.setAttribute("message", "update completed!"); } return "managers/teacherinfo"; } }
Teacher Management Controller
@Controller @RequestMapping("/teacher") public class TeacherController { @Autowired private TeacherServer teacherServer = null; @Autowired private ManagerController managerController = null; @Autowired private ManagerServer managerServer = null; @RequestMapping("/index") public String showPage() { return "teacher/teacherIndex"; } //monitor list @RequestMapping("/class-list") public String classLeaderList(HttpServletRequest request) { User user = (User) request.getSession().getAttribute("session"); List<ClassLeader> classLeaders = teacherServer.getAllClassLeader(managerServer.selectTeacherId(user.getUsername())); request.setAttribute("classLeader", classLeaders); return "teacher/classlist"; } @RequestMapping(value = "/changepassword", method = RequestMethod.POST) public String changePassword(HttpServletRequest request) throws UnsupportedEncodingException { return managerController.changePassword(request); } //modify data @RequestMapping("member-edit") public String editPage(HttpServletRequest request) { return managerController.editPage(request); } //delete users @RequestMapping(value = "/delete", method = RequestMethod.POST) public void deleteTeacher(HttpServletRequest request, @RequestParam String id, @RequestParam String kind) { if (id != null) { managerServer.delete(id, kind); } } //Modify monitor password @RequestMapping(value = "member-password2") public String editPasswordPage2(HttpServletRequest request, @RequestParam String username) { request.setAttribute("username", username); return "teacher/member-password2"; } //Modification of monitor information @RequestMapping("/classleaderinfo") public String changeClassLeaderInfo(HttpServletRequest request, @RequestParam(required = false) String username , @RequestParam(required = false) String classid, @RequestParam(required = false) String department, @RequestParam(required = false) String email, @RequestParam(required = false) Integer po) { if (classid != null) { request.setAttribute("username", username); request.setAttribute("classid", classid); request.setAttribute("department", department); request.setAttribute("email", email); } if (po != null && po == 1) { managerServer.updateClassLeaderInfo(username, classid, department, email); request.setAttribute("message", "update completed!"); } return "teacher/classleaderinfo"; } //Teacher information modification @RequestMapping("/changeinfo") public String changeTeacherInfo(HttpServletRequest request, @RequestParam(required = false) String username , @RequestParam(required = false) String classid, @RequestParam(required = false) String department, @RequestParam(required = false) Integer po, @RequestParam(required = false) String email) { if (classid != null) { request.setAttribute("username", username); request.setAttribute("classid", classid); request.setAttribute("department", department); request.setAttribute("email", email); } if (po != null && po == 1) { managerServer.updateTeacherInfo(username, department, email); String[] cs = classid.split("\\,"); System.out.println(cs); int userId = managerServer.selectTeacherId(username); managerServer.deleteClass(userId); for (int i = 0; i < cs.length; i++) { managerServer.updateClasses(userId, cs[i]); } request.setAttribute("message", "update completed!"); } return "teacher/changeinfo"; } //Order page, only the teacher's own @RequestMapping("/order-list") public String show1(HttpServletRequest request) { User user = (User) request.getSession().getAttribute("session"); List<Order> orders = teacherServer.selectAllOrder(user.getUsername()); request.setAttribute("orders", orders); return "teacher/order-list"; } //get book list @RequestMapping("/books") public String books(HttpServletRequest request) { List<Book> books = teacherServer.books(); request.setAttribute("books", books); return "teacher/books"; } //Already distributed list @RequestMapping("/grantlist") public String grantList(HttpServletRequest request) { User user = (User) request.getSession().getAttribute("session"); List<Order> orders = teacherServer.selectAllPassOrder(user.getUsername()); request.setAttribute("books", orders); return "teacher/grantlist"; } @RequestMapping("/addneworder") public String getAddPage(HttpServletRequest request) { List<Book> books = teacherServer.books(); request.setAttribute("books", books); return "teacher/addneworder"; } @RequestMapping("/addneworders") public String insertToDB(HttpServletRequest request, int bookid, int booknum, int classid) { User user = (User) request.getSession().getAttribute("session"); int teacherId = managerServer.selectTeacherId(user.getUsername()); teacherServer.insertOrder(teacherId, bookid, booknum, classid); return "teacher/addneworder"; } @RequestMapping("/welcome") public String show3(HttpServletRequest request) { return "managers/welcome"; } }
If you also want to learn this system, get it below. Follow and reply: 075jsp