基于javaweb的JSP+Servlet花店商城系统(java+servlet+jsp+jdbc+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb的JSP+Servlet花店商城系统(java+servlet+jsp+jdbc+mysql)

项目介绍

网上花店销售系统采用JSP+Servlet+JavaBean的MVC模式，将数据对象、业务逻辑以及用户界面分离。该系统分为用户和管理员两个角色。 用户注册登录后可以浏览鲜花，浏览公告，购买鲜花，管理员登录后可以对系统进行管理和维护。

环境需要

1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS；  5.数据库：MySql 5.7版本； 6.是否Maven项目: 否；

技术栈

Servlet、JSP、JDBC、MySQL5.7、Tomcat8

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 使用IDEA/Eclipse/MyEclipse导入项目，然后运行； 3. 将项目中src/com/dao/DB.java配置文件中的数据库配置改为自己的配置; 4. 运行项目，在浏览器中输入地址； 前台地址：http://localhost:8080/flowerstore/ 普通社员账号：zhangsan 密码：123456 

后台地址：http://localhost:8080/flowerstore/manage/login.jsp 管理员账号：admin 密码：123456  

}

//删除分类信息操作
else if("fenleidelete".equals(method)){
	//通过ID获取对象
	String id = request.getParameter("id");
	Fenlei bean = fenleiDao.selectBean(" where id= "+id);
	//删除对象
	fenleiDao.deleteBean(bean);

}

//跳转到查看分类信息页面
else if("fenleiupdate3".equals(method)){
	request.setAttribute("biaoti", "查看分类信息");
	//通过ID获取对象
	String id = request.getParameter("id");
	Fenlei bean = fenleiDao.selectBean(" where id= "+id);
	//把对象传给jsp页面
	request.setAttribute("bean", bean);
	RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/fenlei/fenleiupdate3.jsp");
	dispatcher.forward(request, response);
}


