javaweb开发酒店管理系统总结报告

课程设计报告书 班级 软件 1201 学号 02240120112 姓名 李明坤 学号 02240120109 姓名 顾敬程 学号 02240120102 姓名 曹笑诚 目录 一 设计内容 1 设计课题 2 设计目的 3 小组分工 4 程序代码 5 效果截图 6 总结感受 二 设计步骤 1.设计课题：红酒公司管理系统 2.设计目的：管理员的登录，然后实现酒店管理员对本酒店 VIP 客户，酒品及 员工的增删改查功能，以及分页功能。酒品的模糊搜索和备注功能。 以及有一个 Filter。 3.小组分工：顾敬程：管理员的登录，然后实现酒店管理员对本酒店酒品的增 删改查功能，以及分页功能，酒品的模糊搜索和备注功能，能够在 当前取得管理员名字与备注内容一起显示，和一个 Filter。 李明坤：实现酒店管理员对本酒店 VIP 客户的增删改查功能，以 及分页功能，图片的查找，JSP 美化。 曹笑诚：实现酒店管理员对本酒店员工的增删改查功能，以及分页 功能，首页的设计。 4.程序部分主要代码： Jsp 页面： （1） 欢迎界面： 登录 （2）登录页面 $requestScope.msg 管 理 员 登 录 页 面 管理员 ： 密码： （3）首页面 vip管理 酒品管理 员工管理 返回登录 Search （4）vip 管理 进入页面 查看所有VIP 信息 返回首页 显示页面 显示vip 信息 用户ID 用户名 vip卡号 修改操作 删除操作 $u.id $u.username $u.password 修改 删除 当前页： 总记录数：$pageBean.totalCount条 共有 $pageBean.totalPage页 上一页 下一页 最后一页 修改页面 修改卡号 vipID: Vip名: vip原卡号: vip新卡号: 增添页面 请输入vip名: 请输入您卡号: （4）酒品管理 进入页面 查看所有酒品信息 返回主页 显示页面 显示酒品信息 酒品ID 酒名 酒品图片 酒品介绍 酒品价格 酒品本周得分 修改操作 删除操作 $u.id $u.cpname $u.cpintroduce $u.cpprice $u.cpflid 修改 删 除 当前页： 总记录数：$pageBean.totalCount条 共有 $pageBean.totalPage页 上一页 下一页 最后一页 修改页面 修 改 酒 品 酒品ID: 酒品新名: 酒品新介绍: 酒品新图片路径: 酒品原价格: 酒品新价格: 酒品原得分 酒品新得分: 增添页面 添 加 一 个 酒品 请输入酒品名 : 请输入酒介绍: 请输入酒图片: 请输入酒价格: 请输酒品得分: 搜索显示+备注功能+备注显示 图片： 价格：$u.cpprice 简介 ：$u.cpintroduce id:$u.id 备注内容 ： 备注内容 ：$c.cpplcontent 管理员 $c.cpplusername （5）员工管理 进入页面 查看所有员工信息 返回主页 显示页面 显示员工信息 员工ID 用户名 员工电话 修改操作 删除操作 $u.id $u.username $u.password 修改 删除 添加新员工 返回主页 当前页： 总记录数：$pageBean.totalCount条 共有 $pageBean.totalPage页 上一页 下一页 最后一页 修改页面 修改员工信息 用户ID: 用户名: 员工原电话: 员工新电话: 增添页面 添加一个新员工 请输入员工名 : 请输入您电话 : 后台： （1） Filter public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws IOException, ServletException HttpServletRequest request = (HttpServletRequest) req; HttpServletResponse response = (HttpServletResponse) resp; HttpSession session = request.getSession(); if (null != session.getAttribute(“manager“) chain.doFilter(request, response); else request.setAttribute(“msg“, “您没有权限访问！“); request.getRequestDispatcher(“/index.jsp“).forward(request,resp onse); public void init(FilterConfig arg0) throws ServletException System.out.println(“log-init“); （2） Servlet vip /增添vip private void inserttwo(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String username=request.getParameter(“username“); String password=request.getParameter(“password“); User user=new User(); user.setUsername(username); user.setPassword(password); int b=us.inserttwo(user); listPage(request, response); /分页 private void listPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub String pageNoStr = request.getParameter(“pageNo“); if (pageNoStr != null) pageNo = Integer.valueOf(pageNoStr); PageBean pageBean = new PageBean(); List list = us.listPage(null, pageNo, pageSize); pageBean.setData(list); pageBean.setPageNo(pageNo); pageBean.setPageSize(pageSize); pageBean.setTotalCount(us.count(); request.setAttribute(“pageBean“, pageBean); request.getRequestDispatcher(“xsUser.jsp“).forward(request, response); / 删除一个vip信息 private void deleteOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub int id = Integer.parseInt(request.getParameter(“userid“); us.deleteOne(id); / findAll(request, response); listPage(request, response); / 修改一个vip的密码 private void updateOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub int id = / Integer.parseInt(request.getParameter(“userid“); int id = Integer.parseInt(request.getParameter(“userid“); String username = request.getParameter(“username“); / String oldpwd=request.getParameter(“oldpwd“); String newpwd = request.getParameter(“newpwd“); User user = new User(); user.setPassword(newpwd); user.setUsername(username); us.updateOne(user, id); / findAll(request, response); listPage(request, response); / 查询全部vip信息 private void findAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub List list = us.findAll(); request.setAttribute(“list“, list); request.getRequestDispatcher(“xsUser.jsp“).forward(request, response); 酒品 /分页 private void listPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException String pageNoStr = request.getParameter(“pageNo“); if (pageNoStr != null) pageNo = Integer.valueOf(pageNoStr); PageBean pageBean = new PageBean(); List list = us.listPage(null, pageNo, pageSize); pageBean.setData(list); pageBean.setPageNo(pageNo); pageBean.setPageSize(pageSize); pageBean.setTotalCount(us.count(); request.setAttribute(“pageBean“, pageBean); request.getRequestDispatcher(“xsProduct.jsp“).forward(request, response); / 删除一个酒品信息 private void deleteOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException int id = Integer.parseInt(request.getParameter(“cpid“); us.deleteOne(id); / findAll(request, response); listPage(request, response); / 修改一个酒品信息 private void updateOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub int id = Integer.parseInt(request.getParameter(“cpid“); String newcpname = request.getParameter(“newcpname“); String newcpintroduce = request.getParameter(“newcpintroduce“); String newcppicture = request.getParameter(“newcppicture“); String newcpflid = request.getParameter(“newcpflid“); String newcpprice = request.getParameter(“newcpprice“); Product cp = new Product(); cp.setCpintroduce(newcpintroduce); cp.setCppicture(newcppicture); cp.setCpprice(newcpprice); cp.setCpflid(newcpflid); cp.setCpname(newcpname); us.updateOne(cp,id); / findAll(request, response); listPage(request, response); / 添加一个酒品信息 private void insertOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException String cpname = request.getParameter(“cpname“); String cpintroduce = request.getParameter(“cpintroduce“); String cppicture = request.getParameter(“cppicture“); String cpprice = request.getParameter(“cpprice“); String cpflid = request.getParameter(“cpflid“); Product cp = new Product(); cp.setCpintroduce(cpintroduce); cp.setCpname(cpname); cp.setCppicture(cppicture); cp.setCpprice(cpprice); cp.setCpflid(cpflid); int b = us.insertOne(cp); / findAll(request, response); listPage(request, response); / 查询全部酒品信息 public void findAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException List list = us.findAll(); request.setAttribute(“list“, list); request.getRequestDispatcher(“xsProduct.jsp“).forward(request, response); /搜索菜品信息 public void findAll10(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException String sscpname =request.getParameter(“sscpname“); List list=us.findAll10(sscpname); request.setAttribute(“list“, list); request.getRequestDispatcher(“cp3.jsp“).forward(request, response); /搜索后提取备注和菜品信息 private void findOne(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException int id=Integer.parseInt(request.getParameter(“cpid“); List list=us.findOne(id); request.setAttribute(“list“, list); List cppllist= cs.findOne(id); request.setAttribute(“cppllist“, cppllist); request.getRequestDispatcher(“cp3.jsp“).forward(request, response); /添加一个备注信息并获取管理员名字 Private void insertOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException HttpSession session = request.getSession(); String cpplcontent = request.getParameter(“cpplcontent“); if (null != session.getAttribute(“user“) String cpplusername = (Manager)session.getAttribute(“manager“).getManagername(); else int cpplflid=Integer.parseInt(request.getParameter(“cpplid“); Cppl cppl = new Cppl(); cppl.setCpplcontent(cpplcontent); cppl.setCpplusername(cpplusername); cppl.setCpplflid(cpplflid); int b = us.insertOne(cppl); findOne(request, response); 员工 /增加员工 private void inserttwo(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String username=request.getParameter(“username“); String password=request.getParameter(“password“); Message message=new Message(); message.setUsername(username); message.setPassword(password); int b=us.inserttwo(message); listPage(request, response); private void listPage(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub String pageNoStr = request.getParameter(“pageNo“); if (pageNoStr != null) pageNo = Integer.valueOf(pageNoStr); PageBean pageBean = new PageBean(); List list = us.listPage(null, pageNo, pageSize); pageBean.setData(list); pageBean.setPageNo(pageNo); pageBean.setPageSize(pageSize); pageBean.setTotalCount(us.count(); request.setAttribute(“pageBean“, pageBean); request.getRequestDispatcher(“xsMessage.jsp“).forward(request, response); / 删除一个员工信息 private void deleteOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub int id = Integer.parseInt(request.getParameter(“userid“); us.deleteOne(id); / findAll(request, response); listPage(request, response); / 修改一个员工的密码 private void updateOne(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub int id = / Integer.parseInt(request.getParameter(“userid“); int id = Integer.parseInt(request.getParameter(“userid“); String username = request.getParameter(“username“); / String oldpwd=request.getParameter(“oldpwd“); String newpwd = request.getParameter(“newpwd“); Message message = new Message(); message.setPassword(newpwd); message.setUsername(username); us.updateOne(message, id); / findAll(request, response); listPage(request, response); / 查询全部员工信息 private void findAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException / TODO Auto-generated method stub List list = us.findAll(); request.setAttribute(“list“, list); request.getRequestDispatcher(“xsMessage.jsp“).forward(request, response); 管理员 private void managerLogin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException HttpSession session = request.getSession(); String managerName = request.getParameter(“managername“); String passWord = request.getParameter(“password“); Manager manager = us.managerLogin(managerName, passWord); if (manager != null) session.setAttribute(“manager“, manager); request.getRequestDispatcher(“manager/manager.jsp“).forward(reque st, response); else request.setAttribute(“msg“, “用户名和密码不正确！请输入用户名与 密码！“); request.getRequestDispatcher(“managerLogin.jsp“).forward(request, response); （3） Dao.Impl Vip /查询 public List findAll() Connection conn=JdbcUti.getInstance().getConn(); String sql=“select * from usertab11“; List list=new ArrayList(); Statement stmt=null; ResultSet rs=null; try stmt=conn.createStatement(); rs=stmt.executeQuery(sql); while(rs.next() User user=new User(); user.setId(rs.getInt(“id“); user.setUsername(rs.getString(“username“); user.setPassword(rs.getString(“password“); list.add(user); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, stmt, rs); return list; / 删除一个vip public int deleteOne(int id) Connection conn=JdbcUti.getInstance().getConn(); String sql=“delete from usertab11 where id=?“; PreparedStatement pstmt=null; ResultSet rs=null; int b=0; try pstmt=conn.prepareStatement(sql); pstmt.setInt(1, id); b=pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; / 修改一个vip public int updateOne(User user, int id) Connection conn=JdbcUti.getInstance().getConn(); String sql=“update usertab11 set password=? where id=?“; PreparedStatement pstmt=null; ResultSet rs=null; int b=0; try pstmt=conn.prepareStatement(sql); pstmt.setString(1, user.getPassword(); pstmt.setInt(2, id); b=pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; /分页总数 public int count() Connection conn = JdbcUti.getInstance().getConn(); String sql = “select count(*) from usertab11“; PreparedStatement pstmt = null; ResultSet rs = null; int b = 0; try pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if (rs.next() b = rs.getInt(1); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; /分页 public List listPage(String sql, int pageNo, int pageSize) Connection conn = JdbcUti.getInstance().getConn(); List list = new ArrayList(); Statement stmt = null; ResultSet rs = null; int pagePos = (pageNo - 1) * pageSize; if (sql = null) sql = “select * from usertab11 order by id limit “ + pagePos + “,“ + pageSize; try stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next() User user = new User(); user.setId(rs.getInt(“id“); user.setUsername(rs.getString(“username“); user.setPassword(rs.getString(“password“); list.add(user); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, stmt, rs); return list; /增加vip public int inserttwo(User user) Connection conn=JdbcUti.getInstance().getConn(); String sql=“insert into usertab11 (username,password) values(?,?)“; PreparedStatement pstmt=null; ResultSet rs=null; int b=0; try pstmt=conn.prepareStatement(sql); pstmt.setString(1, user.getUsername(); pstmt.setString(2, user.getPassword(); b=pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUtil.getInstance().free(conn, pstmt, rs); return b; 酒品 /查询 public List findAll() Connection conn = JdbcUti.getInstance().getConn(); String sql = “select * from usertab1“; List list = new ArrayList(); Statement stmt = null; ResultSet rs = null; try stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next() Product cp = new Product(); cp.setId(rs.getInt(“id“); cp.setCpname(rs.getString(“cpname“); cp.setCppicture(rs.getString(“cppicture“); cp.setCpprice(rs.getString(“cpprice“); cp.setCpflid(rs.getString(“cpflid“); cp.setCpintroduce(rs.getString(“cpintroduce“); list.add(cp); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, stmt, rs); return list; / 添加酒品 public int insertOne(Product cp) Connection conn = JdbcUti.getInstance().getConn(); String sql = “insert into usertab1(cpname,cpintroduce,cppicture,cpprice,cpflid) values (?,?,?,?,?)“; PreparedStatement pstmt = null; ResultSet rs = null; int b = 0; try pstmt = conn.prepareStatement(sql); pstmt.setString(1, cp.getCpname(); pstmt.setString(2, cp.getCpintroduce(); pstmt.setString(3, cp.getCppicture(); pstmt.setString(4, cp.getCpprice(); pstmt.setString(5, cp.getCpflid(); b = pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; / 删除一个酒品 public int deleteOne(int id) Connection conn = JdbcUti.getInstance().getConn(); String sql = “delete from usertab1 where id=?“; PreparedStatement pstmt = null; ResultSet rs = null; int b = 0; try pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); b = pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; / 修改一个酒品 public int updateOne(Product cp, int id) Connection conn = JdbcUti.getInstance().getConn(); String sql = “update usertab1 set cpname=?,cpintroduce=?,cppicture=?,cpprice=?,cpflid=? where id=?“; PreparedStatement pstmt = null; ResultSet rs = null; int b = 0; try pstmt = conn.prepareStatement(sql); pstmt.setString(1, cp.getCpname(); pstmt.setString(2, cp.getCpintroduce(); pstmt.setString(3, cp.getCppicture(); pstmt.setString(4, cp.getCpprice(); pstmt.setString(5, cp.getCpflid(); pstmt.setInt(6, id); b = pstmt.executeUpdate(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; /总数 public int count() Connection conn = JdbcUti.getInstance().getConn(); String sql = “select count(*) from usertab1“; PreparedStatement pstmt = null; ResultSet rs = null; int b = 0; try pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if (rs.next() b = rs.getInt(1); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); finally JdbcUti.getInstance().free(conn, pstmt, rs); return b; /分页 public List listPage(String sql, int pageNo, int pageSize) Connection conn = JdbcUti.getInstance().getConn(); List list = new ArrayList(); Statement stmt = null; ResultSet rs = null; int pagePos = (pageNo - 1) * pageSize; if (sql = null) sql = “select * from usertab1 order by id limit “ + pagePos + “,“ + pageSize; try stmt = conn.createStatement(); rs = stmt.executeQuery(sql); while (rs.next() Product cp = new Product(); cp.setId(rs.getInt(“id“); cp.setCpname(rs.getString(“cpname“); cp.setCppicture(rs.getString(“cppicture“); cp.setCpprice(rs.getString(“cpprice“); cp.setCpflid(rs.getString(“cpflid“); cp.setCpintroduce(rs.getString(“cpintroduce“); list.add(cp); catch (SQLException e) / TODO Auto-generated catch block