基于javaweb+mysql的ssh水果销售系统(java+ssh+mysql+tomcat+jsp)

于 2023-08-26 10:46:50 发布
阅读量50 收藏
点赞数
文章标签： mysql java 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/m0_71463355/article/details/132508966
版权
本文介绍了一个基于Java、SSH（Struts+Spring+Hibernate）、MySQL和Tomcat的水果销售系统，包括用户注册、登录、商品浏览、购物车操作、订单管理等功能，适合课程设计、大作业和学习演示。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

基于javaweb+mysql的ssh水果销售系统(java+ssh+mysql+tomcat+jsp)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SSH水果销售系统(java+ssh+mysql+tomcat+jsp)

一、项目简述

功能： 区分为管理员用户和普通用户，普通用户：用户注册登 录，首页水果展示，商品分类展示，购物车添加，下单， 订单查询，个人信息修改，管理员用户：包括水果基本信 息维护增删改查，分类管理，订单管理，用户管理等等功 能。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + Mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)

项目技术： JSP + Struts + Spring + Hibernate + html + css + JavaScript + JQuery等等。

		List goodsListpaihang=new ArrayList();
		sql="select sum(goodsShuliang),goodsId from TMingxi group by goodsId order by sum(goodsShuliang) desc";
		List list=mingxiDAO.getHibernateTemplate().find(sql);
		for(int i=0;i<list.size();i++)
		{
			Object[] b=(Object[])list.get(i);
			int goodsId=Integer.parseInt(b[1].toString());
			
			TGoods goods=goodsDAO.findById(goodsId);
			goodsListpaihang.add(goods);
		}
		if(goodsList.size()>4)
		{
			goodsList=goodsList.subList(0, 4);
		}
		request.put("goodsListpaihang", goodsListpaihang);
		
		
		
		return ActionSupport.SUCCESS;
	}
	
	
	public String goodsDetailQian()
	{
		TGoods goods=goodsDAO.findById(id);
		
		Map request=(Map)ServletActionContext.getContext().get("request");
		
		contentList=FunctionDAOImpl.findContentList("pingjia",id);
		
		
		request.put("goods", goods);
		return ActionSupport.SUCCESS;
	}
	
	
	
	public String goodspingjia()
	{
		
		HttpServletRequest request=ServletActionContext.getRequest();
		HttpSession session=request.getSession();
		
		THuiyuan huiyuan=(THuiyuan)session.getAttribute("huiyuan");

	{
		return tejia;
	}

	public void setTejia(Integer tejia)
	{
		this.tejia = tejia;
	}

	public String getShifoutejia()
	{
		return shifoutejia;
	}

	public void setShifoutejia(String shifoutejia)
	{
		this.shifoutejia = shifoutejia;
	}

	public String getDel()
	{
		return del;
	}

	public void setDel(String del)
	{
		this.del = del;
	}

	public TGoodsDAO getGoodsDAO()
	{
		return goodsDAO;
	}

	public void setGoodsDAO(TGoodsDAO goodsDAO)

	private Integer yue;
	private String del;
	
	private String message;
	private String path;
	
	private THuiyuanDAO huiyuanDAO;
	public SweetnessDAO sweetnessDAO;
	
	
	public String huiyuanReg()
	{
		HttpServletRequest request=ServletActionContext.getRequest();
		
		String sql="from THuiyuan where loginname=?";
		Object[] c={loginname.trim()};
		List huiyuanList=huiyuanDAO.getHibernateTemplate().find(sql,c);
		if(huiyuanList.size()>0)
		{
			this.setMessage("账号已被占用，请重新注册");
			this.setPath("site/userreg/userreg.jsp");
		}
		else
		{
			THuiyuan huiyuan=new THuiyuan();
			
			//huiyuan.setId(id);
			huiyuan.setLoginname(loginname);
			huiyuan.setLoginpw(loginname);
			huiyuan.setXingming(xingming);
			
			huiyuan.setXingbie(xingbie);
			huiyuan.setNianling(nianling);
			huiyuan.setAddress(address);
			huiyuan.setDianhua(dianhua);
			
			huiyuan.setYue(0);
			huiyuan.setDel("no");
			
			huiyuanDAO.save(huiyuan);
			
			this.setMessage("注册成功，请登录");
			this.setPath("site/userreg/userreg.jsp");

	{
		this.jieshao = jieshao;
	}

	public String getFujian()
	{
		return fujian;
	}

	public void setFujian(String fujian)
	{
		this.fujian = fujian;
	}

	public Integer getJiage()
	{
		return jiage;
	}

	public void setJiage(Integer jiage)
	{
		this.jiage = jiage;
	}

	public Integer getTejia()
	{
		return tejia;
	}

	public void setTejia(Integer tejia)
	{
		this.tejia = tejia;
	}

	public String getShifoutejia()
	{
		return shifoutejia;
	}

    {
    	String sql="from TLeibie where Del='no'";
		List leibieList=leibieDAO.getHibernateTemplate().find(sql);
		return leibieList;
    }
}

public class cartService
{
	public String modiNum(int goodsId,int quantity)
	{
		try
		{
			Thread.sleep(500);
		} 
		catch (InterruptedException e)
		{
			e.printStackTrace();
		}
		
		
		 WebContext ctx = WebContextFactory.get(); 
		 HttpSession session=ctx.getSession();
		 Cart cart=(Cart)session.getAttribute("cart");
		 cart.updateCart(goodsId, quantity);
		 session.setAttribute("cart", cart);
		 return "yes";
	}
	
	public String delGoodsFromCart(int goodsId)
	{
		try
		{
			Thread.sleep(500);
		} 
		catch (InterruptedException e)
		{
			e.printStackTrace();
		}
		

		this.pingFlag = pingFlag;
	}
	
}

public class goodsAction extends ActionSupport
{
	private Integer id;
	private Integer leibieId;
	private String mingcheng;
	private String jieshao;
	
	private String fujian;
	private Integer jiage;
	private Integer tejia;
	private String shifoutejia;
	
	private String del;
	
	private TGoodsDAO goodsDAO;
	private List<TContent> contentList;
	private TMingxiDAO mingxiDAO;
	
	public String goodsAdd()
	{
		TGoods goods=new TGoods();
		

		
		return ActionSupport.SUCCESS;
	}

	public Integer getLeibieId()
	{
		return leibieId;
	}

	public void setLeibieId(Integer leibieId)
	{
		this.leibieId = leibieId;
	}

	public Integer getId()
	{
		return id;
	}

	public void setId(Integer id)
	{
		this.id = id;
	}

	public String getMingcheng()
	{
		return mingcheng;
	}

	public void setMingcheng(String mingcheng)
	{
		this.mingcheng = mingcheng;
	}

	public String getJieshao()
	{
		return jieshao;
	}

	public void setJieshao(String jieshao)


public class buyAction extends ActionSupport
{
	private TGoodsDAO goodsDAO;
	private TOrderDAO orderDAO;
	private TMingxiDAO mingxiDAO;
	
	private String message;
	private String path;
	private String pingFlag;
	public String addToCart()
	{
		HttpServletRequest request=ServletActionContext.getRequest();
		HttpSession session=request.getSession();
		
		int goodsId=Integer.parseInt(request.getParameter("goodsId"));
		int shuliang=Integer.parseInt(request.getParameter("shuliang"));
		
		TGoods goods=goodsDAO.findById(goodsId);
		TMingxi mingxi=new TMingxi();
		mingxi.setGoods(goods);

	{
		this.path = path;
	}

	public String getPingFlag() {
		return pingFlag;
	}

	public void setPingFlag(String pingFlag) {
		this.pingFlag = pingFlag;
	}
	
}

public class goodsAction extends ActionSupport
{

				 HttpSession session=ctx.getSession(); 
				
				 THuiyuan huiyuan=(THuiyuan)huiyuanList.get(0);
				 session.setAttribute("userType", 1);
	             session.setAttribute("huiyuan", huiyuan);
	             
	             Cart cart=new Cart();
				 session.setAttribute("cart", cart);
				 
	             result="yes";
			}
		}
		if(userType==2)
		{
			
		}
		return result;
	}

    public String adminPwEdit(String userPwNew)
    {
		System.out.println("DDDD");
		WebContext ctx = WebContextFactory.get(); 
		HttpSession session=ctx.getSession(); 
		 
		TAdmin admin=(TAdmin)session.getAttribute("admin");
		admin.setUserPw(userPwNew);
		
		adminDAO.getHibernateTemplate().update(admin);
		session.setAttribute("admin", admin);
		
		return "yes";
    }
    
    
    public void userLogout()
    {
    	WebContext ctx = WebContextFactory.get(); 
		HttpSession session=ctx.getSession(); 
		session.setAttribute("userType", null);
		session.setAttribute("user", null);
    }
    
    
    public List leibieSelect()
    {
    	String sql="from TLeibie where Del='no'";

		THuiyuan huiyuan=huiyuanDAO.findById(id);
		huiyuan.setDel("yes");
		huiyuanDAO.attachDirty(huiyuan);
		
		this.setMessage("删除成功");
		this.setPath("huiyuanMana.action");
		return "succeed";
	}
	
	
	public String sweetnessReg()
	{
		HttpServletRequest request=ServletActionContext.getRequest();
		String name=request.getParameter("name");
		String degree=request.getParameter("degree");
		
		String sql = "select * from t_sweetness where name=?";
		Connection conn = JdbcUtils.connSQL();
		Sweetness s = null;
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, name);
			ResultSet rs = pstmt.executeQuery();
			while(rs.next()){
				s = new Sweetness();
				s.setName(rs.getString("name"));
				s.setDegree(rs.getInt("degree"));
				s.setId(rs.getInt("id"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		if(s!=null){
			if(Integer.valueOf(degree)>s.getDegree()){
				request.getSession().setAttribute("msg", "甜");
			}else{
				request.getSession().setAttribute("msg", "不甜");
			}
		}else{
			request.getSession().setAttribute("msg", "水果不存在！");
		}
		request.getSession().setAttribute("name",name);
		request.getSession().setAttribute("degree", degree);
		this.setPath("sweetness/index.jsp");
		return "succeed";

		request.setAttribute("mingxiList", mingxiList);
		return ActionSupport.SUCCESS;
	}

	

	public String pingjia()
	{
		HttpServletRequest request=ServletActionContext.getRequest();
		int orderId=Integer.parseInt(request.getParameter("orderId"));
		
		String sql="from TMingxi where orderId="+orderId;
		List mingxiList=mingxiDAO.getHibernateTemplate().find(sql);
		for(int i=0;i<mingxiList.size();i++)
		{
			TMingxi mingxi=(TMingxi)mingxiList.get(i);
			mingxi.setGoods(goodsDAO.findById(mingxi.getGoodsId()));
		}
		request.setAttribute("mingxiList", mingxiList);
		return ActionSupport.SUCCESS;
	}

	public String userping()
	{
		HttpServletRequest request=ServletActionContext.getRequest();
		HttpSession session=request.getSession();
		
		Cart cart = (Cart)session.getAttribute("cart");
		THuiyuan huiyuan=(THuiyuan)session.getAttribute("huiyuan");
		
		TContent content= new TContent();
		content.setGoodsId(request.getParameter("goodsId"));
		content.setAddTime(new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date()));
		content.setHuiyuanId(huiyuan.getLoginname());
		content.setContent(request.getParameter("userFlag"));
		FunctionDAOImpl.insertUserPingjia(content);
		Map request1=(Map)ServletActionContext.getContext().get("request");
		request1.put("msg", "商品评价完成");
		return "msg";
	}

	
	public TGoodsDAO getGoodsDAO()
	{
		return goodsDAO;
	}

	public TMingxiDAO getMingxiDAO()
	{
		return mingxiDAO;

{
	public String modiNum(int goodsId,int quantity)
	{
		try
		{
			Thread.sleep(500);
		} 
		catch (InterruptedException e)
		{
			e.printStackTrace();
		}
		
		
		 WebContext ctx = WebContextFactory.get(); 
		 HttpSession session=ctx.getSession();
		 Cart cart=(Cart)session.getAttribute("cart");
		 cart.updateCart(goodsId, quantity);
		 session.setAttribute("cart", cart);
		 return "yes";
	}
	
	public String delGoodsFromCart(int goodsId)
	{
		try
		{
			Thread.sleep(500);
		} 
		catch (InterruptedException e)
		{
			e.printStackTrace();
		}
		
		 WebContext ctx = WebContextFactory.get(); 
		 HttpSession session=ctx.getSession();
		 Cart cart=(Cart)session.getAttribute("cart");
		 cart.delGoods(goodsId);
		 session.setAttribute("cart", cart);
		 return "yes";
	}
	
	
	public String clearCart()
	{
		try
		{


	public TMingxiDAO getMingxiDAO()
	{
		return mingxiDAO;
	}

	public void setMingxiDAO(TMingxiDAO mingxiDAO)
	{
		this.mingxiDAO = mingxiDAO;
	}

	public void setGoodsDAO(TGoodsDAO goodsDAO)
	{
		this.goodsDAO = goodsDAO;
	}

	public TOrderDAO getOrderDAO()
	{
		return orderDAO;
	}

	public void setOrderDAO(TOrderDAO orderDAO)
	{
		this.orderDAO = orderDAO;
	}

	public String getMessage()
	{
		return message;
	}


		return ActionSupport.SUCCESS;
	}

	public Integer getLeibieId()
	{
		return leibieId;
	}

	public void setLeibieId(Integer leibieId)
	{
		this.leibieId = leibieId;
	}

	public Integer getId()
	{
		return id;
	}

	public void setId(Integer id)
	{
		this.id = id;
	}

	public String getMingcheng()
	{
		return mingcheng;
	}

	public void setMingcheng(String mingcheng)
	{
		this.mingcheng = mingcheng;
	}

	public String getJieshao()
	{
		return jieshao;
	}

	public void setJieshao(String jieshao)
	{
		this.jieshao = jieshao;
	}


	{
		return dianhua;
	}

	public void setDianhua(String dianhua)
	{
		this.dianhua = dianhua;
	}

	public Integer getYue()
	{
		return yue;
	}

	public void setYue(Integer yue)
	{
		this.yue = yue;
	}

	public String getDel()
	{
		return del;
	}

	public void setDel(String del)
	{
		this.del = del;
	}

	public String getMessage()
	{
		return message;
	}

	public void setMessage(String message)
	{
		this.message = message;
	}

	public String getPath()

	{
		String sql="from TGoods where del='no' order by id desc";
		List goodsList=goodsDAO.getHibernateTemplate().find(sql);
		if(goodsList.size()>6)
		{
			goodsList=goodsList.subList(0, 6);
		}
		Map request=(Map)ServletActionContext.getContext().get("request");
		request.put("goodsList", goodsList);
		
		
		
		
		
		
		List goodsListpaihang=new ArrayList();
		sql="select sum(goodsShuliang),goodsId from TMingxi group by goodsId order by sum(goodsShuliang) desc";
		List list=mingxiDAO.getHibernateTemplate().find(sql);
		for(int i=0;i<list.size();i++)
		{
			Object[] b=(Object[])list.get(i);
			int goodsId=Integer.parseInt(b[1].toString());
			
			TGoods goods=goodsDAO.findById(goodsId);
			goodsListpaihang.add(goods);
		}
		if(goodsList.size()>4)
		{
			goodsList=goodsList.subList(0, 4);
		}
		request.put("goodsListpaihang", goodsListpaihang);
		
		
		
		return ActionSupport.SUCCESS;
	}
	
	
	public String goodsDetailQian()
	{
		TGoods goods=goodsDAO.findById(id);
		

		goods.setShifoutejia("no");
		
		goods.setDel("no");
		
		goodsDAO.save(goods);
		
		Map request=(Map)ServletActionContext.getContext().get("request");
		request.put("msg", "信息添加成功");
		return "msg";
	}
	
	
	public String goodsMana()
	{
		String sql="from TGoods where del='no' order by leibieId";
		List goodsList=goodsDAO.getHibernateTemplate().find(sql);
		
		Map request=(Map)ServletActionContext.getContext().get("request");
		request.put("goodsList", goodsList);
		return ActionSupport.SUCCESS;
	}
	
	public String goodsDel()
	{
		TGoods goods=goodsDAO.findById(id);
		goods.setDel("yes");
		
		goodsDAO.attachDirty(goods);
		
		Map request=(Map)ServletActionContext.getContext().get("request");
		request.put("msg", "信息删除成功");
		return "msg";
	}
	
	public String goodsNew()
	{
		String sql="from TGoods where del='no' order by id desc";
		List goodsList=goodsDAO.getHibernateTemplate().find(sql);
		if(goodsList.size()>6)
		{

请添加图片描述
请添加图片描述
请添加图片描述

m0_71463355
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值