基于SSM旅游纪念品购物网站(idea-javaweb-javaee-j2ee-springboot)订单管理-购物评价-会员管理-购物车实现

 

1 概述

 

网站浏览者必须先进行注册登录系统后,才能够购买网站的商品。浏览者注册的信息提交到网站后台,由网站管理员进行管理。网站为用户提供,商品查询,商品购买的功能,并用购物车记录用户的购物选择,从而形成订单信息。用户登录,首先要有一个提供用户登录的表单。用户登录的表单应该嵌入整体的结构当中。在实际的应用中,可以这样设计,如果用户没有登录,在页面中显示用户登录的选项,用户登录后,可隐藏用户登录的选项而代之以用户的基本信息。

2 数据库表

 

表1 Bulletin公告表

字段名称

字段大小

字段类型

说明

id

4

长整型(3)

编号

title

100

文本(202)

标题

content

536870910

备注/超级链接(203)

内容

userId

4

长整型(3)

用户ID

createTime

50

文本(202)

时间

 

表2  CustomerDetailInfo  客户详细信息

字段名称

字段大小

字段类型

说明

customerId

4

长整型(3)

编号

name

50

文本(202)

姓名

telphone

20

文本(202)

电话

movePhone

20

文本(202)

手机

address

100

文本(202)

地址

 

3 关键代码

 

package com.control.third;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.dao.GoodsInfoDAO;
import com.dao.GoodsTypeDAO;
import com.dao.GoodsTypeDetailInfoDAO;
import com.entity.GoodsInfo;
import com.entity.GoodsTypeDetail;
import com.util.PublicToolCheckParam;
import com.util.PublicToolShowGoodsInfolist;


