基于javaweb+mysql的jsp+servlet在线蛋糕商城系统(java+jsp+jdbc+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet在线蛋糕商城系统(java+jsp+jdbc+mysql)
一、项目简述
功能： 主页显示热销商品；所有蛋糕商品展示，可进行商品搜 索；点击商品进入商品详情页，具有立即购买和加入购物 车功能，可增减购买商品数量亦可手动输入（同时验证库 存），热销商品展示。立即购买进入确认订单页面，可选择 已经添加的地址，亦可新增地址。（同时验证库存），可选 择购买哪些商品，可删除不需要的商品。点击结算进入确 认订单页面，确认后提交订单。后台管理：（修改密码 等），商品管理（商品批量添加、上下架等），订单管理。
二、项目运行
环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe （ IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持）
项目技术： JSP + C3P0+ Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload
g.setImage2(item.getString("utf-8"));}else if("stock".equals(fieldName)){g.setStock(Integer.parseInt(item.getString("utf-8")));}else if("typeid".equals(fieldName)){g.setTypeid(Integer.parseInt(item.getString("utf-8")));}else if("pageNumber".equals(fieldName)){pageNumber=Integer.parseInt(item.getString("utf-8"));}else if("type".equals(fieldName)){type = Integer.parseInt(item.getString("utf-8"));}}else {if(item.getInputStream().available()<=0)continue;String fileName = item.getName();fileName = fileName.substring(fileName.lastIndexOf("."));fileName = "/"+new Date().getTime()+fileName;String path = this.getServletContext().getRealPath("/picture")+fileName;InputStream in = item.getInputStream();FileOutputStream out = new FileOutputStream(path);byte[] buffer = new byte[1024];int len=0;while( (len=in.read(buffer))>0 ) {out.write(buffer);}in.close();out.close();//item.delete();String fieldName = item.getFieldName();if("cover".equals(fieldName)){g.setCover("/picture"+fileName);} else if("image1".equals(fieldName)){g.setImage1("/picture"+fileName);} else if("image2".equals(fieldName)){g.setImage2("/picture"+fileName);}}}gService.update(g);request.getRequestDispatcher("/admin/goods_list?pageNumber="+pageNumber+"&type="+type).forward(request, response);} catch (FileUploadException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/**
@WebServlet(name = "user_register",urlPatterns = "/user_rigister")public class UserRegisterServlet extends HttpServlet {private UserService uService = new UserService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {User user = new User();try {BeanUtils.copyProperties(user, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}if(uService.register(user)) {request.setAttribute("msg", "注册成功，请登录！");request.getRequestDispatcher("user_login.jsp").forward(request, response);}else {request.setAttribute("msg", "用户名或邮箱重复，请重新填写！");request.getRequestDispatcher("user_register.jsp").forward(request, response);}}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}
if(request.getParameter("pageNumber") != null) {try {pageNumber=Integer.parseInt(request.getParameter("pageNumber") ) ;}catch (Exception e){}}if(pageNumber<=0)pageNumber=1;Page p = uService.getUserPage(pageNumber);if(p.getTotalPage()==0){p.setTotalPage(1);p.setPageNumber(1);}else {if(pageNumber>=p.getTotalPage()+1){p = uService.getUserPage(pageNumber);}}request.setAttribute("p", p);request.getRequestDispatcher("/admin/user_list.jsp").forward(request, response);}@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {this.doGet(req, resp);}}@WebServlet(name = "admin_user_add",urlPatterns = "/admin/user_add")
private OrderService oService = new OrderService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {Order o = (Order) request.getSession().getAttribute("order");try {BeanUtils.copyProperties(o, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}o.setDatetime(new Date());o.setStatus(2);o.setUser((User) request.getSession().getAttribute("user"));oService.addOrder(o);request.getSession().removeAttribute("order");request.setAttribute("msg", "订单支付成功！");request.getRequestDispatcher("/order_success.jsp").forward(request, response);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}@WebServlet(name = "user_register",urlPatterns = "/user_rigister")public class UserRegisterServlet extends HttpServlet {private UserService uService = new UserService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {User user = new User();
Order o = (Order) request.getSession().getAttribute("order");try {BeanUtils.copyProperties(o, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}o.setDatetime(new Date());o.setStatus(2);o.setUser((User) request.getSession().getAttribute("user"));oService.addOrder(o);request.getSession().removeAttribute("order");request.setAttribute("msg", "订单支付成功！");request.getRequestDispatcher("/order_success.jsp").forward(request, response);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}@WebServlet(name = "user_register",urlPatterns = "/user_rigister")public class UserRegisterServlet extends HttpServlet {private UserService uService = new UserService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {User user = new User();try {BeanUtils.copyProperties(user, request.getParameterMap());
out.close();//item.delete();String fieldName = item.getFieldName();if("cover".equals(fieldName)){g.setCover("/picture"+fileName);} else if("image1".equals(fieldName)){g.setImage1("/picture"+fileName);} else if("image2".equals(fieldName)){g.setImage2("/picture"+fileName);}}}gService.update(g);request.getRequestDispatcher("/admin/goods_list?pageNumber="+pageNumber+"&type="+type).forward(request, response);} catch (FileUploadException e) {// TODO Auto-generated catch blocke.printStackTrace();}}/*** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}}
request.getRequestDispatcher("/order_success.jsp").forward(request, response);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}@WebServlet(name = "user_register",urlPatterns = "/user_rigister")public class UserRegisterServlet extends HttpServlet {private UserService uService = new UserService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {User user = new User();try {BeanUtils.copyProperties(user, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}if(uService.register(user)) {request.setAttribute("msg", "注册成功，请登录！");request.getRequestDispatcher("user_login.jsp").forward(request, response);}else {request.setAttribute("msg", "用户名或邮箱重复，请重新填写！");request.getRequestDispatcher("user_register.jsp").forward(request, response);}}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}else {gService.removeRecommend(id, typeTarget);}request.getRequestDispatcher("/admin/goods_list").forward(request, response);}/*** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}}@WebServlet(name = "admin_user_delete",urlPatterns = "/admin/user_delete")public class AdminUserDeleteServlet extends HttpServlet {private UserService uService = new UserService();/*** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {int id = Integer.parseInt(request.getParameter("id"));boolean isSuccess = uService.delete(id);if(isSuccess) {request.setAttribute("msg", "客户删除成功");}else {request.setAttribute("failMsg", "客户有下的订单，请先删除该客户下的订单，再来删除客户！");}request.getRequestDispatcher("/admin/user_list").forward(request, response);}/*** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}
// -------------------------------------------------------public void contextInitialized(ServletContextEvent sce) {/* This method is called when the com.demo.servlet context isinitialized(when the Web application is deployed). You can initialize com.demo.servlet context related data here.*/sce.getServletContext().setAttribute("typeList",tsService.GetAllType());}public void contextDestroyed(ServletContextEvent sce) {/* This method is invoked when the Servlet Context (the Web application) is undeployed or Application Server shuts down.*/}// -------------------------------------------------------// HttpSessionListener implementation// -------------------------------------------------------public void sessionCreated(HttpSessionEvent se) {/* Session is created. */}public void sessionDestroyed(HttpSessionEvent se) {/* Session is destroyed. */}// -------------------------------------------------------// HttpSessionAttributeListener implementation// -------------------------------------------------------public void attributeAdded(HttpSessionBindingEvent sbe) {/* This method is called when an attribute is added to a session.*/}public void attributeRemoved(HttpSessionBindingEvent sbe) {/* This method is called when an attributeis removed from a session.*/}public void attributeReplaced(HttpSessionBindingEvent sbe) {/* This method is invoked when an attibuteis replaced in a session.*/}}
if("id".equals(fieldName)){g.setId(Integer.parseInt(item.getString("utf-8")));}else if("name".equals(fieldName)){g.setName(item.getString("utf-8"));}else if("price".equals(fieldName)){g.setPrice(Float.parseFloat(item.getString("utf-8")));}else if("intro".equals(fieldName)){g.setIntro(item.getString("utf-8"));}else if("cover".equals(fieldName)){g.setCover(item.getString("utf-8"));}else if("image1".equals(fieldName)){g.setImage1(item.getString("utf-8"));}else if("image2".equals(fieldName)){g.setImage2(item.getString("utf-8"));}else if("stock".equals(fieldName)){g.setStock(Integer.parseInt(item.getString("utf-8")));}else if("typeid".equals(fieldName)){g.setTypeid(Integer.parseInt(item.getString("utf-8")));}else if("pageNumber".equals(fieldName)){pageNumber=Integer.parseInt(item.getString("utf-8"));}else if("type".equals(fieldName)){type = Integer.parseInt(item.getString("utf-8"));}}else {if(item.getInputStream().available()<=0)continue;String fileName = item.getName();fileName = fileName.substring(fileName.lastIndexOf("."));fileName = "/"+new Date().getTime()+fileName;String path = this.getServletContext().getRealPath("/picture")+fileName;InputStream in = item.getInputStream();FileOutputStream out = new FileOutputStream(path);byte[] buffer = new byte[1024];int len=0;while( (len=in.read(buffer))>0 ) {out.write(buffer);}in.close();out.close();//item.delete();String fieldName = item.getFieldName();if("cover".equals(fieldName)){g.setCover("/picture"+fileName);} else if("image1".equals(fieldName)){
@WebServlet(name = "admin_user_delete",urlPatterns = "/admin/user_delete")public class AdminUserDeleteServlet extends HttpServlet {private UserService uService = new UserService();/*** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {int id = Integer.parseInt(request.getParameter("id"));boolean isSuccess = uService.delete(id);if(isSuccess) {request.setAttribute("msg", "客户删除成功");}else {request.setAttribute("failMsg", "客户有下的订单，请先删除该客户下的订单，再来删除客户！");}request.getRequestDispatcher("/admin/user_list").forward(request, response);}/*** @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {// TODO Auto-generated method stubdoGet(request, response);}}@WebServlet(name = "user_changepwd",urlPatterns = "/user_changepwd")public class UserChangePwd extends HttpServlet {private UserService uService = new UserService();
try {pageNumber=Integer.parseInt(request.getParameter("pageNumber"));}catch (Exception e){}}Type t=null;if(id!=0){t=tService.selectTypeNameByID(id);}request.setAttribute("t",t);//List<Goods> list=gService.selectGoodsByTypeID(id,1,8);//request.setAttribute("goodsList",list);if(pageNumber<=0)pageNumber=1;Page p=gService.selectPageByTypeID(id,pageNumber);if(p.getTotalPage()==0){p.setTotalPage(1);p.setPageNumber(1);}else {if(pageNumber>=p.getTotalPage()+1){p=gService.selectPageByTypeID(id,p.getTotalPage());}}request.setAttribute("p",p);request.setAttribute("id",String.valueOf(id));request.getRequestDispatcher("/goods_list.jsp").forward(request,response);}}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String keyword = request.getParameter("keyword");int pageNumber = 1;if(request.getParameter("pageNumber") != null) {try {pageNumber=Integer.parseInt(request.getParameter("pageNumber") ) ;}catch (Exception e){}}if(pageNumber<=0){pageNumber=1;}Page p =gService.getSearchGoodsPage(keyword,pageNumber);if(p.getTotalPage()==0){p.setTotalPage(1);p.setPageNumber(1);}else {if(pageNumber>=p.getTotalPage()+1){p =gService.getSearchGoodsPage(keyword,pageNumber);}}request.setAttribute("p", p);request.setAttribute("keyword", URLEncoder.encode(keyword,"utf-8"));request.getRequestDispatcher("/goods_search.jsp").forward(request, response);}}
if(pageNumber<=0)pageNumber=1;Page p=gService.selectPageByTypeID(id,pageNumber);if(p.getTotalPage()==0){p.setTotalPage(1);p.setPageNumber(1);}else {if(pageNumber>=p.getTotalPage()+1){p=gService.selectPageByTypeID(id,p.getTotalPage());}}request.setAttribute("p",p);request.setAttribute("id",String.valueOf(id));request.getRequestDispatcher("/goods_list.jsp").forward(request,response);}}@WebServlet(name = "admin_goods_list",urlPatterns = "/admin/goods_list")public class AdminGoodsListServlet extends HttpServlet {private GoodsService gService = new GoodsService();/*** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {int type = 0;//推荐类型if(request.getParameter("type") != null) {type=Integer.parseInt(request.getParameter("type") ) ;}int pageNumber = 1;if(request.getParameter("pageNumber") != null) {try {pageNumber=Integer.parseInt(request.getParameter("pageNumber") ) ;
@WebServlet(name = "order_confirm",urlPatterns = "/order_confirm")public class OrderConfirmServlet extends HttpServlet {private OrderService oService = new OrderService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {Order o = (Order) request.getSession().getAttribute("order");try {BeanUtils.copyProperties(o, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}o.setDatetime(new Date());o.setStatus(2);o.setUser((User) request.getSession().getAttribute("user"));oService.addOrder(o);request.getSession().removeAttribute("order");request.setAttribute("msg", "订单支付成功！");request.getRequestDispatcher("/order_success.jsp").forward(request, response);}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}
else {if(pageNumber>=p.getTotalPage()+1){p = oService.getOrderPage(status,pageNumber);}}request.setAttribute("p", p);request.getRequestDispatcher("/admin/order_list.jsp").forward(request, response);}}@WebServlet(name = "goods_search",urlPatterns = "/goods_search")public class GoodsSearchServlet extends HttpServlet {protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}private GoodsService gService = new GoodsService();protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String keyword = request.getParameter("keyword");int pageNumber = 1;if(request.getParameter("pageNumber") != null) {try {pageNumber=Integer.parseInt(request.getParameter("pageNumber") ) ;}catch (Exception e){}}if(pageNumber<=0){pageNumber=1;
String password = request.getParameter("password");User user = uService.login(ue, password);if(user==null) {request.setAttribute("failMsg", "用户名、邮箱或者密码错误，请重新登录！");request.getRequestDispatcher("/user_login.jsp").forward(request, response);}else {request.getSession().setAttribute("user", user);if(user.isIsadmin()) {request.getRequestDispatcher("/admin/index.jsp").forward(request, response);}else {response.sendRedirect("/");}}}protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}}@WebServlet(name = "admin_type_edit",urlPatterns = "/admin/type_edit")public class AdminTypeEditServlet extends HttpServlet {private TypeService tService = new TypeService();/*** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {Type t = new Type();try {BeanUtils.copyProperties(t, request.getParameterMap());} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}tService.update(t);request.getRequestDispatcher("/admin/type_list").forward(request, response);}
p.setTotalPage(1);p.setPageNumber(1);}else {if(pageNumber>=p.getTotalPage()+1){p =gService.getSearchGoodsPage(keyword,pageNumber);}}request.setAttribute("p", p);request.setAttribute("keyword", URLEncoder.encode(keyword,"utf-8"));request.getRequestDispatcher("/goods_search.jsp").forward(request, response);}}@WebServlet(name = "order_confirm",urlPatterns = "/order_confirm")public class OrderConfirmServlet extends HttpServlet {private OrderService oService = new OrderService();protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {Order o = (Order) request.getSession().getAttribute("order");try {BeanUtils.copyProperties(o, request.getParameterMap());} catch (IllegalAccessException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (InvocationTargetException e) {// TODO Auto-generated catch blocke.printStackTrace();}o.setDatetime(new Date());o.setStatus(2);o.setUser((User) request.getSession().getAttribute("user"));oService.addOrder(o);request.getSession().removeAttribute("order");request.setAttribute("msg", "订单支付成功！");request.getRequestDispatcher("/order_success.jsp").forward(request, response);
