作者主页:夜未央5788
简介:Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
这个项目是一个基于Struts2+Spring+Hibernate高校宿舍管理系统,分为管理员、宿舍管理、学生三种角色。
管理员权限包括:
宿舍管理
学生管理
宿舍调换管理
水电费管理
卫生检查管理
缺寝管理
来访管理
报修管理
公告管理
宿舍管理权限包括:
公告信息管理
个人信息查询
学生信息查询
缺寝管理
来访管理
卫生检查管理
报修管理
水电费管理
学生权限包括:
学生个人信息
个人缺寝查看
水电费查询
卫生查询
报修管理
公告查询
由于本程序规模不大,可供课程设计,毕业设计学习演示之用
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可
4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
5.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
6.数据库:MySql 5.7等版本均可;
1. 后端:Spring Struts Hibernate
2. 前端:JSP+css+javascript+jQuery
1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件;
2.使用IDEA/Eclipse/MyEclipse导入项目,配置tomcat;
3. 将项目中proxool.xml配置文件中的数据库配置改为自己的配置,然后运行;
4.运行成功后,在浏览器中输入http://localhost:8080/stu_dorm/login.jsp
管理员账号密码:admin/111111
宿舍管理账号密码:003/111111
学生账号密码:2014005511/2014005511
- public class ManageAction {
- private static final long serialVersionUID = 1L;
-
- private String url="./";
-
- private BaoxiuDao baoxiuDao;
- private LaifangDao laifangDao;
- private LouDao louDao;
- private QueqinDao queqinDao;
- private ShuidianDao shuidianDao;
- private SusheDao susheDao;
- private WeishengDao weishengDao;
-
- public BaoxiuDao getBaoxiuDao() {
- return baoxiuDao;
- }
-
- public void setBaoxiuDao(BaoxiuDao baoxiuDao) {
- this.baoxiuDao = baoxiuDao;
- }
-
- public LaifangDao getLaifangDao() {
- return laifangDao;
- }
-
- public void setLaifangDao(LaifangDao laifangDao) {
- this.laifangDao = laifangDao;
- }
-
- public LouDao getLouDao() {
- return louDao;
- }
-
- public void setLouDao(LouDao louDao) {
- this.louDao = louDao;
- }
-
- public QueqinDao getQueqinDao() {
- return queqinDao;
- }
-
- public void setQueqinDao(QueqinDao queqinDao) {
- this.queqinDao = queqinDao;
- }
-
- public ShuidianDao getShuidianDao() {
- return shuidianDao;
- }
-
- public void setShuidianDao(ShuidianDao shuidianDao) {
- this.shuidianDao = shuidianDao;
- }
-
- public SusheDao getSusheDao() {
- return susheDao;
- }
-
- public void setSusheDao(SusheDao susheDao) {
- this.susheDao = susheDao;
- }
-
- public WeishengDao getWeishengDao() {
- return weishengDao;
- }
-
- public void setWeishengDao(WeishengDao weishengDao) {
- this.weishengDao = weishengDao;
- }
-
- public String getUrl() {
- return url;
- }
-
- public void setUrl(String url) {
- this.url = url;
- }
-
- private UserDao userDao;
-
- public UserDao getUserDao() {
- return userDao;
- }
-
- public void setUserDao(UserDao userDao) {
- this.userDao = userDao;
- }
-
- //用户登陆操作
- public void login() throws IOException {
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String username = request.getParameter("username");
- String password = request.getParameter("password");
- Integer role = Integer.parseInt(request.getParameter("role"));
- User user = userDao.selectBean(" where username='"+username+"' and password='"+password+"' and userlock=0 and role="+role);
- if(user!=null){
- HttpSession session = request.getSession();
- session.setAttribute("user", user);
- response.setCharacterEncoding("gbk");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('登录成功');window.location.href='index.jsp'; </script>");
- }else{
- response.setCharacterEncoding("gbk");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('用户名或者密码错误');window.location.href='login.jsp'; </script>");
- }
-
- }
-
- //用户退出操作
- public void loginout() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpSession session = request.getSession();
- session.removeAttribute("user");
- HttpServletResponse response = ServletActionContext.getResponse();
- response.setCharacterEncoding("gbk");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('退出成功');window.location.href='login.jsp'; </script>");
- }
-
- //跳转到修改密码页面
- public String passwordupdate(){
- this.setUrl("user/passwordupdate.jsp");
- return SUCCESS;
- }
-
- //修改密码操作
- public void passwordupdate2() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String password1 = request.getParameter("password1");
- String password2 = request.getParameter("password2");
- HttpSession session = request.getSession();
- User user = (User)session.getAttribute("user");
- User bean = userDao.selectBean(" where username='"+user.getUsername()+"' and password='"+password1+"' ");
- if(bean!=null){
- bean.setPassword(password2);
- userDao.updateBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('操作成功'); </script>");
- }else{
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('原密码错误,修改失败!!');window.location.href='method!passwordupdate'; </script>");
- }
- }
-
- /***************管理员功能****************/
-
- //管理员页面
- public String userlist(){
- HttpServletRequest request = ServletActionContext.getRequest();
- int currentpage = 1;
- int pagesize = 10;
- if(request.getParameter("pagenum") != null){
- currentpage = Integer.parseInt(request.getParameter("pagenum"));
- }
- String where =" where userlock=0 and role=1 order by id desc ";
- long total = userDao.selectBeanCount(where);
- List<User> list = userDao.selectBeanList(currentpage-1, pagesize, where);
- request.setAttribute("list", list);
- String pagerinfo = Pager.getPagerNormal((int)total, pagesize, currentpage, "method!userlist", "共有"+total+"条记录");
- request.setAttribute("pagerinfo", pagerinfo);
- this.setUrl("user/userlist.jsp");
- return SUCCESS;
- }
-
- //跳转到添加管理员页面
- public String useradd(){
- this.setUrl("user/useradd.jsp");
- return SUCCESS;
- }
-
- //添加管理员操作
- public void useradd2() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- response.setCharacterEncoding("utf8");
- String username = request.getParameter("username");
- String password = request.getParameter("password");
- String truename = request.getParameter("truename");
- User bean = userDao.selectBean(" where username='"+username+"' ");
- if(bean==null){
- bean = new User();
- bean.setUsername(username);
- bean.setPassword(password);
- bean.setTruename(truename);
- bean.setCreatetime(new Date());
- bean.setRole(1);
- userDao.insertBean(bean);
-
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!userlist'; </script>");
- }else{
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交失败,该用户名已经存在');window.location.href='method!userlist'; </script>");
- }
-
-
- }
-
-
-
- //删除管理员操作
- public void userdelete() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String id = request.getParameter("id");
- User bean =userDao.selectBean(" where id= "+id);
- bean.setUserlock(1);
- userDao.insertBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!userlist'; </script>");
-
- }
-
- //跳转到更新管理员页面
- public String userupdate(){
- HttpServletRequest request = ServletActionContext.getRequest();
- String id = request.getParameter("id");
- User bean =userDao.selectBean(" where id= "+id);
- request.setAttribute("bean", bean);
- this.setUrl("user/userupdate.jsp");
- return SUCCESS;
- }
-
-
- //更新管理员操作
- public void userupdate2() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String password = request.getParameter("password");
- String truename = request.getParameter("truename");
- String id = request.getParameter("id");
- User bean =userDao.selectBean(" where id= "+id);
- bean.setPassword(password);
- bean.setTruename(truename);
- userDao.insertBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!userlist'; </script>");
-
- }
-
-
- private ZhuanyeDao zhuanyeDao;
- public ZhuanyeDao getZhuanyeDao() {
- return zhuanyeDao;
- }
- public void setZhuanyeDao(ZhuanyeDao zhuanyeDao) {
- this.zhuanyeDao = zhuanyeDao;
- }
-
-
- //院系信息列表
- public String zhuanyelist(){
- HttpServletRequest request = ServletActionContext.getRequest();
- int currentpage = 1;
- int pagesize = 10;
- if(request.getParameter("pagenum") != null){
- currentpage = Integer.parseInt(request.getParameter("pagenum"));
- }
- String where =" where zhuanyelock=0 order by id desc ";
- long total = zhuanyeDao.selectBeanCount(where);
- List<Zhuanye> list = zhuanyeDao.selectBeanList(currentpage-1, pagesize, where);
- request.setAttribute("list", list);
- String pagerinfo = Pager.getPagerNormal((int)total, pagesize, currentpage, "method!zhuanyelist", "共有"+total+"条记录");
- request.setAttribute("pagerinfo", pagerinfo);
- this.setUrl("zhuanye/zhuanyelist.jsp");
- return SUCCESS;
- }
-
-
- //跳转到添加院系页面
- public String zhuanyeadd(){
- this.setUrl("zhuanye/zhuanyeadd.jsp");
- return SUCCESS;
- }
-
-
- //添加院系操作
- public void zhuanyeadd2() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
-
- String zhuanyeming = request.getParameter("zhuanyeming");
- Zhuanye bean = new Zhuanye();
- bean.setZhuanyeming(zhuanyeming);
- zhuanyeDao.insertBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!zhuanyelist'; </script>");
-
- }
-
-
-
- //删除院系操作
- public void zhuanyedelete() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String id = request.getParameter("id");
- Zhuanye bean =zhuanyeDao.selectBean(" where id= "+id);
- bean.setZhuanyelock(1);
- zhuanyeDao.insertBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!zhuanyelist'; </script>");
-
- }
-
- //跳转到更新院系页面
- public String zhuanyeupdate(){
- HttpServletRequest request = ServletActionContext.getRequest();
- String id = request.getParameter("id");
- Zhuanye bean =zhuanyeDao.selectBean(" where id= "+id);
- request.setAttribute("bean", bean);
- this.setUrl("zhuanye/zhuanyeupdate.jsp");
- return SUCCESS;
- }
-
-
- //更新院系操作
- public void zhuanyeupdate2() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String zhuanyeming = request.getParameter("zhuanyeming");
- String id = request.getParameter("id");
- Zhuanye bean =zhuanyeDao.selectBean(" where id= "+id);
- bean.setZhuanyeming(zhuanyeming);
- zhuanyeDao.insertBean(bean);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!zhuanyelist'; </script>");
-
- }
-
- private StudentDao studentDao;
-
- public StudentDao getStudentDao() {
- return studentDao;
- }
-
- public void setStudentDao(StudentDao studentDao) {
- this.studentDao = studentDao;
- }
-
- //学生信息管理
- public String studentlist(){
- HttpServletRequest request = ServletActionContext.getRequest();
- String name = request.getParameter("name");
- String xuehao = request.getParameter("xuehao");
- StringBuffer sb = new StringBuffer();
- sb.append(" where ");
- if(name!=null&&!"".equals(name)){
- sb.append("name like '%"+name+"%'");
- sb.append(" and ");
- request.setAttribute("name", name);
- }
- if(xuehao!=null&&!"".equals(xuehao)){
- sb.append("xuehao like '%"+xuehao+"%'");
- sb.append(" and ");
- request.setAttribute("xuehao", xuehao);
- }
- sb.append(" studentlock=0 order by id desc");
-
-
- int currentpage = 1;
- int pagesize = 10;
- if(request.getParameter("pagenum") != null){
- currentpage = Integer.parseInt(request.getParameter("pagenum"));
- }
- String where =sb.toString();
- long total = studentDao.selectBeanCount(where.replaceAll("order by id desc", ""));
- List<Student> list = studentDao.selectBeanList(currentpage-1, pagesize, where);
- request.setAttribute("list", list);
- String pagerinfo = Pager.getPagerNormal((int)total, pagesize, currentpage, "method!studentlist", "共有"+total+"条记录");
- request.setAttribute("pagerinfo", pagerinfo);
- request.setAttribute("url", "method!student");
- this.setUrl("student/studentlist.jsp");
- return SUCCESS;
- }
-
- //跳转到添加学生页面
- public String studentadd(){
- HttpServletRequest request = ServletActionContext.getRequest();
- request.setAttribute("list", zhuanyeDao.selectBeanList(0, 9999, " where zhuanyelock=0 "));
- this.setUrl("student/studentadd.jsp");
- return SUCCESS;
- }
-
-
- //添加学生操作
- public void studentadd2() throws IOException{
-
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String banji = request.getParameter("banji");
- String xuehao = request.getParameter("xuehao");
- String name = request.getParameter("name");
- String telephone = request.getParameter("telephone");
- String jiguan = request.getParameter("jiguan");
- String address = request.getParameter("address");
- String xingbie = request.getParameter("xingbie");
- String age = request.getParameter("age");
- Zhuanye zhuanye =zhuanyeDao.selectBean(" where zhuanyelock=0");
-
- User user = userDao.selectBean(" where username='"+xuehao+"' ");
- if(user==null){
- user = new User();
- user.setCreatetime(new Date());
- user.setPassword("111111");
- user.setRole(2);
- user.setTruename(name);
- user.setUsername(xuehao);
- userDao.insertBean(user);
-
- Student bean = new Student();
- bean.setBanji(banji);
- bean.setName(name);
- bean.setXuehao(xuehao);
- bean.setTelephone(telephone);
- bean.setJiguan(jiguan);
- bean.setAddress(address);
- bean.setAge(age);
- bean.setZhuanye(zhuanye);
- bean.setXingbie(xingbie);
- studentDao.insertBean(bean);
-
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!studentlist'; </script>");
- }else{
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交失败,该学号已经注册');window.location.href='method!studentlist'; </script>");
-
- }
-
-
- }
-
- //删除学生操作
- public void studentdelete() throws IOException{
- HttpServletRequest request = ServletActionContext.getRequest();
- HttpServletResponse response = ServletActionContext.getResponse();
- String id = request.getParameter("id");
- Student bean =studentDao.selectBean(" where id= "+id);
- bean.setStudentlock(1);
- studentDao.updateBean(bean);
- User user = userDao.selectBean(" where username='"+bean.getXuehao()+"' ");
- user.setUserlock(1);
- userDao.updateBean(user);
- response.setCharacterEncoding("utf8");
- PrintWriter writer = response.getWriter();
- writer.print("<script language='javascript'>alert('提交成功');window.location.href='method!studentlist'; </script>");
-
- }