课程设计报告书

班级 软件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卡号 修改操作 删除操作

  var=https://www.bwwdw.com/plus/\>

  ${u.id } ${u.username} ${u.password}

  href=https://www.bwwdw.com/plus/\${u.id }&username=${u.username}&passw

  ord=${u.password}https://www.bwwdw.com/plus/\>修改 删除

  当前页：

  value=https://www.bwwdw.com/plus/\${pageBean.pageNo}https://www.bwwdw.com/plus/\ /> 总记录数：${pageBean.totalCount}条

     

  共有 ${pageBean.totalPage}页

  href=https://www.bwwdw.com/plus/\${pageBean.pageNo - 1}https://www.bwwdw.com/plus/\>上一页

  href=https://www.bwwdw.com/plus/\${pageBean.pageNo + 1}https://www.bwwdw.com/plus/\>下一页

  href=https://www.bwwdw.com/plus/\${pageBean.totalPage}https://www.bwwdw.com/plus/\>最后一页

  ③修改页面

  修改卡号

  
  

  vipID:

  readonly=\ />
  

  Vip名:

  readonly=\ />

  value=\${param.username }\

  
  

  vip原卡号:

  readonly=\ />
  

  vip新卡号:

  
  

     

       

   

  ④增添页面

  ④增添页面

  添 加 一 个

  酒品

  
  

  
  

  请输入酒介绍:

  name=\ />

  response);

  }

  ② 酒品 //分页

  private void listPage(HttpServletRequest request,

  // 修改一个酒品信息

  private void updateOne(HttpServletRequest request,

  HttpServletResponse response) throws ServletException,

  // 删除一个酒品信息

  private void deleteOne(HttpServletRequest request, }

  HttpServletResponse response) throws ServletException,

  }

  request.getRequestDispatcher(\).forward(request,

  response);

  request.setAttribute(\, pageBean);

  HttpServletResponse response) throws ServletException,

  IOException {

  String pageNoStr = request.getParameter(\); if (pageNoStr != null) { }

  PageBean pageBean = new PageBean(); List list = us.listPage(null, pageNo, pageSize); pageBean.setData(list); pageBean.setPageNo(pageNo); pageBean.setPageSize(pageSize); pageBean.setTotalCount(us.count());

  pageNo = Integer.valueOf(pageNoStr);

  IOException {

  int id = Integer.parseInt(request.getParameter(\)); us.deleteOne(id);

  // findAll(request, response); listPage(request, response);

  IOException {

  // TODO Auto-generated method stub

  int id = Integer.parseInt(request.getParameter(\)); String newcpname = request.getParameter(\);

  String newcpintroduce = request.getParameter(\);

  }

  String newcppicture = request.getParameter(\); String newcpflid = request.getParameter(\); String newcpprice = request.getParameter(\); 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, }

  // 查询全部酒品信息

  public void findAll(HttpServletRequest request, HttpServletResponse

  throws ServletException, IOException {

  HttpServletResponse response) throws ServletException,

  IOException {

  String cpname = request.getParameter(\);

  String cpintroduce = request.getParameter(\); String cppicture = request.getParameter(\); String cpprice = request.getParameter(\); String cpflid = request.getParameter(\); 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);

  response)

  List list = us.findAll(); request.setAttribute(\, list);

  }

  request.getRequestDispatcher(\).forward(request,

  response);

  //搜索菜品信息

  public void findAll10(HttpServletRequest request, HttpServletResponse response)

  //搜索后提取备注和菜品信息 private void findOne(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {

  }

  //添加一个备注信息并获取管理员名字 Private void insertOne(HttpServletRequest request,

  HttpServletResponse response) throws ServletException,

  IOException {

  HttpSession session = request.getSession();

  String cpplcontent = request.getParameter(\); if (null != session.getAttribute(\)) { String cpplusername = } else { }

  int

  int id=Integer.parseInt(request.getParameter(\)); List list=us.findOne(id); request.setAttribute(\, list);

  List cppllist= cs.findOne(id);

  request.setAttribute(\, cppllist);

  request.getRequestDispatcher(\).forward(request, throws ServletException, IOException { }

  String sscpname =request.getParameter(\); List list=us.findAll10(sscpname); request.setAttribute(\, list);

  request.getRequestDispatcher(\).forward(request,

  response);

  response);

  ((Manager)session.getAttribute(\)).getManagername();

  cpplflid=Integer.parseInt(request.getParameter(\));

  }}

  Cppl cppl = new Cppl();

  cppl.setCpplcontent(cpplcontent); cppl.setCpplusername(cpplusername); cppl.setCpplflid(cpplflid); findOne(request, response);

  int b = us.insertOne(cppl);

  ③ 员工

  //增加员工 private void inserttwo(HttpServletRequest request,

  request.getRequestDispatcher(\).forward(request,

  response);

  request.setAttribute(\, pageBean); private void listPage(HttpServletRequest request,

  HttpServletResponse response) throws ServletException,

  }

  HttpServletResponse response)throws ServletException,

  IOException {

  String username=request.getParameter(\); String password=request.getParameter(\); Message message=new Message(); message.setUsername(username); message.setPassword(password); int b=us.inserttwo(message); listPage(request, response);

  IOException {

  // TODO Auto-generated method stub

  String pageNoStr = request.getParameter(\); if (pageNoStr != null) { }

  PageBean pageBean = new PageBean(); List list = us.listPage(null, pageNo, pageSize); pageBean.setData(list); pageBean.setPageNo(pageNo); pageBean.setPageSize(pageSize); pageBean.setTotalCount(us.count());

  pageNo = Integer.valueOf(pageNoStr);

  }

  }

  // 查询全部员工信息

  private void findAll(HttpServletRequest request, }

  HttpServletResponse response) throws ServletException, us.updateOne(message, id); // findAll(request, response); listPage(request, response);

  // 修改一个员工的密码

  private void updateOne(HttpServletRequest request,

  HttpServletResponse response) throws ServletException,

  }

  // 删除一个员工信息

  private void deleteOne(HttpServletRequest request,

  HttpServletResponse response) throws ServletException,

  }

  IOException {

  // TODO Auto-generated method stub

  int id = Integer.parseInt(request.getParameter(\)); us.deleteOne(id);

  // findAll(request, response); listPage(request, response);

  IOException {

  // TODO Auto-generated method stub int id =

  // Integer.parseInt(request.getParameter(\ int id = Integer.parseInt(request.getParameter(\)); String username = request.getParameter(\); // String oldpwd=request.getParameter(\ String newpwd = request.getParameter(\); Message message = new Message(); message.setPassword(newpwd); message.setUsername(username);

  IOException {

  // TODO Auto-generated method stub List list = us.findAll(); request.setAttribute(\, list);

  request.getRequestDispatcher(\).forward(request,

  response);

  本文来源：https://www.bwwdw.com/article/tcah.html