• Java项目：SSM自习室图书馆座位预约管理系统

    作者主页：夜未央5788

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

    文末获取源码

    项目介绍

    一款由jsp+ssm+mysql实现的图书馆预约占座管理系统，前端采用的是当下最流行的easyui框架，后台用的ssm（spring、springMVC、mybaits）框架.添加学生和教师时会自动在用户表中注册，定时任务会定时生成座位信息，阅览室分类中可设置信用等级，学生被扣分后信用等级低于相应的值后不能预约相应的阅览室座位.本项目分为管理员、教师、学生三种角色。
    管理员角色包含以下功能：
    管理员登陆,用户管理,师生信息管理,阅览室管理,信用积分管理,交流管理,信息统计,图书推荐等功能。

    教师角色包含以下功能：
    教师角色登陆,个人信息管理,管理学生的信用积分等功能。

    学生角色包含以下功能：

    学生账号登陆,阅览室信息查看,信息积分查看,选座位,选座管理,通知信息管理,信息交流,图书推荐等功能。

    环境需要

    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. 后端：Spring+SpringMVC+Mybatis

    2. 前端：JSP+easyUI

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中config.properties配置文件中的数据库配置改为自己的配置;

    4. 运行项目，输入localhost:8080/ 登录

    运行截图

    管理员角色

    教师角色

    学生角色

    相关代码

    BlockController

    1. package dingzhen.controller;
    2.  
    3. // 查看余坐
    4. import java.text.SimpleDateFormat;
    5. import java.util.ArrayList;
    6. import java.util.Calendar;
    7. import java.util.Date;
    8. import java.util.List;
    9.  
    10. import javax.servlet.http.HttpServletRequest;
    11. import javax.servlet.http.HttpServletResponse;
    12.  
    13. import net.sf.json.JSONArray;
    14.  
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.stereotype.Controller;
    17. import org.springframework.web.bind.annotation.RequestMapping;
    18.  
    19. import dingzhen.entity.Room;
    20. import dingzhen.entity.Seat;
    21. import dingzhen.service.RoomService;
    22. import dingzhen.service.SeatService;
    23. import dingzhen.util.WriterUtil;
    24.  
    25. @Controller
    26. @RequestMapping("block")
    27. public class BlockController {
    28. 	
    29. 	@Autowired
    30. 	private RoomService roomService;
    31. 	private Seat seat;
    32. 	@Autowired
    33. 	private SeatService seatService;
    34. 	
    35. 	
    36. 	@RequestMapping("blockList")
    37. 	public void list(HttpServletResponse response,HttpServletRequest request) {
    38. 		try {
    39. 			String[] times = new String[]{"08点-12点","14点-18点","18点-22点"};
    40. 			Date today = new Date();
    41. 			Date tomorrow = getNextDay(today, 1);
    42. 			Date[] dates = new Date[]{today,tomorrow};
    43. 			List rooms = roomService.findRoom(new Room());
    44. 			List list = new ArrayList();
    45. 			for(int j=0;j
    46. 				Date date = dates[j];
    47. 			for(int i=0;i
    48. 				String time = times[i];
    49. 					for(int k=0;k
    50. 						int roomid = rooms.get(k).getId();
    51. 						seat = new Seat();
    52. 						seat.setRoomid(roomid);
    53. 						seat.setDate(new SimpleDateFormat("yyyy-MM-dd").format(date));
    54. 						seat.setTime(time);
    55. 						seat.setRoomname(rooms.get(k).getName());
    56. 						int yuzuo = seatService.findBlock(seat);
    57. 						seat.setPage(yuzuo);        //将page字段临时存放余坐
    58. 						list.add(seat);
    59. 					}
    60. 				}
    61. 			}
    62. 			JSONArray array = new JSONArray();
    63. 			array.addAll(list);
    64. 			WriterUtil.write(response, array.toString());
    65. 		} catch (Exception e) {
    66. 			e.printStackTrace();
    67. 		}
    68. 		
    69. 	}
    70. 	
    71. 	
    72. 	@RequestMapping("blockIndex")
    73. 	public String block(){
    74. 		return "seat/block";
    75. 	}
    76. 	
    77. 	public static Date getNextDay(Date date,int day) {
    78. 		Calendar calendar = Calendar.getInstance();
    79. 		calendar.setTime(date);
    80. 		calendar.add(Calendar.DAY_OF_MONTH, day);
    81. 		date = calendar.getTime();
    82. 		return date;
    83. 	}
    84. 	
    85. 	
    86. }

    登录控制器

    1. package dingzhen.controller;
    2.  
    3. import java.util.HashMap;
    4. import java.util.List;
    5. import java.util.Map;
    6.  
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    9. import javax.servlet.http.HttpSession;
    10.  
    11. import net.sf.json.JSONArray;
    12. import net.sf.json.JSONObject;
    13.  
    14. import org.springframework.beans.factory.annotation.Autowired;
    15. import org.springframework.stereotype.Controller;
    16. import org.springframework.web.bind.annotation.RequestMapping;
    17.  
    18. import dingzhen.util.StringUtil;
    19. import dingzhen.util.WriterUtil;
    20. import dingzhen.entity.Menu;
    21. import dingzhen.entity.Role;
    22. import dingzhen.entity.User;
    23. import dingzhen.service.MenuService;
    24. import dingzhen.service.RoleService;
    25. import dingzhen.service.UserService;
    26.  
    27. /**
    28.  * 登录
    29.  */
    30. @Controller
    31. @SuppressWarnings("unchecked")
    32. public class LoginController {
    33.  
    34. 	private User user;
    35. 	private User currentUser;
    36. 	@Autowired
    37. 	private UserService userService;
    38. 	@Autowired
    39. 	private MenuService menuService;
    40. 	private Role role;
    41. 	@Autowired
    42. 	private RoleService roleService;
    43. 	private Map map;
    44. 	
    45. 	@RequestMapping("login")
    46. 	public void login(HttpServletRequest request,HttpServletResponse response){
    47. 		try {
    48. 			HttpSession session = request.getSession();
    49. 			String userName=request.getParameter("userName");
    50. 			String password=request.getParameter("password");
    51. 			String imageCode=request.getParameter("imageCode");
    52. 			request.setAttribute("userName", userName);
    53. 			request.setAttribute("password", password);
    54. 			request.setAttribute("imageCode", imageCode);
    55. 			if(StringUtil.isEmpty(userName)||StringUtil.isEmpty(password)){
    56. 				request.setAttribute("error", "账户或密码为空");
    57. 				request.getRequestDispatcher("login.jsp").forward(request, response);
    58. 				return;
    59. 			}
    60. 			if(StringUtil.isEmpty(imageCode)){
    61. 				request.setAttribute("error", "验证码为空");
    62. 				request.getRequestDispatcher("login.jsp").forward(request, response);
    63. 				return;
    64. 			}
    65. 			if(!imageCode.equals(session.getAttribute("sRand"))){
    66. 				request.setAttribute("error", "验证码错误");
    67. 				request.getRequestDispatcher("login.jsp").forward(request, response);
    68. 				return;
    69. 			}
    70. 			map = new HashMap();
    71. 			map.put("userName", userName);
    72. 			map.put("password", password);
    73. 			currentUser = userService.loginUser(map);
    74. 			if(currentUser==null){
    75. 				request.setAttribute("error", "用户名或密码错误");
    76. 				request.getRequestDispatcher("login.jsp").forward(request, response);
    77. 			}else{
    78. 				role = roleService.findOneRole(currentUser.getRoleId());
    79. 				String roleName=role.getRoleName();
    80. 				currentUser.setRoleName(roleName);
    81. 				session.setAttribute("currentUser", currentUser);
    82. 				session.setAttribute("currentOperationIds", role.getOperationIds());
    83. 				response.sendRedirect("main.htm");
    84. 			}
    85. 		} catch (Exception e) {
    86. 			e.printStackTrace();
    87. 		}
    88. 	}
    89. 	
    90. 	
    91. 	// 进入系统主界面
    92. 	@RequestMapping("main")
    93. 	public String toMain(HttpServletRequest request){
    94. 		Object attribute = request.getSession().getAttribute("currentUser");
    95. 		if(attribute == null){
    96. 			return "redirect:login.htm";
    97. 		}
    98. 		//return "main";
    99. 		return "sys/main";
    100. 	}
    101. 	
    102. 	
    103. 	// 加载最上级左菜单树
    104. 	@RequestMapping("menuTree")
    105. 	public void getMenuTree(HttpServletRequest request,HttpServletResponse response){
    106. 		try {
    107. 			String parentId = request.getParameter("parentId");
    108. 			currentUser = (User) request.getSession().getAttribute("currentUser");
    109. 			role = roleService.findOneRole(currentUser.getRoleId());
    110. 			String[] menuIds = role.getMenuIds().split(",");
    111. 			map = new HashMap();
    112. 			map.put("parentId",parentId);
    113. 			map.put("menuIds", menuIds);
    114. 			JSONArray jsonArray = getMenusByParentId(parentId, menuIds);
    115. 			WriterUtil.write(response, jsonArray.toString());
    116. 		} catch (Exception e) {
    117. 			e.printStackTrace();
    118. 		}
    119. 	}
    120. 	
    121. 	
    122. 	// 递归加载所所有树菜单
    123. 	public JSONArray getMenusByParentId(String parentId,String[] menuIds)throws Exception{
    124. 		JSONArray jsonArray=this.getMenuByParentId(parentId,menuIds);
    125. 		for(int i=0;i
    126. 			JSONObject jsonObject=jsonArray.getJSONObject(i);
    127. 			if("open".equals(jsonObject.getString("state"))){
    128. 				continue;
    129. 			}else{
    130. 				jsonObject.put("children", getMenusByParentId(jsonObject.getString("id"),menuIds));
    131. 			}
    132. 		}
    133. 		return jsonArray;
    134. 	}
    135. 	
    136. 	
    137. 	// 将所有的树菜单放入easyui要求格式的json
    138. 	public JSONArray getMenuByParentId(String parentId,String[] menuIds)throws Exception{
    139. 		JSONArray jsonArray=new JSONArray();
    140. 		map= new HashMap();
    141. 		map.put("parentId",parentId);
    142. 		map.put("menuIds", menuIds);
    143. 		List list = menuService.menuTree(map);
    144. 		for(Menu menu : list){
    145. 			JSONObject jsonObject = new JSONObject();
    146. 			jsonObject.put("id", menu.getMenuId());
    147. 			jsonObject.put("text", menu.getMenuName());
    148. 			jsonObject.put("iconCls", menu.getIconCls());
    149. 			JSONObject attributeObject = new JSONObject();
    150. 			attributeObject.put("menuUrl", menu.getMenuUrl());
    151. 			if(!hasChildren(menu.getMenuId(), menuIds)){
    152. 				jsonObject.put("state", "open");
    153. 			}else{
    154. 				jsonObject.put("state", menu.getState());				
    155. 			}
    156. 			jsonObject.put("attributes", attributeObject);
    157. 			jsonArray.add(jsonObject);
    158. 		}
    159. 		return jsonArray;
    160. 	}
    161. 	
    162. 	
    163. 	// 判断是不是有子孩子，人工结束递归树
    164. 	public boolean hasChildren(Integer parentId,String[] menuIds){
    165. 		boolean flag = false;
    166. 		try {
    167. 			map= new HashMap();
    168. 			map.put("parentId",parentId);
    169. 			map.put("menuIds", menuIds);
    170. 			List list = menuService.menuTree(map);
    171. 			if (list == null || list.size()==0) {
    172. 				flag = false;
    173. 			}else {
    174. 				flag = true;
    175. 			}
    176. 		} catch (Exception e) {
    177. 			e.printStackTrace();
    178. 		}
    179. 		return flag;
    180. 	}
    181.  
    182. 	
    183. 	
    184. 	
    185. 	// 更新密码
    186. 	@RequestMapping("updatePassword")
    187. 	public void updatePassword(HttpServletRequest request,HttpServletResponse response){
    188. 		JSONObject result=new JSONObject();
    189. 		try {
    190. 			String userId=request.getParameter("userId");
    191. 			String newPassword=request.getParameter("newPassword");
    192. 			user=new User();
    193. 			user.setUserId(Integer.parseInt(userId));
    194. 			user.setPassword(newPassword);
    195. 			userService.updateUser(user);
    196. 			result.put("success", "true");
    197. 		} catch (Exception e) {
    198. 			e.printStackTrace();
    199. 			result.put("success", "true");
    200. 			result.put("errorMsg", "对不起！密码修改失败");
    201. 		}
    202. 		WriterUtil.write(response, result.toString());
    203. 	}
    204. 	
    205. 	
    206. 	//安全退出
    207. 	@SuppressWarnings("unused")
    208. 	@RequestMapping("logout")
    209. 	private void logout(HttpServletRequest request,HttpServletResponse response) throws Exception{
    210. 		request.getSession().invalidate();
    211. 		response.sendRedirect("login.jsp");
    212. 	}
    213. 	
    214. }

    阅览室控制器

    1. package dingzhen.controller;
    2.  
    3. import java.text.SimpleDateFormat;
    4. import java.util.Date;
    5. import java.util.List;
    6.  
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    9.  
    10. import net.sf.json.JSONArray;
    11. import net.sf.json.JSONObject;
    12.  
    13. import org.springframework.beans.factory.annotation.Autowired;
    14. import org.springframework.stereotype.Controller;
    15. import org.springframework.web.bind.annotation.RequestMapping;
    16.  
    17. import dingzhen.entity.Room;
    18. import dingzhen.entity.Seat;
    19. import dingzhen.service.RoomService;
    20. import dingzhen.service.SeatService;
    21. import dingzhen.util.StringUtil;
    22. import dingzhen.util.WriterUtil;
    23. // 阅览室基本信息
    24.  
    25. @RequestMapping("room")
    26. @Controller
    27. public class RoomController {
    28.  
    29. 	private int page;
    30. 	private int rows;
    31. 	private Room room;
    32. 	@Autowired
    33. 	private RoomService roomService;
    34. 	
    35. 	@Autowired
    36. 	private SeatService seatService;
    37. 	
    38. 	@RequestMapping("roomIndex")
    39. 	public String index(){
    40. 		return "readingroom/room";
    41. 	}
    42. 	
    43. 	
    44. 	
    45. 	@RequestMapping("roomList")
    46. 	public void roomList(HttpServletRequest request,HttpServletResponse response) {
    47. 		try {
    48. 			page = Integer.parseInt(request.getParameter("page"));
    49. 			rows = Integer.parseInt(request.getParameter("rows"));
    50. 			room = new Room();
    51. 			if(request.getParameter("typeid")!=null && request.getParameter("typeid").length() > 0){
    52. 				room.setTypeid(Integer.parseInt(request.getParameter("typeid")));
    53. 			}
    54. 			room.setPage((page-1)*rows);
    55. 			room.setRows(rows);
    56. 			List list = roomService.findRoom(room);
    57. 			int total = roomService.countRoom(room);
    58. 			
    59. 			JSONObject jsonObj = new JSONObject();//new一个JSON
    60. 			jsonObj.put("total",total );//total代表一共有多少数据
    61. 			jsonObj.put("rows", list);//row是代表显示的页的数据
    62. 	        WriterUtil.write(response,jsonObj.toString()); //将上述Json输出，前台ajax接收
    63. 		} catch (Exception e) {
    64. 			e.printStackTrace();
    65. 		}
    66. 	}
    67. 	
    68. 	
    69. 	
    70. 	
    71. 	@RequestMapping("reserveRoom")
    72. 	public void reserveroom(HttpServletRequest request,HttpServletResponse response,Room room) {
    73. 		String id = request.getParameter("id");
    74. 		room.setTotal(room.getCol() * room.getRow());  //总座位数=列数     X 行数
    75. 		JSONObject result = new JSONObject();
    76. 		result.put("success", true);
    77. 		try {
    78. 			if(StringUtil.isNotEmpty(id)){
    79. 				room.setId(Integer.parseInt(id));
    80. 				roomService.updateRoom(room);
    81. 			} else {
    82. 				roomService.addRoom(room);
    83. 				/**int row=room.getRow();
    84. 				int cal=room.getCol();
    85. 				for(int rown=1; rown<=row; rown++) {
    86. 					for(int caln=1;caln<=cal;caln++) {
    87. 						Seat seat = new Seat();
    88. 						seat.setCol(caln);
    89. 						seat.setRow(rown);
    90. 						seat.setDate(id);
    91. 						seat.setStudentno("1");
    92. 						seatService.occupySeat(seat);
    93. 					}
    94. 				}**/
    95. 				int row=room.getRow();
    96. 				int cal=room.getCol();
    97. 				for(int rown=1; rown<=row; rown++) {
    98. 					for(int caln=1;caln<=cal;caln++) {
    99. 				try {
    100. 					Seat seat = new Seat();
    101. 					seat.setCol(caln);
    102. 					seat.setRow(rown);
    103. 					seat.setDate(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
    104. 					int roomid=roomService.getFinal();
    105. 					seat.setRoomid(roomid);
    106. 					seat.setTime("08点-12点");
    107. 					seat.setKeyword(new SimpleDateFormat("yyyy-MM-dd").format(new Date())+"-08点-12点-"+roomid+"-"+rown+"-"+caln);
    108. 					//2021-05-14-08点-12点-24-9-9
    109. 					seatService.insertSeat(seat);
    110. 				} catch (Exception e) {
    111. 					e.printStackTrace();
    112. 				}
    113. 					}}
    114. 			}
    115. 		} catch (Exception e) {
    116. 			e.printStackTrace();
    117. 			result.put("errorMsg", "对不起！保存失败");
    118. 		}
    119. 		WriterUtil.write(response,result.toString());
    120. 	}
    121. 	
    122. 	
    123. 	
    124. 	
    125. 	@RequestMapping("deleteRoom")
    126. 	public void delete(HttpServletRequest request,HttpServletResponse response){
    127. 		JSONObject result=new JSONObject();
    128. 		try {
    129. 			String[] ids=request.getParameter("ids").split(",");
    130. 			for (String id : ids) {
    131. 				roomService.deleteRoom(Integer.parseInt(id));
    132. 			}
    133. 			result.put("success", true);
    134. 			result.put("delNums", ids.length);
    135. 		} catch (Exception e) {
    136. 			e.printStackTrace();
    137. 			result.put("errorMsg", "对不起，删除失败");
    138. 		}
    139. 		WriterUtil.write(response, result.toString());
    140. 	}
    141. 	
    142. 	
    143. 	
    144. }

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

  • 相关阅读:
    go test, go bench & go examples
    # ODS及DWD层自动化构建##， 220731，
    【数据库原理与应用】数据库应用实例— 教学管理系统
    Xavier CPU & GPU 高负载功耗测试
    太原师范学院计算机考研资料汇总
    微服务实战系列之Sentinel
    【分布式技术专题】「分布式技术架构」一文带你厘清分布式事务协议及分布式一致性协议的算法原理和核心流程机制（Paxos篇）
    java--拼图游戏
    基于单片机的太阳能热水器控制系统设计
    MindSpore新型轻量级神经网络GhostNet，在ImageNet分类、图像识别和目标检测等多个应用场景效果优异！
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126435134