public class ManageGoodsInfo extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 7321956339019190364L;
	static GoodsInfoDAO gdao = new GoodsInfoDAO();

	public  static void deleteGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
			
		String goodsId = request.getParameter("goodsId");
		String thirdId = request.getParameter("thirdId");
		if(PublicToolCheckParam.checkNullAndEmpty(goodsId)){
			gdao.deleteGoodsInfo(Integer.parseInt(goodsId));
			String isSearching = request.getParameter("isSearching");
			String currentPage = request.getParameter("currentPage");
			if(PublicToolCheckParam.checkNullAndEmpty(isSearching)){
				String key = request.getParameter("key");
				PublicToolShowGoodsInfolist.searchGoodsInfoforthirdId(request, response, currentPage, key,thirdId);
				request.setAttribute("isSearching", "yes");
			}
			else{
				PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
			}
		}
		request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
			
	}

	public static void deleteMoreGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
			String thirdId = request.getParameter("thirdId");
	
		String currentPage = request.getParameter("currentPage");
		String[] ckb = request.getParameterValues("ckb");
		if(ckb != null){
			for(int i=0;i<ckb.length;i++){
				gdao.deleteGoodsInfo(Integer.parseInt(ckb[i]));
			}
		}
		PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
		request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
		
	}


	public static void insertGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
					String thirdId = request.getParameter("thirdId");

			String str_goodsName = request.getParameter("goodsName");
			String typeDetailInfo = request.getParameter("typeDetailInfo");
			String str_price = request.getParameter("price");
			String str_discount = request.getParameter("discount");
			String[] ckb = request.getParameterValues("ckb");
			String str_photo = request.getParameter("photo");
			String str_remark = request.getParameter("remark");
			String countRequire = request.getParameter("countRequire");
			//String deadline = request.getParameter("deadline");
			float discount = (float)10.0;
			int isNew = 1;
			int isRecommend = 1;
			int status = 1;
			String photo = null;
			if(PublicToolCheckParam.checkNullAndEmpty(str_goodsName) && PublicToolCheckParam.checkNullAndEmpty(typeDetailInfo) && PublicToolCheckParam.checkNullAndEmpty(str_price) && PublicToolCheckParam.checkNullAndEmpty(countRequire) ){
				if(PublicToolCheckParam.checkNullAndEmpty(str_discount)){
					discount = Float.parseFloat(str_discount);
				}
				if(ckb != null){
					for(int i=0;i<ckb.length;i++){
						if(ckb[i].equals("isNew")){
							isNew = 0;
						}
						else if(ckb[i].equals("isRecommend")){
							isRecommend = 0;
						}
						else if(ckb[i].equals("status")){
							status = 0;
						}
					}
				}
				if(PublicToolCheckParam.checkNullAndEmpty(str_photo)){
					String[] photoArray = str_photo.split("\\\\");
					photo = photoArray[photoArray.length-1];
					photo = photo.replaceAll("'", "’");
					
				}
				
				str_goodsName = str_goodsName.replaceAll("'", "’");
				gdao.addGoodsInfo(typeDetailInfo, str_goodsName, Double.parseDouble(str_price), discount, isNew, isRecommend, status, photo, str_remark,Integer.parseInt(countRequire),thirdId,"1");
				
				String currentPage = request.getParameter("currentPage");
		PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
				request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
			}	
	}
	public static void getTypeDetailInfo(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
	
		PrintWriter out = response.getWriter();
		String typeId = request.getParameter("goodsTypeId");
		GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
		ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(Integer.parseInt(typeId));
		if(typeDetailInfoList != null){
			for(int i=0;i<typeDetailInfoList.size();i++){
				GoodsTypeDetail typeDetailInfo = (GoodsTypeDetail)typeDetailInfoList.get(i);
				out.println(typeDetailInfo.getTypeDetailInfo()+","+typeDetailInfo.getId()+"|");
			}
		}
		out.flush();
		out.close();
}
	
	public static void searchGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
						String thirdId = request.getParameter("thirdId");
	
			
		String currentPage = request.getParameter("currentPage");
		String key = request.getParameter("key");
		key = new String(key.getBytes("iso-8859-1"),"utf-8");//转换关键词的编码
		PublicToolShowGoodsInfolist.searchGoodsInfoforthirdId(request, response, currentPage, key,thirdId);
		request.setAttribute("isSearching", "yes");
		request.setAttribute("key", key);
		request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
	}
	
	
	public static void showAddGoodsInfoPage(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
			String thirdId = request.getParameter("thirdId");
			GoodsTypeDAO gtdao = new GoodsTypeDAO();
			ArrayList<Object> typeList = gtdao.getAllType();
			GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
			ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(6);
			request.setAttribute("typeList", typeList);
			request.setAttribute("typeDetailInfoList", typeDetailInfoList);
			request.setAttribute("thirdId", thirdId);

			request.getRequestDispatcher("../third/addGoodsInfo.jsp").forward(request, response);
		
	}
	
	

	
	public static void showManageGoodsInfoPage(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
			String currentPage = request.getParameter("currentPage");

				String goodsId = request.getParameter("goodsId");
         String thirdId = request.getParameter("thirdId");
		PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
		request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
	
	}
	
	
	
	public static void updateGoodsInfo(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
		
		String currentPage = request.getParameter("currentPage");
		String submit = request.getParameter("submit");
		String goodsId = request.getParameter("goodsId");
        String thirdId = request.getParameter("thirdId");
		if(PublicToolCheckParam.checkNullAndEmpty(goodsId)){
			if(PublicToolCheckParam.checkNullAndEmpty(submit)){
				if(submit.equals("1")){
					String str_goodsName = request.getParameter("goodsName");
					String typeDetailInfo = request.getParameter("typeDetailInfo");
					String str_price = request.getParameter("price");
					String str_discount = request.getParameter("discount");
					String[] ckb = request.getParameterValues("ckb");
					String str_photo = request.getParameter("photo");
					String str_remark = request.getParameter("remark");
					String countRequire = request.getParameter("countRequire");
				//	String deadline = request.getParameter("deadline");
					float discount = (float)10.0;
					int isNew = 1;
					int isRecommend = 1;
					int status = 1;
					String photo = null;
					if(PublicToolCheckParam.checkNullAndEmpty(str_goodsName) && PublicToolCheckParam.checkNullAndEmpty(typeDetailInfo) && PublicToolCheckParam.checkNullAndEmpty(str_price) && PublicToolCheckParam.checkNullAndEmpty(countRequire) ){
						if(PublicToolCheckParam.checkNullAndEmpty(str_discount)){
							discount = Float.parseFloat(str_discount);
						}
						if(ckb != null){
							for(int i=0;i<ckb.length;i++){
								if(ckb[i].equals("isNew")){
									isNew = 0;
								}
								else if(ckb[i].equals("isRecommend")){
									isRecommend = 0;
								}
								else if(ckb[i].equals("status")){
									status = 0;
								}
							}
						}
						if(PublicToolCheckParam.checkNullAndEmpty(str_photo)){
							String[] photoArray = str_photo.split("\\\\");
							photo = photoArray[photoArray.length-1];
						}
						gdao.updateGoodsInfo(Integer.parseInt(goodsId),typeDetailInfo, str_goodsName, Double.parseDouble(str_price), discount, isNew, isRecommend, status, photo, str_remark,Integer.parseInt(countRequire),"1");

					
					
		PublicToolShowGoodsInfolist.showGoodsInfoListforthirdId(request, response, currentPage,thirdId);
						request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
					}
				}
				
			}
			else{
				GoodsInfo goodsInfo =  gdao.getQueryGoodsInfo(Integer.parseInt(goodsId));
				GoodsTypeDAO gtdao = new GoodsTypeDAO();
				ArrayList<Object> typeList = gtdao.getAllType();
				GoodsTypeDetailInfoDAO gtddao = new GoodsTypeDetailInfoDAO();
				ArrayList<Object> typeDetailInfoList = gtddao.GoodsTypeDetailAllInfoDAO(6);
				request.setAttribute("typeList", typeList);
				request.setAttribute("typeDetailInfoList", typeDetailInfoList);
				request.setAttribute("goodsInfo", goodsInfo);
				request.setAttribute("thirdId", thirdId);
				request.getRequestDispatcher("../third/updateGoodsInfo.jsp").forward(request, response);
			}
		}	
	}
	
	/**
	 * Constructor of the object.
	 */
	public ManageGoodsInfo() {
		super();
	}
	
	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	
	
	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request, response);
	}
	
	
	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		String method = request.getParameter("method");
		if(PublicToolCheckParam.checkNullAndEmpty(method)){
			if(method.equals("showAddGoodsInfoPage")){
				showAddGoodsInfoPage(request, response);
			}
			else if(method.equals("showManageGoodsInfoPage")){
				showManageGoodsInfoPage(request, response);
			}
			
			else if(method.equals("insert")){
				insertGoodsInfo(request, response);
			}
			else if(method.equals("delete")){
				deleteGoodsInfo(request, response);
			}
			else if(method.equals("deleteMore")){
				deleteMoreGoodsInfo(request, response);
			}
			else if(method.equals("search")){
				searchGoodsInfo(request, response);
			}
			else if(method.equals("update")){
				updateGoodsInfo(request, response);
			}
			else if(method.equals("getTypeDetailInfo")){
				getTypeDetailInfo(request, response);
			}
			
	

		}
	}
	
	public  static void coolGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
			String GoodsId = request.getParameter("GoodsId");
			String isCooled = request.getParameter("isCooled");
			if(PublicToolCheckParam.checkNullAndEmpty(GoodsId) && PublicToolCheckParam.checkNullAndEmpty(isCooled)){
					gdao.coolGoods(Integer.parseInt(GoodsId),Integer.parseInt(isCooled));
					String isSearching = request.getParameter("isSearching");
					String currentPage = request.getParameter("currentPage");
					if(PublicToolCheckParam.checkNullAndEmpty(isSearching)){
						String key = request.getParameter("key");
						PublicToolShowGoodsInfolist.searchGoodsInfo(request, response, currentPage, key);

						request.setAttribute("key", key);
						request.setAttribute("isSearching", "yes");
					}
					else{
						PublicToolShowGoodsInfolist.showGoodsInfoList(request, response, currentPage);
					}
			}
			request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
			
	}

	public static void coolMoreGoodsInfo(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
		
			String currentPage = request.getParameter("currentPage");
			String[] ckb = request.getParameterValues("ckb");
			if(ckb != null){
				for(int i=0;i<ckb.length;i++){
	//				cdao.coolGoods(Integer.parseInt(ckb[i]));
				}
			}
			PublicToolShowGoodsInfolist.showGoodsInfoList(request, response, currentPage);
			request.getRequestDispatcher("../third/manageGoodsInfo.jsp").forward(request, response);
		
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}

4 效果演示

 

idea或eclipse开发,mysql数据库

 

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

计算机程序设计开发

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值