基于ssm框架的JavaWeb学生成绩/信息管理系统小明日记

基于ssm框架的JavaWeb学生成绩/信息管理系统

基于ssm框架开发的，使用Eclipse，连接MySQL数据库，存储学生的身份信息、成绩、课程信息，管理员的身份信息。

部分效果图在最下面。

在项目的src目录下创建log4j.properties文件

jdbc.driver=com.mysql.cj.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/studentinfoserverTimezone=UTCjdbc.username=rootjdbc.password=123456jdbc.maxTotal=30jdbc.maxIdle=10jdbc.initialSize=5在src目录下，创建Spring的配置文件applicationContext.xml

contextConfigLocationclasspath:applicationContext.xmlorg.springframework.web.context.ContextLoaderListenerspringmvcorg.springframework.web.servlet.DispatcherServletcontextConfigLocationclasspath:springmvc-config.xmlspringmvc/创建pojo包在src目录下，创建一个com.chen.pojo包，在该包下创建持久化类User、Student、Score、Course

LoginMapper.java

packagecom.chen.dao;importcom.chen.pojo.Student;importcom.chen.pojo.User;publicinterfaceLoginMapper{publicUserfindUserByName(Stringname);publicStudentfindUserById(StringstudentId);}LoginMapper.xml

packagecom.chen.dao;importjava.util.HashMap;importjava.util.List;importorg.apache.ibatis.annotations.Param;importcom.chen.pojo.Student;publicinterfaceStudentMapper{//添加学生publicintaddStudentInfo(Studentstudent);//更新学生publicintupdateStudentInfo(Studentstudent);//获取要修改的学生信息publicStudentqueryStudentById(Stringid);//删除学生publicintdeleteStudentInfoById(@Param("studentId")Stringid);//查询学生publicListfindByPage(HashMapmap);//查询总条数intselectCount(@Param("studentId")Stringid);//重置学生密码publicintrestStudent(@Param("studentId")Stringid);//更新密码publicintchangePwd(@Param("studentId")StringstudentId,@Param("newPass")StringnewPass);}StudentMapper.xml

packagecom.chen.dao;importjava.util.HashMap;importjava.util.List;importorg.apache.ibatis.annotations.Param;importcom.chen.pojo.Score;publicinterfaceScoreMapper{//获取要更新成绩的信息publicScorequeryScoreById(Scorescore);//查询成绩ListfindByPage(HashMapmap);//添加成绩publicintaddScoreInfo(Scorescore);//更新成绩publicintupdateScoreInfo(Scorescore);//删除成绩publicintdeleteScoreInfoById(Stringid);//获取总条数publicintselectCount(@Param("id")Stringid);}ScoreMapper.xml

packagecom.chen.dao;importjava.util.HashMap;importjava.util.List;importorg.apache.ibatis.annotations.Param;importcom.chen.pojo.Course;publicinterfaceCourseMapper{//获取要更新课程的信息publicCoursequeryCourseById(@Param("courseId")Stringid);//添加课程publicintaddCourseInfo(Coursecourse);//更新课程publicintupdateCourseInfo(Coursecourse);//删除课程publicintdeleteCourseInfoById(@Param("courseId")Stringid);//查询课程publicListfindByPage(HashMapmap);//查询总条数publicintselectCount(@Param("courseId")Stringid);//通过学号查询课程publicListquery(HashMapmap);//查询总条数publicintselectcount(Stringid);//查询课程publicCoursequery1(Stringid);}CourseMapper.xml

LoginService.java

packagecom.chen.service;importcom.chen.pojo.Student;publicinterfaceLoginService{booleanlogin(Stringname,Stringpassword);booleanstudentlogin(Stringname,Stringpassword);publicStudentqueryStudentById(StringloginUser);publicintupdateStudentPad(Stringid,StringnewPad);}LoginServiceImpl.java

packagecom.chen.service;importcom.chen.pojo.Student;importcom.chen.untils.PageBean;publicinterfaceStudentService{publicintaddStudentInfo(Studentstudent);publicintupdateStudentInfo(Studentstudent);publicStudentqueryStudetnById(Stringid);publicintdeleteStudentInfoById(Stringid);publicPageBeanfindByPage(intcurrentPage,Stringid);publicintrestStudent(Stringid);}StudentServiceImpl.java

packagecom.chen.service;importcom.chen.pojo.Score;importcom.chen.untils.PageBean;publicinterfaceScoreService{publicScorequeryScoreById(Scorescore);publicPageBeanfindByPage(intcurrentPage,Stringid);publicintaddScoreInfo(Scorescore);publicintupdateScoreInfo(Scorescore);publicintdeleteScoreInfoById(Stringid);}ScoreServiceImpl.java

packagecom.chen.service;importorg.apache.ibatis.annotations.Param;importcom.chen.pojo.Course;importcom.chen.untils.PageBean;publicinterfaceCourseService{//获取要修改的课程信息publicCoursequeryCourseById(Stringid);//查询课程publicPageBeanfindByPage(intcurrentPage,Stringid);//添加课程publicintaddCourseInfo(Coursecourse);//更新课程publicintupdateCourseInfo(Coursecourse);//删除课程publicintdeleteCourseInfoById(@Param("courseId")Stringid);publicPageBeanquery(intcurrentPage,Stringid);publicCoursequery1(Stringid);}CourseServiceImpl.java

LoginController.java

packagecom.chen.untils;importjava.util.List;publicclassPageBean{privateintcurrPage;//当前页数privateintpageSize;//每页显示的记录数privateinttotalCount;//总记录数privateinttotalPage;//总页数privateStringid;privateListlists;//每页的显示的数据publicPageBean(){super();}publicintgetCurrPage(){returncurrPage;}publicvoidsetCurrPage(intcurrPage){this.currPage=currPage;}publicintgetPageSize(){returnpageSize;}publicvoidsetPageSize(intpageSize){this.pageSize=pageSize;}publicintgetTotalCount(){returntotalCount;}publicvoidsetTotalCount(inttotalCount){this.totalCount=totalCount;}publicintgetTotalPage(){returntotalPage;}publicvoidsetTotalPage(inttotalPage){this.totalPage=totalPage;}publicListgetLists(){returnlists;}publicvoidsetLists(Listlists){this.lists=lists;}publicStringgetId(){returnid;}publicvoidsetId(Stringid){this.id=id;}}三、前端jsp页面编码在WebContent目录下，创建名为jsp的文件夹，然后在文件中创建如下页面。

刚拿到选题的时候，自己还是有蛮多想法的，但是在一步步实践中放弃了，因为自己学到的技术有限，还不足以让我能做出一个功能很丰富的系统，这恰好是我学习的动力，争取下次做出一个功能完整的系统。