//商品信息列表
else if("productlist".equals(method)){
	
	//定义跳转的地址
	url = "manageServlet/productlist";
	
	//获取查询的信息
	String fname = request.getParameter("fname");	
	request.setAttribute("fenleilist", fenleiDao.getList(""));
	String pname = request.getParameter("pname");	
	
	//组装查询的SQL语句
	StringBuffer sb = new StringBuffer();
	sb.append(" where  ");
	
	if(fname!=null&&!"".equals(fname)){
					
		sb.append(" fname like '%"+fname+"%' ");

	if(request.getParameter("pagenum")!=null){
		pagenum = Integer.parseInt(request.getParameter("pagenum"));
	}

	//从数据库查询列表信息，带分页功能
	Map<String,List<Gonggao>> map = gonggaoDao.getList(pagenum,pagesize,url,where);
	String pagerinfo = map.keySet().iterator().next();
	List<Gonggao> list = map.get(pagerinfo);
	
	//返回给jsp页面的信息
	request.setAttribute("pagerinfo", pagerinfo);
	request.setAttribute("list", list);
	request.setAttribute("biaoti", "公告信息列表");
	request.setAttribute("url", "manageServlet/gonggaolist");
	request.setAttribute("url2", "manageServlet/gonggao");
	
	
	
	//定义跳转的地址
	RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaolist.jsp");
	//跳转操作
	dispatcher.forward(request, response);
}


//跳转到添加公告信息页面
else if("gonggaoadd".equals(method)){
	request.setAttribute("biaoti", "添加公告信息");
	request.setAttribute("url", "manageServlet/gonggaoadd2");
	RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaoadd.jsp");
	dispatcher.forward(request, response);
}

//添加公告信息操作
else if("gonggaoadd2".equals(method)){

	//从JSP获取信息
	String biaoti = request.getParameter("biaoti");
	String neirong = request.getParameter("neirong");
	//定义对象
	Gonggao bean = new Gonggao();
	//设置对象的属性
	bean.setBiaoti(biaoti);
	bean.setNeirong(neirong);
	bean.setShijian(Util.getTime());
	//插入数据库
	gonggaoDao.insertBean(bean);
	//返回给JSP页面

String dianhua = request.getParameter("dianhua");
String dizhi = request.getParameter("dizhi");
String beizhu = request.getParameter("beizhu");

Dingdan bean = new Dingdan();

bean.setBeizhu(beizhu);
bean.setDianhua(dianhua);
bean.setDizhi(dizhi);
bean.setOrderid(Util.getTime2());
bean.setShijian(Util.getTime());
bean.setStatus("未处理");
bean.setUserid(Integer.parseInt(userid));
bean.setXingming(xingming);
		

//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where  ");

HttpSession session = request.getSession();
User user = (User) session.getAttribute("user");

sb.append(" userid="+user.getId()+" order by id desc ");
String where = sb.toString();

//获取当前的页数
if(request.getParameter("pagenum")!=null){
	pagenum = Integer.parseInt(request.getParameter("pagenum"));
}

//从数据库查询列表信息，带分页功能
Map<String,List<Gouwuche>> map = gouwucheDao.getList(1,999,url,where);
String pagerinfo = map.keySet().iterator().next();
List<Gouwuche> list = map.get(pagerinfo);

StringBuffer sbsb = new StringBuffer();
double zongjia = 0;
for(Gouwuche g:list){
	sbsb.append("商品名："+g.getPname()+",单价:"+g.getJiage()+",购买数量："+g.getShuliang()+",小计："+(g.getJiage()*g.getShuliang())+"<br/>");

//跳转到生成订单页面
else if("dingdanadd".equals(method)){
	HttpSession session = request.getSession();
	User user = (User) session.getAttribute("user");
	
	User bean = userDao.selectBean(" where id= "+user.getId());
	
	
	request.setAttribute("bean", bean);
	
	RequestDispatcher dispatcher = request.getRequestDispatcher("/dingdanadd.jsp");
	dispatcher.forward(request, response);
}

//生成订单操作
else if("dingdanadd2".equals(method)){

	
	//从JSP获取信息
	String userid = request.getParameter("userid");
	String xingming = request.getParameter("xingming");
	String dianhua = request.getParameter("dianhua");
	String dizhi = request.getParameter("dizhi");
	String beizhu = request.getParameter("beizhu");
	
	Dingdan bean = new Dingdan();
	
	bean.setBeizhu(beizhu);
	bean.setDianhua(dianhua);
	bean.setDizhi(dizhi);
	bean.setOrderid(Util.getTime2());
	bean.setShijian(Util.getTime());
	bean.setStatus("未处理");
	bean.setUserid(Integer.parseInt(userid));
	bean.setXingming(xingming);

	
	//组装查询的SQL语句
	StringBuffer sb = new StringBuffer();
	sb.append(" where  ");
	

	dispatcher.forward(request, response);
}

//更新分类信息操作
else if("fenleiupdate2".equals(method)){
	
	//从JSP获取信息
	String fname = request.getParameter("fname");
	//通过ID获取对象
	String id = request.getParameter("id");
	Fenlei bean = fenleiDao.selectBean(" where id= "+id);
	//更新对象属性
	bean.setFname(fname);
	//更新操作
	fenleiDao.updateBean(bean);
	
	
}

//删除分类信息操作
else if("fenleidelete".equals(method)){
	//通过ID获取对象
	String id = request.getParameter("id");
	Fenlei bean = fenleiDao.selectBean(" where id= "+id);
	//删除对象
	fenleiDao.deleteBean(bean);

}

//跳转到查看分类信息页面
else if("fenleiupdate3".equals(method)){
	request.setAttribute("biaoti", "查看分类信息");
	//通过ID获取对象
	String id = request.getParameter("id");
	Fenlei bean = fenleiDao.selectBean(" where id= "+id);
	//把对象传给jsp页面
	request.setAttribute("bean", bean);
	RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/fenlei/fenleiupdate3.jsp");
	dispatcher.forward(request, response);
}

	request.setAttribute("fenleilist", fenleiDao.getList(""));
	//把信息传给jsp页面
	request.setAttribute("bean", bean);
	request.setAttribute("biaoti", "更新商品信息");
	request.setAttribute("url", "manageServlet/productupdate2?id="+bean.getId());
	RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/product/productupdate.jsp");
	dispatcher.forward(request, response);
}

//更新商品信息操作
else if("productupdate2".equals(method)){
	
	//从JSP获取信息
	String fenleiid = request.getParameter("fenleiid");
	String imgpath = request.getParameter("imgpath");
	String jiage = request.getParameter("jiage");
	String miaoshu = request.getParameter("miaoshu");
	String pname = request.getParameter("pname");
	Fenlei fenlei = fenleiDao.selectBean(" where id= "+fenleiid);
	
	//通过ID获取对象
	String id = request.getParameter("id");
	Product bean = productDao.selectBean(" where id= "+id);
	//更新对象属性
	bean.setFenleiid(fenlei.getId()+"");
	bean.setFname(fenlei.getFname());
	bean.setImgpath(imgpath);
	bean.setJiage(Double.parseDouble(jiage));
	bean.setMiaoshu(miaoshu);
	bean.setPname(pname);
	//更新操作
	productDao.updateBean(bean);
	
	
}


//跳转到上传商品图片页面
else if("productupdate5".equals(method)){
	
	//通过ID获取对象

---

项目链接：
https://javayms.github.io?id=121023501103200zs
https://javayms.pages.dev?id=121023501103200zs