需求分析

通过MVC+Mysql完成北城投票系统核心功能。用户分为两种类型： 第一种为管理员用户。用户信息通过注册存入到用户表中。通过查询用户表信息，管理用户成功登录后能够添加节目信息，存入节目表中，同时能对节目信息进行增、删、改、查操作。能统计出节目最终得分，并且查询用户表信息。 第二种为普通用户，普通用户成功登录后，能够浏览全部节目信息，进入具体节目后，可以查看节目详情，并对该节目进行评分（分数为1到10）。

详细设计

1．数据库设计 该程序数据库分为用户与节目

用户: -用户id user_id -用户名 user_name -用户密码 user_password -用户类型 user_type（普通用户,管理员）节目: -节目id pro_id -节目名称 pro_name -节目类型 pro_type -节目单位 pro_dan -节目得分 pro_num -节目是否被打分 flag

2．类和功能定义

A.在bean下实体类 Pro，UserB.在control层 对用户的UserC 进行用户的注册和登录，但要分类型管理员与普通用户对项目的ProC 对项目的增删改查，连接jsp与数据库C.在dao层 对用户的Userdao 针对用户的数据库的增加和查询对项目的ProDao 针对项目的数据库增删改查D.在DBUtil层 连接数据库 E.在service层 调用类中的方法 ProC.java package com.bcu.c; import java.io.IOException; import java.io.PrintWriter; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.bcu.bean.Pro; import com.bcu.dao.ProDao; public class ProC extends HttpServlet { public ProC() { super(); } public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); String cmd = request.getParameter("cmd"); if(null==cmd||cmd.equals("select")) { select(request, response); }else if(cmd.equals("update")) { update(request,response); }else if(cmd.equals("add")) { add(request, response); }else if(cmd.equals("delete")) { delete(request,response); }else if(cmd.equals("update1")){ update1(request,response); } } public void update1(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { String pro_id = request.getParameter("pro_id"); System.out.println("pro_id==="+pro_id); String pro_name = request.getParameter("pro_name"); System.out.println("pro_name==="+pro_name); String pro_type = request.getParameter("pro_type"); System.out.println("pro_type==="+pro_type); String pro_per = request.getParameter("pro_per"); System.out.println("pro_per==="+pro_per); String pro_dan = request.getParameter("pro_dan"); String pro_num = request.getParameter("pro_num"); System.out.println("pro_num==="+pro_num); Pro pro = new Pro(); pro.setPro_id(pro_id); pro.setPro_name(pro_name); pro.setPro_type(pro_type); pro.setPro_per(pro_per); pro.setPro_dan(pro_dan); pro.setPro_num(pro_num); pro.setFlag(1); ProDao proDao = new ProDao(); int affCount = proDao.update2(pro); List<Pro> list=proDao.selectAll(); request.setAttribute("list", list); request.getRequestDispatcher("grade.jsp").forward(request, response); } //删除 public void delete(HttpServletRequest request, HttpServletResponse response) throws IOException { String pro_id = request.getParameter("pro_id"); ProDao proDao = new ProDao(); int affCount= proDao.delete(Integer.parseInt(pro_id)); response.sendRedirect("ProC?cmd=select"); } //修改 public void update(HttpServletRequest request, HttpServletResponse response) throws IOException { String pro_id = request.getParameter("pro_id"); System.out.println("pro_id==="+pro_id); String pro_name = request.getParameter("pro_name"); String pro_type = request.getParameter("pro_type"); String pro_per = request.getParameter("pro_per"); String pro_dan = request.getParameter("pro_dan"); String pro_num = request.getParameter("pro_num"); int flag = Integer.parseInt(request.getParameter("flag")); Pro pro = new Pro(); pro.setPro_id(pro_id); pro.setPro_name(pro_name); pro.setPro_type(pro_type); pro.setPro_per(pro_per); pro.setPro_dan(pro_dan); pro.setPro_num(pro_num); pro.setFlag(flag); ProDao proDao = new ProDao(); int affCount = proDao.update(pro); response.sendRedirect("ProC?cmd=select"); } //查询 public void select(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { Pro pro = new Pro(); ProDao proDao = new ProDao(); List<Pro> list=proDao.selectAll(); request.setAttribute("list", list); System.out.println("********"); System.out.println(list.size()); //request.setAttribute("pro", pro); request.getRequestDispatcher("pro-list.jsp").forward(request, response); } //添加 public void add(HttpServletRequest request, HttpServletResponse response) throws IOException{ String pro_id = request.getParameter("pro_id"); System.out.println(pro_id); String pro_name = request.getParameter("pro_name"); String pro_type = request.getParameter("pro_type"); String pro_per = request.getParameter("pro_per"); String pro_dan = request.getParameter("pro_dan"); String pro_num = request.getParameter("pro_num"); Pro pro = new Pro(); pro.setPro_id(pro_id); pro.setPro_name(pro_name); pro.setPro_type(pro_type); pro.setPro_per(pro_per); pro.setPro_dan(pro_dan); pro.setPro_num(pro_num); ProDao proDao = new ProDao(); int affCount=proDao.insert(pro); response.sendRedirect("ProC?cmd=select"); } public void init() throws ServletException { // Put your code here } }

UserC.java

package com.bcu.c; import java.io.IOException; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.bcu.bean.Pro; import com.bcu.bean.User; import com.bcu.dao.ProDao; import com.bcu.service.UserService; public class UserC extends HttpServlet { private static final long serialVersionUID = 1L; private UserService userService=new UserService(); public UserC() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String cmd = request.getParameter("cmd"); if("register".equals(cmd)) { String user_id = request.getParameter("user_id"); String user_name = request.getParameter("user_name"); String user_password = request.getParameter("user_password"); String user_type = request.getParameter("user_type"); User user = new User(user_name,user_password,user_type); request.setAttribute("operation","注册"); int result=userService.insertUser(user); if(result>0) { request.getRequestDispatcher("success.jsp").forward(request, response); }else { request.getRequestDispatcher("failure.jsp").forward(request, response); } } else if("login".equals(cmd)) { String user_name = request.getParameter("user_name"); String user_password = request.getParameter("user_password"); String user_type = request.getParameter("user_type"); User user = userService.querUser(user_name, user_password); if(user != null && user.getUser_password().equals(user_password) && user.getUser_type().equals("管理员")) { request.getRequestDispatcher("ProC?cmd=select").forward(request, response); } else if(user != null && user.getUser_password().equals(user_password) && user.getUser_type().equals("普通用户")) { ProDao proDao = new ProDao(); List<Pro> list=proDao.selectAll(); // Map<String,Pro> pros=new HashMap<>(); // pros=proservlet.pros; //System.out.println("len ="+proservlet.pros.size()); request.setAttribute("list", list); request.getRequestDispatcher("grade.jsp").forward(request, response); //response.sendRedirect("ProServlet?cmd=update1"); } else { request.setAttribute("operation", "登录"); request.getRequestDispatcher("failure.jsp").forward(request, response); } } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

代码链接点击