devbox
Monodyee
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

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

作者：Monodyee | 2024-05-03 16:24:45

赞

踩

图书预约管理系统csdn

作者主页：夜未央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<Room> roomService;
  31. 	private Seat seat;
  32. 	@Autowired
  33. 	private SeatService<Seat> 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<Room> rooms = roomService.findRoom(new Room());
  44. 			List<Seat> list = new ArrayList<Seat>();
  45. 			for(int j=0;j<dates.length;j++){
  46. 				Date date = dates[j];
  47. 			for(int i=0;i<times.length;i++){
  48. 				String time = times[i];
  49. 					for(int k=0;k<rooms.size();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<User> userService;
  38. 	@Autowired
  39. 	private MenuService<Menu> menuService;
  40. 	private Role role;
  41. 	@Autowired
  42. 	private RoleService<Role> 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<String, String>();
  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<jsonArray.size();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<Menu> 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<Menu> 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<Room> roomService;
  34. 	
  35. 	@Autowired
  36. 	private SeatService<Seat> 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<Room> 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

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Monodyee/article/detail/530536
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号