• Java项目：JSP宿舍管理系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目包含系统管理员、楼宇管理员、学生三种角色；
    系统管理员角色包含以下功能：
    登录页面,楼宇管理员管理,学生管理,楼宇管理,宿舍管理,入住登记,寝室调换,迁出登记,缺寝记录,迁出记录等功能。

    楼宇管理员角色包含以下功能：
    登录页面,学生管理,缺勤记录查询等功能。

    学生角色包含以下功能：

    登录页面,查看缺勤记录等功能。

    环境需要

    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.数据库：MySql 5.7版本；

    6.是否Maven项目: 否；

    技术栈

    1. 后端：servlet+struts

    2. 前端：JSP+css+javacript

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中src/com/db/DBHelper.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入http://localhost:8080/ 登录 
    系统管理员账号/密码：admin/admin
    楼宇管理员账号/密码：louyu/123456

    学生账号/密码： 001/123456

    运行截图

     

     

     

     

     

     

     

    相关代码 

    AdminLog

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class AdminLog extends ActionSupport {
    15.  
    16. 	//ÏÂÃæÊÇActionÄÚÓÃÓÚ·â×°Óû§ÇëÇó²ÎÊýµÄÊôÐÔ
    17. 	private List buildinglist;
    18. 	private List domitorylist;
    19.  
    20. 	public List getBuildinglist() {
    21. 		return buildinglist;
    22. 	}
    23.  
    24. 	public void setBuildinglist(List buildinglist) {
    25. 		this.buildinglist = buildinglist;
    26. 	}
    27.  
    28. 	public List getDomitorylist() {
    29. 		return domitorylist;
    30. 	}
    31.  
    32. 	public void setDomitorylist(List domitorylist) {
    33. 		this.domitorylist = domitorylist;
    34. 	}
    35.  
    36. 	private String BuildingID;
    37. 	private String DomitoryID;
    38. 	public String getBuildingID() {
    39. 		return BuildingID;
    40. 	}
    41.  
    42. 	public void setBuildingID(String buildingID) {
    43. 		BuildingID = buildingID;
    44. 	}
    45.  
    46. 	public String getDomitoryID() {
    47. 		return DomitoryID;
    48. 	}
    49.  
    50. 	public void setDomitoryID(String domitoryID) {
    51. 		DomitoryID = domitoryID;
    52. 	}
    53.  
    54. 	//´¦ÀíÓû§ÇëÇóµÄexecute·½·¨
    55. 	public String execute() throws Exception {
    56. 		
    57. 		//½â¾öÂÒÂ룬ÓÃÓÚÒ³ÃæÊä³ö
    58. 		HttpServletResponse response=null;
    59. 		response=ServletActionContext.getResponse();
    60. 		response.setContentType("text/html;charset=UTF-8");
    61. 		response.setCharacterEncoding("UTF-8");
    62. 		PrintWriter out = response.getWriter();
    63. 		
    64. 		//´´½¨session¶ÔÏó
    65. 		HttpSession session = ServletActionContext.getRequest().getSession();
    66. 		//ÑéÖ¤ÊÇ·ñÕý³£µÇ¼
    67. 		if(session.getAttribute("id")==null){
    68. 			out.print("");
    69. 			out.flush();out.close();return null;
    70. 		}
    71. 		
    72. 		//²éѯ¥Óî
    73. 		buildinglist=new BuildingDao().GetList("","Building_Name");
    74. //		System.out.println(BuildingID);
    75. 		//²éѯÌõ¼þ
    76. 		String strWhere="1=1 ";
    77. 		if(!(isInvalid(BuildingID)))
    78. 		{
    79. 			strWhere+=" and Domitory_BuildingID='"+BuildingID+"'";
    80. 		}
    81. 		else{
    82. 			strWhere+=" and 1=2";
    83. 		}
    84. 		//²éѯÇÞÊÒ
    85. 		domitorylist=new DomitoryDao().GetList(strWhere,"Domitory_Name");
    86. 		
    87. 		return SUCCESS;
    88. 		
    89. 	}
    90. 	
    91. 	//ÅжÏÊÇ·ñ¿ÕÖµ
    92. 	private boolean isInvalid(String value) {
    93. 		return (value == null || value.length() == 0);
    94. 	}
    95. 	
    96. 	//²âÊÔ
    97. 	public static void main(String[] args) {
    98. 		System.out.println();
    99. 	}
    100. 	
    101. }

    AdminLogList

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class BuildingAddSave extends ActionSupport {
    15.  
    16. 	//下面是Action内用于封装用户请求参数的属性
    17. 	private String Building_Name ;
    18.     private String Building_Introduction ;
    19.  
    20. 	public String getBuilding_Name() {
    21. 		return Building_Name;
    22. 	}
    23.  
    24. 	public void setBuilding_Name(String buildingName) {
    25. 		Building_Name = buildingName;
    26. 	}
    27.  
    28. 	public String getBuilding_Introduction() {
    29. 		return Building_Introduction;
    30. 	}
    31.  
    32. 	public void setBuilding_Introduction(String buildingIntroduction) {
    33. 		Building_Introduction = buildingIntroduction;
    34. 	}
    35.  
    36. 	//处理用户请求的execute方法
    37. 	public String execute() throws Exception {
    38. 		
    39. 		//解决乱码，用于页面输出
    40. 		HttpServletResponse response=null;
    41. 		response=ServletActionContext.getResponse();
    42. 		response.setContentType("text/html;charset=UTF-8");
    43. 		response.setCharacterEncoding("UTF-8");
    44. 		PrintWriter out = response.getWriter();
    45. 		
    46. 		//创建session对象
    47. 		HttpSession session = ServletActionContext.getRequest().getSession();
    48. 		//验证是否正常登录
    49. 		if(session.getAttribute("id")==null){
    50. 			out.print("");
    51. 			out.flush();out.close();return null;
    52. 		}
    53. 		
    54. 		//查询名称是否存在
    55. 		List list=new BuildingDao().GetList("Building_Name='"+Building_Name+"'", "");
    56. 		if(list.size()>0)
    57. 		{
    58. 			out.print("");
    59. 			out.flush();out.close();return null;
    60. 		}
    61. 		//添加
    62. 		BuildingBean cnbean=new BuildingBean();
    63. 		cnbean.setBuilding_Name(Building_Name);
    64. 		cnbean.setBuilding_Introduction(Building_Introduction);
    65. 		new BuildingDao().Add(cnbean);
    66. 		    
    67. 		//跳转
    68. 		out.print("");
    69. 		out.flush();out.close();return null;
    70. 		
    71. 	}
    72. 	
    73. 	//判断是否空值
    74. 	private boolean isInvalid(String value) {
    75. 		return (value == null || value.length() == 0);
    76. 	}
    77. 	
    78. 	//测试
    79. 	public static void main(String[] args) {
    80. 		System.out.println();
    81. 	}
    82. 	
    83. }

    BuildingManager

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class BuildingManager extends ActionSupport {
    15.  
    16. 	//下面是Action内用于封装用户请求参数的属性
    17. 	private List list;
    18. 	public List getList() {
    19. 		return list;
    20. 	}
    21. 	public void setList(List list) {
    22. 		this.list = list;
    23. 	}
    24. 	private String SearchKey;
    25. 	public String getSearchKey() {
    26. 		return SearchKey;
    27. 	}
    28. 	public void setSearchKey(String searchKey) {
    29. 		SearchKey = searchKey;
    30. 	}
    31. 	//处理用户请求的execute方法
    32. 	public String execute() throws Exception {
    33. 		
    34. 		//解决乱码，用于页面输出
    35. 		HttpServletResponse response=null;
    36. 		response=ServletActionContext.getResponse();
    37. 		response.setContentType("text/html;charset=UTF-8");
    38. 		response.setCharacterEncoding("UTF-8");
    39. 		PrintWriter out = response.getWriter();
    40. 		
    41. 		//创建session对象
    42. 		HttpSession session = ServletActionContext.getRequest().getSession();
    43. 		//验证是否正常登录
    44. 		if(session.getAttribute("id")==null){
    45. 			out.print("");
    46. 			out.flush();out.close();return null;
    47. 		}
    48. 		//查询条件
    49. 		String strWhere="1=1";
    50. 		if(!(isInvalid(SearchKey)))
    51. 		{
    52. 			strWhere+=" and Building_Name='"+SearchKey+"'";
    53. 		}
    54. 		//查询所有
    55. 		list=new BuildingDao().GetList(strWhere,"Building_Name");
    56. 	
    57. 		return SUCCESS;
    58. 		
    59. 	}
    60. 	
    61. 	//判断是否空值
    62. 	private boolean isInvalid(String value) {
    63. 		return (value == null || value.length() == 0);
    64. 	}
    65. 	
    66. 	//测试
    67. 	public static void main(String[] args) {
    68. 		System.out.println();
    69. 	}
    70. 	
    71. }

    BuildingUpdate

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class BuildingUpdate extends ActionSupport {
    15.  
    16. 	//下面是Action内用于封装用户请求参数的属性
    17. 	private String Building_ID;
    18. 	private BuildingBean cnbean;
    19. 	public String getBuilding_ID() {
    20. 		return Building_ID;
    21. 	}
    22.  
    23. 	public void setBuilding_ID(String studentID) {
    24. 		Building_ID = studentID;
    25. 	}
    26.  
    27. 	public BuildingBean getCnbean() {
    28. 		return cnbean;
    29. 	}
    30.  
    31. 	public void setCnbean(BuildingBean cnbean) {
    32. 		this.cnbean = cnbean;
    33. 	}
    34.  
    35. 	//处理用户请求的execute方法
    36. 	public String execute() throws Exception {
    37. 		
    38. 		//解决乱码，用于页面输出
    39. 		HttpServletResponse response=null;
    40. 		response=ServletActionContext.getResponse();
    41. 		response.setContentType("text/html;charset=UTF-8");
    42. 		response.setCharacterEncoding("UTF-8");
    43. 		PrintWriter out = response.getWriter();
    44. 		
    45. 		//创建session对象
    46. 		HttpSession session = ServletActionContext.getRequest().getSession();
    47. 		//验证是否正常登录
    48. 		if(session.getAttribute("id")==null){
    49. 			out.print("");
    50. 			out.flush();out.close();return null;
    51. 		}
    52. 		
    53. 		//查询
    54. 		cnbean=new BuildingDao().GetBean(Integer.parseInt(Building_ID));
    55. 		return SUCCESS;
    56. 		
    57. 	}
    58. 	
    59. 	//判断是否空值
    60. 	private boolean isInvalid(String value) {
    61. 		return (value == null || value.length() == 0);
    62. 	}
    63. 	
    64. 	//测试
    65. 	public static void main(String[] args) {
    66. 		System.out.println();
    67. 	}
    68. 	
    69. }

    DomitoryAdd

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class DomitoryAdd extends ActionSupport {
    15.  
    16. 	//下面是Action内用于封装用户请求参数的属性
    17. 	private List list;
    18. 	public List getList() {
    19. 		return list;
    20. 	}
    21. 	public void setList(List list) {
    22. 		this.list = list;
    23. 	}
    24. 	//处理用户请求的execute方法
    25. 	public String execute() throws Exception {
    26. 		
    27. 		//解决乱码，用于页面输出
    28. 		HttpServletResponse response=null;
    29. 		response=ServletActionContext.getResponse();
    30. 		response.setContentType("text/html;charset=UTF-8");
    31. 		response.setCharacterEncoding("UTF-8");
    32. 		PrintWriter out = response.getWriter();
    33. 		
    34. 		//创建session对象
    35. 		HttpSession session = ServletActionContext.getRequest().getSession();
    36. 		//验证是否正常登录
    37. 		if(session.getAttribute("id")==null){
    38. 			out.print("");
    39. 			out.flush();out.close();return null;
    40. 		}
    41.  
    42. 		//查询所有楼宇
    43. 		list=new BuildingDao().GetList("","Building_Name");
    44. 	
    45. 		return SUCCESS;
    46. 		
    47. 	}
    48. 	
    49. 	//判断是否空值
    50. 	private boolean isInvalid(String value) {
    51. 		return (value == null || value.length() == 0);
    52. 	}
    53. 	
    54. 	//测试
    55. 	public static void main(String[] args) {
    56. 		System.out.println();
    57. 	}
    58. 	
    59. }

    DomitoryAddSave

    1. package com.action;
    2.  
    3. import java.io.PrintWriter;
    4. import java.util.List;
    5. import javax.servlet.http.HttpServletResponse;
    6. import javax.servlet.http.HttpSession;
    7. import org.apache.struts2.ServletActionContext;
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. import com.bean.*;
    11. import com.dao.*;
    12.  
    13.  
    14. public class DomitoryAddSave extends ActionSupport {
    15.  
    16. 	//下面是Action内用于封装用户请求参数的属性
    17. 	private String Domitory_BuildingID ;
    18.     private String Domitory_Name ;
    19.     private String Domitory_Type ;
    20.     private String Domitory_Number ;
    21.     private String Domitory_Tel ;
    22.  
    23.  
    24. 	public String getDomitory_BuildingID() {
    25. 		return Domitory_BuildingID;
    26. 	}
    27.  
    28. 	public void setDomitory_BuildingID(String domitoryBuildingID) {
    29. 		Domitory_BuildingID = domitoryBuildingID;
    30. 	}
    31.  
    32. 	public String getDomitory_Name() {
    33. 		return Domitory_Name;
    34. 	}
    35.  
    36. 	public void setDomitory_Name(String domitoryName) {
    37. 		Domitory_Name = domitoryName;
    38. 	}
    39.  
    40. 	public String getDomitory_Type() {
    41. 		return Domitory_Type;
    42. 	}
    43.  
    44. 	public void setDomitory_Type(String domitoryType) {
    45. 		Domitory_Type = domitoryType;
    46. 	}
    47.  
    48. 	public String getDomitory_Number() {
    49. 		return Domitory_Number;
    50. 	}
    51.  
    52. 	public void setDomitory_Number(String domitoryNumber) {
    53. 		Domitory_Number = domitoryNumber;
    54. 	}
    55.  
    56. 	public String getDomitory_Tel() {
    57. 		return Domitory_Tel;
    58. 	}
    59.  
    60. 	public void setDomitory_Tel(String domitoryTel) {
    61. 		Domitory_Tel = domitoryTel;
    62. 	}
    63.  
    64. 	//处理用户请求的execute方法
    65. 	public String execute() throws Exception {
    66. 		
    67. 		//解决乱码，用于页面输出
    68. 		HttpServletResponse response=null;
    69. 		response=ServletActionContext.getResponse();
    70. 		response.setContentType("text/html;charset=UTF-8");
    71. 		response.setCharacterEncoding("UTF-8");
    72. 		PrintWriter out = response.getWriter();
    73. 		
    74. 		//创建session对象
    75. 		HttpSession session = ServletActionContext.getRequest().getSession();
    76. 		//验证是否正常登录
    77. 		if(session.getAttribute("id")==null){
    78. 			out.print("");
    79. 			out.flush();out.close();return null;
    80. 		}
    81. 		
    82. 		//查询是否存在
    83. 		List list=new DomitoryDao().GetList("Domitory_Name='"+Domitory_Name+"' and Domitory_BuildingID="+Domitory_BuildingID, "");
    84. 		if(list.size()>0)
    85. 		{
    86. 			out.print("");
    87. 			out.flush();out.close();return null;
    88. 		}
    89. 		//添加
    90. 		DomitoryBean cnbean=new DomitoryBean();
    91. 		cnbean.setDomitory_BuildingID(Integer.parseInt(Domitory_BuildingID));
    92. 		cnbean.setDomitory_Name(Domitory_Name);
    93. 		cnbean.setDomitory_Type(Domitory_Type);
    94. 		cnbean.setDomitory_Number(Domitory_Number);
    95. 		cnbean.setDomitory_Tel(Domitory_Tel);
    96. 		new DomitoryDao().Add(cnbean);
    97. 		    
    98. 		//跳转
    99. 		out.print("");
    100. 		out.flush();out.close();return null;
    101. 		
    102. 	}
    103. 	
    104. 	//判断是否空值
    105. 	private boolean isInvalid(String value) {
    106. 		return (value == null || value.length() == 0);
    107. 	}
    108. 	
    109. 	//测试
    110. 	public static void main(String[] args) {
    111. 		System.out.println();
    112. 	}
    113. 	
    114. }

    GoLogin

    1. package com.action;
    2.  
    3. import javax.servlet.http.HttpSession;
    4. import org.apache.struts2.ServletActionContext;
    5. import com.dao.*;
    6. import com.bean.*;
    7.  
    8. import com.opensymphony.xwork2.ActionSupport;
    9.  
    10. public class GoLogin extends ActionSupport {
    11.  
    12. 	//下面是Action内用于封装用户请求参数的属性
    13. 	private String Type;
    14. 	private String Username;
    15. 	private String Password;
    16. 	private String Msg;
    17. 	public String getType() {
    18. 		return Type;
    19. 	}
    20. 	public void setType(String type) {
    21. 		Type = type;
    22. 	}
    23. 	public String getUsername() {
    24. 		return Username;
    25. 	}
    26. 	public void setUsername(String username) {
    27. 		Username = username;
    28. 	}
    29. 	public String getPassword() {
    30. 		return Password;
    31. 	}
    32. 	public void setPassword(String password) {
    33. 		Password = password;
    34. 	}
    35. 	public String getMsg() {
    36. 		return Msg;
    37. 	}
    38. 	public void setMsg(String msg) {
    39. 		Msg = msg;
    40. 	}
    41. 	//处理用户请求的execute方法
    42. 	public String execute() throws Exception {
    43.  
    44. 		if(Type.equals("系统管理员"))
    45. 		{
    46. 			if (null == new AdminDao().CheckLogin(Username, Password)) {
    47. 				Msg = "用户名或者密码错误";
    48. 				return INPUT;
    49. 			}
    50. 			else
    51. 			{
    52. 				//获取ID
    53. 				String Admin_ID=new AdminDao().CheckLogin(Username, Password);
    54. 				//创建session
    55. 				HttpSession session = ServletActionContext.getRequest().getSession();
    56. 				session.setAttribute("id", Admin_ID);
    57. 				session.setAttribute("type", "1");
    58. 				return SUCCESS;
    59. 			}
    60. 		}
    61. 		else if(Type.equals("楼宇管理员"))
    62. 		{
    63. 			if (null == new TeacherDao().CheckLogin(Username, Password)) {
    64. 				Msg = "用户名或者密码错误";
    65. 				return INPUT;
    66. 			}
    67. 			else
    68. 			{
    69. 				//获取ID
    70. 				String Teacher_ID=new TeacherDao().CheckLogin(Username, Password);
    71. 				//创建session
    72. 				HttpSession session = ServletActionContext.getRequest().getSession();
    73. 				session.setAttribute("id", Teacher_ID);
    74. 				session.setAttribute("type", "2");
    75. 				
    76. 				return SUCCESS;
    77. 			}
    78. 		}
    79. 		else if(Type.equals("学生"))
    80. 		{
    81. 			if (null == new StudentDao().CheckLogin(Username, Password)) {
    82. 				Msg = "用户名或者密码错误";
    83. 				return INPUT;
    84. 			}
    85. 			else
    86. 			{
    87. 				//获取ID
    88. 				String Student_ID=new StudentDao().CheckLogin(Username, Password);
    89. 				//创建session
    90. 				HttpSession session = ServletActionContext.getRequest().getSession();
    91. 				session.setAttribute("id", Student_ID);
    92. 				session.setAttribute("type", "3");
    93. 				return SUCCESS;
    94. 			}
    95. 		}
    96. 		else
    97. 		{
    98. 			Msg = "身份类型错误";
    99. 			return INPUT;
    100. 		}
    101. 		
    102. 	}
    103. }

    如果也想学习本系统，下面领取。关注并回复：117jsp

  • 相关阅读:
    ISP屏幕和LCD屏幕的区别，以及AMOLED、Super AMOLED和OLED
    使用 @Transactional 时常犯的N种错误
    分享一个docker无法启动的小问题
    CSDN专栏设置
    [附源码]Python计算机毕业设计Django“小世界”私人空间
    gorm的增删改查
    Apipost一键压测已支持导入CSV文件
    C语言——经典200道例题（6-10）
    【Vue】修饰符、表单提交方式、自定义组件的关键步骤
    Java线程中的状态
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126913727