网上订餐系统__后台实体与前台界面的链接.doc

此文档中包含实现后台数据库和前台页面显示之间的联系方法，具体代码和功能如下：Dish_copyServlet.java文件：管理员对美食的管理方法package com.dingcan.servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.dingcan.javabean.DishBean;import com.dingcan.javabean.Dish_copy;import com.dingcan.javabean.Dish_copyBean;SuppressWarnings(serial)public class Dish_copyServlet extends HttpServletprotected void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException doGet(request, response);protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException String method = (String)request.getParameter(method);if(method=null) PrintWriter out = response.getWriter();out.println(invalid request!);else if(method.equals(xiangqing) Xiangqing(request, response);else if(method.equals(select) Select(request, response);else if(method.equals(type) Type(request, response);else if(method.equals(shangjia) Shangjia(request, response);else if(method.equals(xiajia) Xiajia(request, response); /管理员按菜系搜索public void Type(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionString Type_Name1 = request.getParameter(Type_Name); if (Type_Name1= null | Type_Name1=) response.sendRedirect(admin_center.jsp);return;elseString Type_Name = new String(Type_Name1.getBytes(ISO8859_1),utf-8); DishBean dishBean=new DishBean(); boolean isExist = dishBean.isExist(Type_Name,3); if(isExist) HttpSession session = request.getSession(); session.setAttribute(Type_Name, Type_Name); response.sendRedirect(zhanting.jsp); return; /管理员按菜名搜索public void Select(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionString Dish_Name1 = request.getParameter(Dish_Name); if (Dish_Name1= null | Dish_Name1=) response.sendRedirect(admin_center.jsp);return;elseString Dish_Name = new String(Dish_Name1.getBytes(ISO8859_1),utf-8); DishBean dishBean=new DishBean(); boolean isExist = dishBean.isExist(Dish_Name,2); if(isExist) HttpSession session = request.getSession(); session.setAttribute(Dish_Name, Dish_Name); response.sendRedirect(xiangqing1.jsp); return; /菜的详细信息public void Xiangqing(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String Dish_ID = request.getParameter(Dish_ID); if (Dish_ID= null ) response.sendRedirect(admin_center.jsp);return; Dish_copyBean dish_copyBean=new Dish_copyBean(); boolean isExist = dish_copyBean.isExist(Dish_ID,1); if(isExist) Dish_copy dish= dish_copyBean.getDish_copy(Dish_ID); HttpSession session = request.getSession(); session.setAttribute(Dish_ID, Dish_ID); session.setAttribute(Dish_Name, dish.getDish_Name(); session.setAttribute(Price, dish.getPrice(); session.setAttribute(Url, dish.getUrl(); session.setAttribute(Type_ID, dish.getType_ID(); session.setAttribute(shangjia, dish.getshangjia(); response.sendRedirect(xiangqing1.jsp); return; /商品上架public void Shangjia(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session = request.getSession();String Dish_ID=(String) session.getAttribute(Dish_ID);String Dish_Name=(String) session.getAttribute(Dish_Name);String Price=(String) session.getAttribute(Price);String Url=(String) session.getAttribute(Url);String Type_ID=(String) session.getAttribute(Type_ID);Dish_copyBean dish_copyBean=new Dish_copyBean();dish_copyBean.add(Dish_ID, Dish_Name, Price, Url, Type_ID);dish_copyBean.jia(Dish_ID,1);response.sendRedirect(xiangqing1.jsp);return;/商品下架public void Xiajia(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionHttpSession session = request.getSession();String Dish_ID=(String) session.getAttribute(Dish_ID);Dish_copyBean dish_copyBean=new Dish_copyBean();dish_copyBean.del(Dish_ID);dish_copyBean.jia(Dish_ID,0);response.sendRedirect(xiangqing1.jsp);return;DishServlet.java文件：客户对美食的操作方法package com.dingcan.servlet;import java.io.IOException;import java.io.PrintWriter;import java.io.UnsupportedEncodingException;import java.util.*;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import org.json.JSONArray;import com.dingcan.javabean.Car;import com.dingcan.javabean.CarBean;import com.dingcan.javabean.Dish;import com.dingcan.javabean.DishBean;import com.dingcan.javabean.OrderBean;import com.dingcan.javabean.Orderdish;import com.dingcan.javabean.User;import com.dingcan.javabean.UserBean;import com.google.gson.Gson;SuppressWarnings(serial)public class DishServlet extends HttpServletprotected void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException doGet(request, response);protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException String method = (String)request.getParameter(method);if(method=null) PrintWriter out = response.getWriter();out.println(invalid request!);else if(method.equals(xiangqing) Xiangqing(request, response);else if(method.equals(select) Select(request, response);else if(method.equals(type) Type(request, response);else if(method.equals(gouwuche) Gouwuche(request, response);else if(method.equals(submitorder) Submitorder(request, response);else if(method.equals(cancel) Cancel(request, response);else if(method.equals(detail) Detail(request, response);/菜的详细信息public void Xiangqing(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String Dish_ID = request.getParameter(Dish_ID); if (Dish_ID= null ) response.sendRedirect(dkcanting.jsp);return; DishBean dishBean=new DishBean(); boolean isExist = dishBean.isExist(Dish_ID,1); if(isExist) Dish dish= dishBean.getDish(Dish_ID); HttpSession session = request.getSession(); session.setAttribute(Dish_ID, Dish_ID); session.setAttribute(Dish_Name, dish.getDish_Name(); session.setAttribute(Price, dish.getPrice(); session.setAttribute(Url, dish.getUrl(); session.setAttribute(Type_ID, dish.getType_ID(); response.sendRedirect(xiangqing.jsp); return; /按菜名搜索public void Select(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionString Dish_Name1 = request.getParameter(Dish_Name); if (Dish_Name1= null | Dish_Name1=) response.sendRedirect(dkcanting.jsp);return;elseString Dish_Name = new String(Dish_Name1.getBytes(ISO8859_1),utf-8); DishBean dishBean=new DishBean(); boolean isExist = dishBean.isExist(Dish_Name,2); if(isExist) HttpSession session = request.getSession(); session.setAttribute(Dish_Name, Dish_Name); response.sendRedirect(xiangqing.jsp); return; /按菜系搜索public void Type(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionString Type_Name1 = request.getParameter(Type_Name); if (Type_Name1= null | Type_Name1=) response.sendRedirect(dkcanting.jsp);return;elseString Type_Name = new String(Type_Name1.getBytes(ISO8859_1),utf-8); DishBean dishBean=new DishBean(); boolean isExist = dishBean.isExist(Type_Name,3); if(isExist) HttpSession session = request.getSession(); session.setAttribute(Type_Name, Type_Name); response.sendRedirect(type.jsp); return; /购物车public void Gouwuche(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionHttpSession session = request.getSession();String Dish_ID=(String) session.getAttribute(Dish_ID); String Type_ID=(String) session.getAttribute(Type_ID);String Dish_Name=(String) session.getAttribute(Dish_Name);String Price=(String) session.getAttribute(Price);String Url=(String) session.getAttribute(Url);String User_ID=(String) session.getAttribute(User_ID);CarBean carBean=new CarBean();carBean.add(Dish_ID, Dish_Name, Price, Url, Type_ID, User_ID);response.sendRedirect(xiangqing.jsp); /取消订单public void Cancel(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException String Dish_ID = request.getParameter(Dish_ID); CarBean carBean=new CarBean(); carBean.delet(Dish_ID); response.sendRedirect(gouwuche.jsp);/提交订单public void Submitorder(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionHttpSession session = request.getSession();String User_ID=(String) session.getAttribute(User_ID);UserBean userBean=new UserBean();boolean isExist = userBean.isExist(User_ID);if(!isExist) List list2=new ArrayList(); CarBean carBean1=new CarBean(); list2 = carBean1.getCar(User_ID); for(int i=0;ilist2.size();i+) carBean1.delet(list2.get(i).getDish_ID(); response.sendRedirect(login.jsp);else CarBean carBean = new CarBean(); List list = carBean.getCar(User_ID); int sumprice1=0; for(int i=0;ilist.size();i+) Car car = list.get(i); sumprice1=sumprice1+Integer.parseInt(car.getPrice(); String sumprice=String.valueOf(sumprice1); OrderBean orderbean=new OrderBean(); String Order_ID = orderbean.insert(User_ID, sumprice); List list1=new ArrayList(); OrderBean orderBean=new OrderBean(); list1 = orderBean.getOrderdish(Order_ID); for(int i=0;ilist1.size();i+) orderbean.add(list1.get(i).getDish_ID(),list1.get(i).getOrder_ID(); List list2=new ArrayList(); CarBean carBean1=new CarBean(); list2 = carBean1.getCar(User_ID); for(int i=0;ilist2.size();i+) carBean1.delet(list2.get(i).getDish_ID(); response.sendRedirect(thanks.jsp); /查看订单详情public void Detail(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionHttpSession session = request.getSession();String Order_ID=request.getParameter(Order_ID);/String Order_ID=new String(Order_ID1.getBytes(ISO8859_1),utf-8);session.setAttribute(Order_ID, Order_ID);response.sendRedirect(orderdetail.jsp);return; OrderServlet.java文件：对订单的操作方法package com.dingcan.servlet;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.dingcan.javabean.OrderBean;SuppressWarnings(serial)public class OrderServlet extends HttpServletprotected void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException doGet(request, response);protected void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException, IOException String method = (String)request.getParameter(method);if(method=null) PrintWriter out = response.getWriter();out.println(invalid request!);else if(method.equals(detail1) Detail1(request, response);else if(method.equals(fahuo) Fahuo(request, response);/菜的详细信息public void Detail1(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionHttpSession session = request.getSession();String Order_ID=request.getParameter(Order_ID);session.setAttribute(Order_ID, Order_ID);response.sendRedirect(detail.jsp);return; /管理员发货public void Fahuo(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOExceptionString Order_ID=request.getParameter(Order_ID);OrderBean orderBean=new OrderBean();orderBean.fahuo(Order_ID);response.sendRedirect(dingdan.jsp);return; UserServlet.java文件：用户的操作package com.dingcan.servlet;import java.io.IOException;import java.io.PrintWriter;import java.io.UnsupportedEncodingException;import java.util.ArrayList;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 javax.servlet.http.HttpSession;import com.google.gson.Gson;import org.json.JSONArray;import com.dingcan.javabean.User;import com.dingcan.javabean.UserBean;SuppressWarnings(serial)public class UserServlet extends HttpServlet protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException doGet(request, response);protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException String method = (String)request.getParameter(method);if(method=null) PrintWriter out = response.getWriter();out.println(invalid request!); else if(method.equals(login) Login(request, response);else if(method.equals(logout) Logout(request, response);else if(method.equals(register) Register(request, response);else if(method.equals(update) Update(request, response);else if(method.equals(update1) Update1(request, response);else if(method.equals(login_admin) Login_admin(request, response);else if(method.equals(logout_admin) Logout_admin(request, response); else if (method.equals(android_login) System.out.println(1111111111);AndroidLogin(request, response); else if (method.equals(getdata) System.out.println(getData);AndroidGetData(request, response);/用户登录protected void Login(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException / get parameters/ 获取网页上的信息/ 这里包括了用户名和密码两项String User_ID1 = request.getParameter(User_ID);String User_ID = new String(User_ID1.getBytes(ISO8859_1),utf-8);String Password = request.getParameter(Password);/ check null/ 校验过程if (User_ID = null | Password = null) / 重定向/ 如果没有输入任何内容的话/ 跳转向登录的页面response.sendRedirect(login.jsp);return;/ validate/ 定义一个数据的操作对象/ DB 层UserBean userBean = new UserBean();/ 检验账号密码boolean isValid = userBean.valid(User_ID, Password,0);/ 根据是否校验成功/ 进行后边的两种操作if (isValid) / 登录成功了/ 通过Session传参数/ 服务器HttpSession session = request.getSession();/ 在Session中设置变量/ 在下一个页面中将会使用到session.setAttribute(User_ID, User_ID);session.setAttribute(User_Name, userBean.getName(User_ID);session.setAttribute(User_Tel, userBean.getTel(User_ID);session.setAttribute(User_Address, userBean.getAddress(User_ID);session.setAttribute(User_Password, userBean.getPassword(User_ID);/ 跳转到welcome界面response.sendRedirect(dkcanting.jsp);return; else / 登录不成功,显示信息并跳转回登录页面System.out.println(登录失败);response.setCharacterEncoding(utf-8);response.sendRedirect(login.jsp);return;/用户登出protected void Logout(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException HttpSession session = request.getSession();session.removeAttribute(User_ID);response.sendRedirect(dkcanting.jsp);/ 注册用户的方法protected void Register(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException / get parameters/ 获取所有需要的变量信息/ 获取页面的用户信息String User_ID1 = request.getParameter(User_ID);String User_ID = new String(User_ID1.getBytes(ISO8859_1),utf-8);/ 获取两个密码的内容String Password1 = request.getParameter(Password1);String Password2 = request.getParameter(Password2);/ 获取电