基于javaweb+mysql的jsp+servlet会议室管理系统(java+jsp+html+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet会议室管理系统(java+jsp+html+servlet+mysql)
项目介绍
本项目包含两个角色,管理员与用户角色;
管理员角色包含以下功能: 查看预订,查看会议,部门管理,员工注册,添加会议室,审批员工等功能。
用户角色包含以下功能: 预定会议,查看我将参加的会议,会议室查看,通知信息查看,查看撤销会议等功能。
环境需要
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项目:否;
技术栈
JSP+CSS+JavaScript+html+mysql+servlet
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中dao/DBUtils.java配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入localhost:8080/meeting/ 注:Tomcat中配置路径必须为meeting,否则会有异常; 管理员账号/密码:admin/admin 用户账号/密码:linyaokun/123456
meetingService.insert(meeting, selSelectedEmployees);
resp.sendRedirect(req.getContextPath() + "/mybooking");
//resp.sendRedirect(req.getContextPath() + "/mymeeting");
}
}
/**
*/
public class DoRegServlet extends HttpServlet {
private EmployeeService employeeService = new EmployeeService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String employeename = req.getParameter("employeename");
String accountname = req.getParameter("accountname");
String password = req.getParameter("password");
String phone = req.getParameter("phone");
String email = req.getParameter("email");
String deptid = req.getParameter("deptid");
Employee employee = new Employee(employeename, accountname, phone, email, Integer.parseInt(deptid), password);
int reg = employeeService.reg(employee);
if (reg == 1) {
//注册成功,跳转到登录页面
resp.sendRedirect(req.getContextPath() + "/login.jsp");
} else if (reg == -1) {
//用户名重复,注册失败
req.setAttribute("error", "用户名重复,注册失败");
req.getRequestDispatcher("/reg").forward(req, resp);
} else {
req.setAttribute("error", "不明原因,注册失败");
} else {
req.setAttribute("error", "删除失败");
req.getRequestDispatcher("/departments").forward(req, resp);
}
}
}
/**
*/
public class MyBookingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mrs = meetingService.getMyBookingMeeting(loginEmpId);
req.setAttribute("mrs", mrs);
req.getRequestDispatcher("/mybookings.jsp").forward(req, resp);
}
}
/**
public void destroy() {
}
}
/**
*/
public class MeetingDetailsServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String mid = req.getParameter("mid");
String type = req.getParameter("type");
Meeting meeting = meetingService.getMeetingDetailsByMeetingId(Integer.parseInt(mid));
List<Employee> emps = meetingService.getEmps();
req.setAttribute("mt", meeting);
req.setAttribute("emps", emps);
req.setAttribute("type", type);
req.getRequestDispatcher("/meetingdetails.jsp").forward(req, resp);
}
}
}
@Override
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) request;
String servletPath = req.getServletPath();
if ("/login.jsp".equals(servletPath) || "/reg".equals(servletPath) || "/doreg".equals(servletPath) || "/login".equals(servletPath) || servletPath.contains("/images/") || servletPath.contains("/js/") || servletPath.contains("/My97DatePicker/") || servletPath.contains("/styles/")) {
chain.doFilter(req, response);
} else {
Object loginUser = req.getSession().getAttribute("loginUser");
if (loginUser == null) {
((HttpServletResponse) response).sendRedirect(req.getContextPath() + "/login.jsp");
} else {
chain.doFilter(req, response);
}
}
}
@Override
public void destroy() {
}
}
/**
*/
public class MeetingDetailsServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String mid = req.getParameter("mid");
String type = req.getParameter("type");
Meeting meeting = meetingService.getMeetingDetailsByMeetingId(Integer.parseInt(mid));
List<Employee> emps = meetingService.getEmps();
req.setAttribute("mt", meeting);
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String status = req.getParameter("status");
String empid = req.getParameter("empid");
int i = employeeService.updateEmpStatusById(Integer.parseInt(empid), Integer.parseInt(status));
if (i == 1) {
resp.sendRedirect(req.getContextPath() + "/approveaccount");
} else {
req.setAttribute("error", "审批失败");
req.getRequestDispatcher("/approveaccount").forward(req, resp);
}
}
}
/**
*/
public class UpdateDepServlet extends HttpServlet {
private DepartmentService departmentService = new DepartmentService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/html;charset=utf-8");
String id = req.getParameter("id");
String depName = req.getParameter("depName");
int i = departmentService.updateDepById(depName, Integer.parseInt(id));
PrintWriter out = resp.getWriter();
if (i == 1) {
out.write("修改成功");
}
}
/**
*/
public class AddMeetingRoomServlet extends HttpServlet {
private MeetingRoomService meetingRoomService = new MeetingRoomService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String roomid = req.getParameter("roomid");
String roomnum = req.getParameter("roomnum");
String roomname = req.getParameter("roomname");
String capacity = req.getParameter("capacity");
String status = req.getParameter("status");
String description = req.getParameter("description");
MeetingRoom meetingRoom = new MeetingRoom(Integer.parseInt(roomnum), roomname, Integer.parseInt(capacity), Integer.parseInt(status), description);
if (roomid == null || "".equals(roomid)) {
//添加会议室
int result = meetingRoomService.insert(meetingRoom);
if (result == 1) {
//去查看会议室页面
resp.sendRedirect(req.getContextPath() + "/getallmr");
} else {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mt7 = meetingService.getMeeting7Days(loginEmpId);
List<Meeting> cm = meetingService.getCanceledMeeting(loginEmpId);
req.setAttribute("mt7", mt7);
req.setAttribute("cm", cm);
req.getRequestDispatcher("/notifications.jsp").forward(req, resp);
}
}
/**
*/
public class UpdateEmpStatusServlet extends HttpServlet {
private EmployeeService employeeService = new EmployeeService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String status = req.getParameter("status");
String empid = req.getParameter("empid");
int i = employeeService.updateEmpStatusById(Integer.parseInt(empid), Integer.parseInt(status));
if (i == 1) {
resp.sendRedirect(req.getContextPath() + "/approveaccount");
} else {
req.setAttribute("error", "审批失败");
req.getRequestDispatcher("/approveaccount").forward(req, resp);
}
}
}
String status = req.getParameter("status");
String description = req.getParameter("description");
MeetingRoom meetingRoom = new MeetingRoom(Integer.parseInt(roomnum), roomname, Integer.parseInt(capacity), Integer.parseInt(status), description);
if (roomid == null || "".equals(roomid)) {
//添加会议室
int result = meetingRoomService.insert(meetingRoom);
if (result == 1) {
//去查看会议室页面
resp.sendRedirect(req.getContextPath() + "/getallmr");
} else {
req.setAttribute("error", "添加失败");
req.getRequestDispatcher("/addmeetingroom.jsp").forward(req, resp);
}
} else {
//修改会议室
meetingRoom.setRoomid(Integer.parseInt(roomid));
int update = meetingRoomService.update(meetingRoom);
if (update == 1) {
resp.sendRedirect(req.getContextPath() + "/getallmr");
}else{
//更新失败
}
}
}
}
public class ChangePasswordServlet extends HttpServlet {
private EmployeeService employeeService = new EmployeeService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
String oldPassword = req.getParameter("oldPassword");
String newPassword = req.getParameter("newPassword");
if (StringUtils.isEmptyOrWhitespaceOnly(oldPassword)||StringUtils.isEmptyOrWhitespaceOnly(newPassword)){
req.setAttribute("error", "密码不能为空");
req.getRequestDispatcher("/changepassword.jsp").forward(req, resp);
}
Employee employee = employeeService.getEmpByID(loginEmpId);
if (!employee.getPassword().equals(oldPassword)){
req.setAttribute("error", "旧密码不正确");
req.getRequestDispatcher("/changepassword.jsp").forward(req, resp);
}
int i = employeeService.changeEmpPWDById(loginEmpId,newPassword);
if (i == 1){
req.getRequestDispatcher("/login.jsp").forward(req, resp);
}else {
req.setAttribute("error", "修改失败");
req.getRequestDispatcher("/changepassword.jsp").forward(req, resp);
}
}
}
/**
*/
/**
*/
public class MyBookingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mrs = meetingService.getMyBookingMeeting(loginEmpId);
req.setAttribute("mrs", mrs);
req.getRequestDispatcher("/mybookings.jsp").forward(req, resp);
}
}
/**
*/
public class MyMeetingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> list = meetingService.getMyMeeting(loginEmpId);
req.setAttribute("mrs", list);
req.getRequestDispatcher("/mymeetings.jsp").forward(req, resp);
req.getRequestDispatcher("/reg").forward(req, resp);
} else {
req.setAttribute("error", "不明原因,注册失败");
req.getRequestDispatcher("/reg").forward(req, resp);
}
}
}
/**
*/
public class PermissFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) request;
String servletPath = req.getServletPath();
if ("/login.jsp".equals(servletPath) || "/reg".equals(servletPath) || "/doreg".equals(servletPath) || "/login".equals(servletPath) || servletPath.contains("/images/") || servletPath.contains("/js/") || servletPath.contains("/My97DatePicker/") || servletPath.contains("/styles/")) {
chain.doFilter(req, response);
} else {
Object loginUser = req.getSession().getAttribute("loginUser");
if (loginUser == null) {
((HttpServletResponse) response).sendRedirect(req.getContextPath() + "/login.jsp");
} else {
chain.doFilter(req, response);
}
}
}
@Override
public void destroy() {
}
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mrs = meetingService.getMyBookingMeeting(loginEmpId);
req.setAttribute("mrs", mrs);
req.getRequestDispatcher("/mybookings.jsp").forward(req, resp);
}
}
/**
*/
public class MyMeetingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> list = meetingService.getMyMeeting(loginEmpId);
req.setAttribute("mrs", list);
}
/**
*/
public class UpdateDepServlet extends HttpServlet {
private DepartmentService departmentService = new DepartmentService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/html;charset=utf-8");
String id = req.getParameter("id");
String depName = req.getParameter("depName");
int i = departmentService.updateDepById(depName, Integer.parseInt(id));
PrintWriter out = resp.getWriter();
if (i == 1) {
out.write("修改成功");
} else {
out.write("修改失败");
}
}
}
String password = req.getParameter("password");
String phone = req.getParameter("phone");
String email = req.getParameter("email");
String deptid = req.getParameter("deptid");
Employee employee = new Employee(employeename, accountname, phone, email, Integer.parseInt(deptid), password);
int reg = employeeService.reg(employee);
if (reg == 1) {
//注册成功,跳转到登录页面
resp.sendRedirect(req.getContextPath() + "/login.jsp");
} else if (reg == -1) {
//用户名重复,注册失败
req.setAttribute("error", "用户名重复,注册失败");
req.getRequestDispatcher("/reg").forward(req, resp);
} else {
req.setAttribute("error", "不明原因,注册失败");
req.getRequestDispatcher("/reg").forward(req, resp);
}
}
}
/**
*/
public class PermissFilter implements Filter {
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) request;
String servletPath = req.getServletPath();
if ("/login.jsp".equals(servletPath) || "/reg".equals(servletPath) || "/doreg".equals(servletPath) || "/login".equals(servletPath) || servletPath.contains("/images/") || servletPath.contains("/js/") || servletPath.contains("/My97DatePicker/") || servletPath.contains("/styles/")) {
chain.doFilter(req, response);
} else {
Object loginUser = req.getSession().getAttribute("loginUser");
if (loginUser == null) {
((HttpServletResponse) response).sendRedirect(req.getContextPath() + "/login.jsp");
} else {
chain.doFilter(req, response);
}
}
}
@Override
public void destroy() {
*/
public class MyBookingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mrs = meetingService.getMyBookingMeeting(loginEmpId);
req.setAttribute("mrs", mrs);
req.getRequestDispatcher("/mybookings.jsp").forward(req, resp);
}
}
/**
*/
public class MyMeetingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
/**
*/
public class MyBookingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
int loginEmpId = ((Employee) req.getSession().getAttribute("loginUser")).getEmployeeid();
List<Meeting> mrs = meetingService.getMyBookingMeeting(loginEmpId);
req.setAttribute("mrs", mrs);
req.getRequestDispatcher("/mybookings.jsp").forward(req, resp);
}
}
/**
*/
public class MyMeetingServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
@Override
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
HttpServletRequest req = (HttpServletRequest) request;
String servletPath = req.getServletPath();
if ("/login.jsp".equals(servletPath) || "/reg".equals(servletPath) || "/doreg".equals(servletPath) || "/login".equals(servletPath) || servletPath.contains("/images/") || servletPath.contains("/js/") || servletPath.contains("/My97DatePicker/") || servletPath.contains("/styles/")) {
chain.doFilter(req, response);
} else {
Object loginUser = req.getSession().getAttribute("loginUser");
if (loginUser == null) {
((HttpServletResponse) response).sendRedirect(req.getContextPath() + "/login.jsp");
} else {
chain.doFilter(req, response);
}
}
}
@Override
public void destroy() {
}
}
/**
*/
public class MeetingDetailsServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
/**
*/
public class MeetingDetailsServlet extends HttpServlet {
private MeetingService meetingService = new MeetingService();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doPost(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String mid = req.getParameter("mid");
String type = req.getParameter("type");
Meeting meeting = meetingService.getMeetingDetailsByMeetingId(Integer.parseInt(mid));
List<Employee> emps = meetingService.getEmps();
req.setAttribute("mt", meeting);
req.setAttribute("emps", emps);
req.setAttribute("type", type);
req.getRequestDispatcher("/meetingdetails.jsp").forward(req, resp);
}
}
/**