基于javaweb+mysql的springboot体育用品商城(java+springboot+jsp+maven+mysql)

基于javaweb+mysql的springboot体育用品商城(java+springboot+jsp+maven+mysql)

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SpringBoot体育用品商城(java+springboot+jsp+maven+mysql)

本项目为前后台管理系统，包括管理员与普通用户两种角色；

管理员角色包含以下功能： 管理员登录,用户管理,商品类型管理,商品管理,订单信息管理,用户留言管理,资讯管理等功能。

用户角色包含以下功能： 用户首页,用户登录,商品推荐,资讯信息,留言板,查看商品,提交订单,查看订单信息,个人资料管理等功能。

ps:推荐模块用了协同过滤推荐算法，下订单模块用的是百度地图api。本商城可以修改为任意商城不止是体育商城。

		List<Pinglun> pinglunReleative = new ArrayList<Pinglun>();
		List<Integer> releativeUsers = new ArrayList<Integer>();
		for(Pinglun gChe:myselfPingluns) {
			int goods_id = gChe.getGoods_id();
			pinglun = new Pinglun();
			pinglun.setGoods_id(goods_id);
			pinglunReleative = pinglunDao.listPingluns(pinglun);
			for(Pinglun otherPinglun:pinglunReleative) {
				if(otherPinglun.getUser_id() != userid)
					releativeUsers.add(otherPinglun.getUser_id());
			}
		}		
		return releativeUsers.stream().distinct().collect(Collectors.toList());
	}

	/**
	 * @Title: queryGoods
	 * @Description: 查询商品
	 * @return String
	 */
	@RequestMapping(value="page_queryGoods.action",method=RequestMethod.GET)
	public String queryGoods(Goods paramsGoods,Evaluate paramsEvaluate,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			//得到商品
			Goods goods = indexManager.queryGoods(paramsGoods);
			model.addAttribute("goods", goods);

			//查询评价集合
			paperUtil.setPagination(paramsEvaluate);
			int[] sum={0};
			List<Evaluate> evaluates = indexManager.listEvaluates(paramsEvaluate,sum); 
			model.addAttribute("evaluates", evaluates);
			paperUtil.setTotalCount(sum[0]);

			//添加浏览记录
			User userFront = (User)httpSession.getAttribute("userFront");
			if (userFront!=null) {
				Uview uview = new Uview();
				uview.setUser_id(userFront.getUser_id());
				uview.setGoods_id(goods.getGoods_id());
				uview = indexManager.queryUview(uview);
				if (uview==null) {
					uview = new Uview();
					uview.setUser_id(userFront.getUser_id());

		return null;
	}
	
	/**
	 * @Title: addOrders
	 * @Description: 添加商品订单
	 * @param orders
	 * @return Orders
	 */
	@SuppressWarnings("unchecked")
	public void addOrders(Orders orders,HttpSession httpSession) {
		//生成订单号
		String orders_no = DateUtil.dateToDateString(new Date(), "yyyyMMddHHmmss")+orders.getUser_id();
		orders.setOrders_no(orders_no);
		//订单日期
		orders.setOrders_date(DateUtil.dateToDateString(new Date(), "yyyy-MM-dd"));
		//1：待发货
		orders.setOrders_flag(1);
		//查询购物车
		List<OrdersDetail> card = (List<OrdersDetail>) httpSession.getAttribute("card");
		double orders_money=0;
		for (int i = 0; i < card.size(); i++) {
			OrdersDetail ordersDetail = card.get(i);
			orders_money+=ordersDetail.getGoods_money();//累计总金额
			ordersDetail.setOrders_no(orders_no);//设置订单号
			//保存订单明细
			ordersDetailDao.addOrdersDetail(ordersDetail);
		}
		//设置总额
		orders.setOrders_money(orders_money);
		//保存订单
		ordersDao.addOrders(orders);
		
		//清空购物车
		httpSession.removeAttribute("card");
		
		
	}

	/**
	 * @Title: listCard
	 * @Description: 查询购物车
	 * @return List<OrdersDetail>
	 */
	@SuppressWarnings("unchecked")
	public List<OrdersDetail> listCard(HttpSession httpSession) {
		//查询购物车
		List<OrdersDetail> card = (List<OrdersDetail>) httpSession.getAttribute("card");
		if (card==null) {

		} catch (Exception e) {
			e.printStackTrace();
			setErrorTip("编辑失败", "Admin_listGoodss.action",model);
		}
		
		return "infoTip";
	}
	
	/**
	 * @Title: delGoodss
	 * @Description: 删除商品
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_delGoodss.action")
	public String delGoodss(Goods paramsGoods,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			 //删除商品
			adminManager.delGoodss(paramsGoods);
			
			setSuccessTip("删除商品成功", "Admin_listGoodss.action",model);
		} catch (Exception e) {
			e.printStackTrace();
			setErrorTip("删除商品异常", "Admin_listGoodss.action", model);
		}
		
		return "infoTip";
	}
	
	/**
	 * @Title: listOrderss
	 * @Description: 查询商品订单
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_listOrderss.action")
	public String listOrderss(Orders paramsOrders,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			if (paramsOrders==null) {
				paramsOrders = new Orders();
			}
			//设置分页信息
			paperUtil.setPagination(paramsOrders);
			//总的条数
			int[] sum={0};
			//查询商品订单列表
			List<Orders> orderss = adminManager.listOrderss(paramsOrders,sum); 
			model.addAttribute("orderss", orderss);
			paperUtil.setTotalCount(sum[0]);
			
		} catch (Exception e) {
			setErrorTip("查询商品订单异常", "main.jsp",model);
			return "infoTip";
		}

		} catch (Exception e) {
			e.printStackTrace();
			jsonData.setErrorReason("后台服务器异常");
			return jsonData;
		}
		return jsonData;
	}

	/**
	 * @Title: listMyOrderss
	 * @Description: 查询我的商品订单
	 * @return String
	 */
	@RequestMapping(value="page_listMyOrderss.action")
	public String listMyOrderss(Orders paramsOrders,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			if (paramsOrders==null) {
				paramsOrders = new Orders();
			}
			//获取用户,用户只能查询自己的订单
			User userFront = (User)httpSession.getAttribute("userFront");
			paramsOrders.setUser_id(userFront.getUser_id());
			//设置分页信息
			paperUtil.setPagination(paramsOrders);
			//总的条数
			int[] sum={0};
			//查询商品预约列表
			List<Orders> orderss = indexManager.listOrderss(paramsOrders,sum); 

			model.addAttribute("orderss", orderss);
			paperUtil.setTotalCount(sum[0]);

		} catch (Exception e) {
			e.printStackTrace();
			return "error";
		}

		return "ordersShow";
	}

	/**
	 * @Title: listMyOrdersDetails

	
	/**
	 * @Title: delSblogs
	 * @Description: 删除留言信息
	 * @param sblog
	 * @return void
	 */
	public void  delSblogs(Sblog sblog){
		sblogDao.delSblogs(sblog.getIds().split(","));
	}
	
	/**
	 * @Title: listSblogReplys
	 * @Description: 查询回复集合
	 * @param user
	 * @return List<User>
	 */
	public List<SblogReply> listSblogReplys(SblogReply user, int[] sum) {
		if (sum != null) {
			sum[0] = sblogReplyDao.listSblogReplysCount(user);
		}
		List<SblogReply> sblogReplys = sblogReplyDao.listSblogReplys(user);
		return sblogReplys;
	}
	
	/**
	 * @Title: addSblogReply
	 * @Description: 添加回复
	 * @param sblogReply
	 * @return void
	 */
	public void addSblogReply(SblogReply sblogReply) {
		//添加回复
		if (!StringUtil.isEmptyString(sblogReply.getReply_content())) {
			sblogReply.setReply_content(Transcode.htmlEncode(sblogReply.getReply_content()));
		}
		sblogReply.setReply_date(DateUtil.getCurDateTime());
		
		sblogReplyDao.addSblogReply(sblogReply);
	}

			mygoods_ids.add(gChe.getGoods_id());
		}
		mygoods_ids_clone.retainAll(othergoods_ids);//mygoods_ids变为交集
		int a = mygoods_ids_clone.size();
		int b = 0;
		othergoods_ids.removeAll(mygoods_ids);
		othergoods_ids.addAll(mygoods_ids);
		if(othergoods_ids.size() == 0) {
			b = 1;
		}else {
			b = othergoods_ids.size();
		}
		return a/b*1;
	}

	double getSimilarWithUserByDingdan(int me,int otherUserId) {
		DingDan dingdan = new DingDan();
		dingdan.setUser_id(otherUserId);
		List<Integer> mygoods_ids = new ArrayList<Integer>();
		List<Integer> mygoods_ids_clone = new ArrayList<Integer>();
		List<Integer> othergoods_ids = new ArrayList<Integer>();
		List<Integer> othergoods_ids_clone = new ArrayList<Integer>();
		List<DingDan> otherUserDingDans = (List<DingDan>) dingDanDao.listDingDans(dingdan);
		for (DingDan gChe:otherUserDingDans) {
			othergoods_ids.add(gChe.getGoods_id());
			othergoods_ids_clone.add(gChe.getGoods_id());
		}
		dingdan = new DingDan();
		dingdan.setUser_id(me);
		List<DingDan> mygoodsDingDans = (List<DingDan>) dingDanDao.listDingDans(dingdan);
		for (DingDan gChe:mygoodsDingDans) {
			mygoods_ids.add(gChe.getGoods_id());
		}
		mygoods_ids_clone.retainAll(othergoods_ids);//mygoods_ids变为交集
		int a = mygoods_ids.size();
		int b = 0;
		othergoods_ids.removeAll(mygoods_ids);
		othergoods_ids.addAll(mygoods_ids);
		if(othergoods_ids.size() == 0) {
			b = 1;
		}else {
			b = othergoods_ids.size();
		}
		return a/b*2;
	}

	double getSimilarWithUserByPinglun(int me,int otherUserId) {
		Pinglun pinglun = new Pinglun();
		pinglun.setUser_id(otherUserId);
		List<Integer> mygoods_ids = new ArrayList<Integer>();
		List<Integer> mygoods_ids_clone = new ArrayList<Integer>();
		List<Integer> othergoods_ids = new ArrayList<Integer>();
		List<Integer> othergoods_ids_clone = new ArrayList<Integer>();
		List<Pinglun> otherUserPingluns = (List<Pinglun>) pinglunDao.listPingluns(pinglun);

	 * @Title: listGoodsTypes
	 * @Description: 商品类型查询
	 * @param goodsType
	 * @return List<GoodsType>
	 */
	public List<GoodsType> listGoodsTypes(GoodsType goodsType, int[] sum) {
		if (sum != null) {
			sum[0] = goodsTypeDao.listGoodsTypesCount(goodsType);
		}
		List<GoodsType> goodsTypes = goodsTypeDao.listGoodsTypes(goodsType);

		return goodsTypes;
	}
	
	/**
	 * @Title: listGoodss
	 * @Description: 查询商品信息
	 * @param goods
	 * @return List<Goods>
	 */
	public List<Goods>  listGoodss(Goods goods,int[] sum){
		if (sum!=null) {
			sum[0] = goodsDao.listGoodssCount(goods);
		}
		List<Goods> goodss = goodsDao.listGoodss(goods);
		return goodss;
	}
	
	public List<Goods>  listGoodssTop(Goods goods){
		List<Goods> goodss = goodsDao.listGoodssTop(goods);
		return goodss;
	}
	
	public List<Goods>  findLikesByUser(int user_id){
		List<Goods> goodss = goodsDao.listGoodssTop(new Goods());
		return goodss;
	}
	
	/**
	 * @Title: queryGoods
	 * @Description: 商品查询
	 * @param goods
	 * @return Goods

	 * @Title: listCard
	 * @Description: 查询购物车
	 * @return List<OrdersDetail>
	 */
	@SuppressWarnings("unchecked")
	public List<OrdersDetail> listCard(HttpSession httpSession) {
		//查询购物车
		List<OrdersDetail> card = (List<OrdersDetail>) httpSession.getAttribute("card");
		if (card==null) {
			card = new ArrayList<OrdersDetail>();
		}
		return card;
	}
	
	/**
	 * @Title: listOrderss
	 * @Description: 商品订单查询
	 * @param orders
	 * @return List<Orders>
	 */
	public List<Orders>  listOrderss(Orders orders,int[] sum){
		
		if (sum!=null) {
			sum[0] = ordersDao.listOrderssCount(orders);
		}
		List<Orders> orderss = ordersDao.listOrderss(orders);
		
		
		return orderss;
	}
	
	/**
	 * @Title: queryOrders
	 * @Description: 商品订单查询
	 * @param orders
	 * @return Orders
	 */
	public Orders  queryOrders(Orders orders){
		
		Orders _orders = ordersDao.getOrders(orders);
		
		return _orders;
	}
	
	/**
	 * @Title: finishOrders
	 * @Description: 确认收货
	 * @param evaluate

	public void admin(Manager paramsManager,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession) throws Exception{
		response.sendRedirect(request.getContextPath() + "admin/index.jsp");
	}

	
	/**
	 * @Title: saveAdmin
	 * @Description: 保存修改个人信息
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_saveAdmin.action",method=RequestMethod.POST)
	public String saveAdmin(Manager paramsManager,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			//验证用户会话是否失效
			if (!validateAdmin(httpSession)) {
				return "loginTip";
			}
			 //保存修改个人信息
			adminManager.updateManager(paramsManager);
			//更新session
			Manager admin = new Manager();
			admin.setManager_id(paramsManager.getManager_id());
			admin = adminManager.queryManager(admin);
			httpSession.setAttribute("admin", admin);

			setSuccessTip("编辑成功", "modifyInfo.jsp", model);
		} catch (Exception e) {
			e.printStackTrace();
			setErrorTip("编辑异常", "modifyInfo.jsp", model);
		}
		return "infoTip";
	}
	
	/**
	 * @Title: saveAdminPass
	 * @Description: 保存修改个人密码
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_saveAdminPass.action",method=RequestMethod.POST)
	public String saveAdminPass(Manager paramsManager,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			//验证用户会话是否失效
			if (!validateAdmin(httpSession)) {

	 */
	@RequestMapping(value="page_addOrders.action")
	@ResponseBody
	public JSONData addOrders(Orders paramsOrders,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		JSONData jsonData = new JSONData();
		try {
			//新增订单
			indexManager.addOrders(paramsOrders,httpSession);
			User user = (User)httpSession.getAttribute("userFront");
			if(user == null) {
				jsonData.setErrorReason("登录超时请重新登录！");
				return jsonData;
			}
			GouWuChe gouWuChe = new GouWuChe();
			gouWuChe.setUser_id(user.getUser_id());
			gouWuCheDao.delGouWuChe(gouWuChe);
			Orders orders = new Orders();
			orders.setOrders_no(paramsOrders.getOrders_no());
			List<OrdersDetail> listsDetails = ordersDetailDao.listOrdersDetailsByOrder(orders);
			if(listsDetails != null) {
				for(OrdersDetail ordersDetail:listsDetails) {
					DingDan dingdan = new DingDan();
					dingdan.setGoods_id(ordersDetail.getGoods_id());
					dingdan.setTime(new Date());
					dingdan.setUser_id(user.getUser_id());
					if(dingDanDao.getDingDan(dingdan) == null)
						dingDanDao.addDingDan(dingdan);
				}
			}

			System.out.println(listsDetails.size());
		} catch (Exception e) {
			e.printStackTrace();
			jsonData.setErrorReason("提交订单失败");
			return jsonData;
		}

		return jsonData;
	}

	/**
	 * @Title: listSblogs
	 * @Description: 留言信息
	 * @return String
	 */
	@RequestMapping(value="page_listSblogs.action")
	public String listSblogs(Sblog paramsSblog,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			//查询留言信息集合
			if (paramsSblog==null) {

			}
			 //保存修改个人密码
			Manager admin = (Manager)httpSession.getAttribute("admin");
			if (!admin.getManager_pass().equals(Md5.makeMd5(paramsManager.getManager_passOld()))) {
				setErrorTip("修改异常，原密码不正确", "modifyPwd.jsp", model);
				return "infoTip";
			}
			adminManager.updateManager(paramsManager);
			//更新session
			if (admin!=null) {
				admin.setManager_pass(paramsManager.getManager_pass());
				httpSession.setAttribute("admin", admin);
			}

			setSuccessTip("修改成功", "modifyPwd.jsp", model);
		} catch (Exception e) {
			setErrorTip("修改异常", "modifyPwd.jsp", model);
		}
		return "infoTip";
	}
	
	/**
	 * @Title: listUsers
	 * @Description: 查询注册用户
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_listUsers.action")
	public String listUsers(User paramsUser,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			if (paramsUser==null) {
				paramsUser = new User();
			}
			if (paperUtil==null) {
				paperUtil = new PaperUtil();
			}
			//设置分页信息
			paperUtil.setPagination(paramsUser);
			//总的条数
			int[] sum={0};
			//查询注册用户列表
			List<User> users = adminManager.listUsers(paramsUser,sum); 
			model.addAttribute("users", users);
			model.addAttribute("paramsUser", paramsUser);
			paperUtil.setTotalCount(sum[0]);

		} catch (Exception e) {
			setErrorTip("查询注册用户异常", "main.jsp", model);
			return "infoTip";
		}

		mygoods_ids_clone.retainAll(othergoods_ids);//mygoods_ids变为交集
		int a = mygoods_ids_clone.size();
		int b = 0;
		othergoods_ids.removeAll(mygoods_ids);
		othergoods_ids.addAll(mygoods_ids);
		if(othergoods_ids.size() == 0) {
			b = 1;
		}else {
			b = othergoods_ids.size();
		}
		return a/b*3;
	}

	//通过购物车获取相关联的用户
	public List<Integer> getReleativeUserByGouWuChe(int userid){
		GouWuChe gouwuche = new GouWuChe();
		gouwuche.setUser_id(userid);
		List<GouWuChe> myselfGouWuChes = (List<GouWuChe>) gouWuCheDao.listGouWuChes(gouwuche);
		List<GouWuChe> gouwucheReleative = new ArrayList<GouWuChe>();
		List<Integer> releativeUsers = new ArrayList<Integer>();
		for(GouWuChe gChe:myselfGouWuChes) {
			int goods_id = gChe.getGoods_id();
			gouwuche = new GouWuChe();
			gouwuche.setGoods_id(goods_id);
			gouwucheReleative = gouWuCheDao.listGouWuChes(gouwuche);
			for(GouWuChe otherGouWuChe:gouwucheReleative) {
				if(otherGouWuChe.getUser_id() != userid)
					releativeUsers.add(otherGouWuChe.getUser_id());
			}
		}		
		return releativeUsers.stream().distinct().collect(Collectors.toList());
	}
	//通过订单获取相关联的用户
	public List<Integer> getReleativeUserByDingdan(int userid){
		DingDan dingdan = new DingDan();
		dingdan.setUser_id(userid);
		List<DingDan> myselfDingDans = (List<DingDan>) dingDanDao.listDingDans(dingdan);
		List<DingDan> dingdanReleative = new ArrayList<DingDan>();
		List<Integer> releativeUsers = new ArrayList<Integer>();
		for(DingDan gChe:myselfDingDans) {
			int goods_id = gChe.getGoods_id();

				paperUtil = new PaperUtil();
			}
  
			//查询商品类型列表
			List<Zixun> zixuns = zixunMapper.selectByExample(new ZixunExample()); 
			
			model.addAttribute("zixuns", zixuns);
//			model.addAttribute("zixun", zixun);
			paperUtil.setTotalCount(zixuns.size());
			
		} catch (Exception e) {
 			return "infoTip";
		}
		
		return "zixunshow";
	}
	/**
	 * @Title: listGoodssHobby
	 * @Description: 查询商品推荐
	 * @return String
	 */
	@RequestMapping(value="page_listGoodssHobby.action")
	public String listGoodssHobby(Goods paramsGoods,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			if (paramsGoods==null) {
				paramsGoods = new Goods();
			}
			if (paperUtil==null) {
				paperUtil = new PaperUtil();
			}
			//设置分页信息
			paperUtil.setPagination(paramsGoods);
			//总的条数
			int[] sum={0};
			//查询商品列表
			User userFront = (User)httpSession.getAttribute("userFront");

			List<Integer> gouwucheList = getReleativeUserByGouWuChe(userFront.getUser_id());
			List<Integer> dingdanList = getReleativeUserByDingdan(userFront.getUser_id());
			List<Integer> pinglunList = getReleativeUserByPinglun(userFront.getUser_id());
			System.out.println(gouwucheList);
			System.out.println(dingdanList);
			System.out.println(pinglunList);
			Map<Integer, Double> map = new HashMap<Integer, Double>();
			for(Integer id:gouwucheList) {
				double similar = getSimilarWithUserByGouWuChe(userFront.getUser_id(), id);
				map.put(id, similar);
			}
			for(Integer id:dingdanList) {

	 * @Title: addEvaluateShow
	 * @Description: 评价商品界面
	 * @return String
	 */
	@RequestMapping(value="page_addEvaluateShow.action")
	public String addEvaluateShow(Orders paramsOrders,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			//查询订单
			Orders orders = indexManager.queryOrders(paramsOrders);
			model.addAttribute("orders", orders);

		} catch (Exception e) {
			e.printStackTrace();
			return "error";
		}

		return "evaluateAdd";
	}

	/**
	 * @Title: addEvaluate
	 * @Description: 评价商品
	 * @return String
	 */
	@RequestMapping(value="page_addEvaluate.action")
	@ResponseBody
	public JSONData addEvaluate(Evaluate paramsEvaluate,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		JSONData jsonData = new JSONData();
		try {
			//新增商品评价
			indexManager.addEvaluate(paramsEvaluate);
			User user = (User)httpSession.getAttribute("userFront");
			if(user == null) {
				jsonData.setErrorReason("登录超时请重新登录！");
				return jsonData;
			}
			Pinglun pinglunCron = new Pinglun();
			Orders ordersCron = new Orders();
			ordersCron.setOrders_no(paramsEvaluate.getOrders_no());
			List<OrdersDetail> ordersDetails = ordersDetailDao.listOrdersDetailsByOrder(ordersCron);
			for(OrdersDetail ordersDetail:ordersDetails) {
				pinglunCron = new Pinglun();
				pinglunCron.setGoods_id(ordersDetail.getGoods_id());
				pinglunCron.setUser_id(paramsEvaluate.getUser_id());
				pinglunCron.setTime(new Date());
				pinglunCron.setLevel(paramsEvaluate.getEvaluate_level());
				Pinglun pinglun = pinglunDao.getPinglun(pinglunCron);
				if(pinglun == null) {
					pinglunDao.addPinglun(pinglunCron);
				}
				else if (pinglun.getLevel() > paramsEvaluate.getEvaluate_level()) {
					pinglunCron.setTime(new Date());

		try {
			//检查商品类型是否存在
			GoodsType goodsType = new GoodsType();
			goodsType.setGoods_type_name(paramsGoodsType.getGoods_type_name());
			goodsType = adminManager.queryGoodsType(goodsType);
			if (goodsType!=null) {
				String tip="失败，该商品类型已经存在！";
				model.addAttribute("tip", tip);
				model.addAttribute("goodsType", paramsGoodsType);
				
				return "goodsTypeEdit";
			}
			
			 //添加商品类型
			adminManager.addGoodsType(paramsGoodsType);
			
			setSuccessTip("添加成功", "Admin_listGoodsTypes.action",model);
		} catch (Exception e) {
			setErrorTip("添加商品类型异常", "Admin_listGoodsTypes.action", model);
		}
		
		return "infoTip";
	}
	
	 
	/**
	 * @Title: editGoodsType
	 * @Description: 编辑商品类型
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_editGoodsType.action",method=RequestMethod.GET)
	public String editGoodsType(GoodsType paramsGoodsType,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			 //得到商品类型
			GoodsType goodsType = adminManager.queryGoodsType(paramsGoodsType);
			model.addAttribute("goodsType", goodsType);
			
		} catch (Exception e) {
			setErrorTip("查询商品类型异常", "Admin_listGoodsTypes.action", model);

	 */
	public void addEvaluate(Evaluate evaluate) {
		//添加商品评价
		evaluate.setEvaluate_date(DateUtil.getCurDateTime());
		evaluateDao.addEvaluateBatch(evaluate);
		
		//更新订单为已评价
		Orders orders = new Orders();
		orders.setOrders_no(evaluate.getOrders_no());
		orders.setOrders_flag(4);
		ordersDao.updateOrders(orders);
		
		
	}

	/**
	 * @Title: listSblogs
	 * @Description: 查询留言信息
	 * @param sblog
	 * @return List<Sblog>
	 */
	public List<Sblog>  listSblogs(Sblog sblog,int[] sum){
		if (sum!=null) {
			sum[0] = sblogDao.listSblogsCount(sblog);
		}
		List<Sblog> sblogs = sblogDao.listSblogs(sblog);
		if (sblogs!=null) {
			for (Sblog sblog2 : sblogs) {
				SblogReply sblogReply = new SblogReply();
				sblogReply.setStart(-1);
				sblogReply.setSblog_id(sblog2.getSblog_id());
				List<SblogReply> replys = sblogReplyDao.listSblogReplys(sblogReply);
				if (replys!=null) {
					sblog2.setReplys(replys);
				}
			}
		}
		return sblogs;
	}
	

	
	/**
	 * @Title: listOrdersDetails
	 * @Description: 查询商品订单明细
	 * @return String
	 */
	@RequestMapping(value="admin/Admin_listOrdersDetails.action")
	public String listOrdersDetails(OrdersDetail paramsOrdersDetail,PaperUtil paperUtil,
			ModelMap model,HttpServletRequest request,HttpServletResponse response,HttpSession httpSession){
		try {
			if (paramsOrdersDetail==null) {
				paramsOrdersDetail = new OrdersDetail();
			}
			//设置分页信息
			paperUtil.setPagination(paramsOrdersDetail);
			//总的条数
			int[] sum={0};
			//查询商品订单明细
			List<OrdersDetail> ordersDetails = adminManager.listOrdersDetails(paramsOrdersDetail,sum); 
			
			model.addAttribute("ordersDetails", ordersDetails);
			paperUtil.setTotalCount(sum[0]);
			
			model.addAttribute("orders_no", paramsOrdersDetail.getOrders_no());
			if (ordersDetails!=null && ordersDetails.size()>0) {
				model.addAttribute("orders_money", ordersDetails.get(0).getOrders_money());
			}
			
			
		} catch (Exception e) {
			setErrorTip("查询商品订单明细异常", "main.jsp", model);
			return "infoTip";
		}
		
		return "ordersDetailShow";
	}
	
	/**
	 * @Title: validateAdmin
	 * @Description: admin登录验证
	 * @return boolean
	 */
	private boolean validateAdmin(HttpSession httpSession){
		Manager admin = (Manager)httpSession.getAttribute("admin");
		if (admin!=null) {
			return true;
		}else {
			return false;
		}
	}
	
	private void setErrorTip(String tip,String url,ModelMap model){
		model.addAttribute("tipType", "error");