基于javaweb+mysql的jsp+servlet花店商城系统(java+servlet+jsp+jdbc+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的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
使用说明
- 使用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
if(jiage1!=null&&!"".equals(jiage1)){
sb.append(" jiage >= "+jiage1+"");
sb.append(" and ");
request.setAttribute("jiage1", jiage1);
}
if(jiage2!=null&&!"".equals(jiage2)){
sb.append(" jiage <= "+jiage2+"");
sb.append(" and ");
request.setAttribute("jiage2", jiage2);
}
if(pname!=null&&!"".equals(pname)){
sb.append(" pname like '%"+pname+"%' ");
sb.append(" and ");
request.setAttribute("pname", pname);
}
if(fenleiid!=null&&!"".equals(fenleiid)){
sb.append(" fenleiid like '%"+fenleiid+"%' ");
sb.append(" and ");
request.setAttribute("fenleiid", fenleiid);
}
if(tuijian!=null&&!"".equals(tuijian)){
sb.append(" tuijian = '已推荐' ");
sb.append(" and ");
request.setAttribute("tuijian", tuijian);
}
sb.append(" 1=1 order by id desc ");
String where = sb.toString();
ProductDao productDao = new ProductDao();
GonggaoDao gonggaoDao = new GonggaoDao();
GouwucheDao gouwucheDao = new GouwucheDao();
DingdanDao dingdanDao = new DingdanDao();
//新用户注册
if("register".equals(method)){
//从jsp页面获取用户名和密码
String username = request.getParameter("username");
String password = request.getParameter("password");
String xingming = request.getParameter("xingming");
String dianhua = request.getParameter("dianhua");
String dizhi = request.getParameter("dizhi");
//查询该用户名是否已经注册
User bean = userDao.selectBean(" where username='"+username+"' ");
if(bean==null){
bean = new User();
bean.setDianhua(dianhua);
bean.setDizhi(dizhi);
bean.setPassword(password);
bean.setRole(0);
bean.setUsername(username);
bean.setXingming(xingming);
userDao.insertBean(bean);
}else{
}
}
//用户登录
else if("login".equals(method)){
//从jsp页面获取用户名和密码
String username = request.getParameter("username");
String password = request.getParameter("password");
//查询用户名和密码是否匹配
User bean = userDao.selectBean(" where username='"+username+"' and password ='"+password+"' and role=0 ");
if(bean!=null){
HttpSession session = request.getSession();
}
//跳转到修改密码页面
else if("passwordupdate".equals(method)){
request.setAttribute("biaoti", "修改密码");
request.setAttribute("url", "manageServlet/passwordupdate2");
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/passwordupdate.jsp");
dispatcher.forward(request, response);
}
//修改密码操作
else if("passwordupdate2".equals(method)){
//从JSP获取信息
String password1 = request.getParameter("password1");
String password2 = request.getParameter("password2");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("manage");
User u = userDao.selectBean(" where username='"+user.getUsername()+"' and password='"+password1+"' ");
if(u!=null){
u.setPassword(password2);
userDao.updateBean(u);
}else{
}
}
//分类信息列表
else if("fenleilist".equals(method)){
//定义跳转的地址
url = "manageServlet/fenleilist";
//获取查询的信息
String fname = request.getParameter("fname");
//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where ");
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获取对象
String id = request.getParameter("id");
Product bean = productDao.selectBean(" where id= "+id);
//把信息传给jsp页面
request.setAttribute("bean", bean);
request.setAttribute("biaoti", "上传商品图片");
request.setAttribute("url", "manageServlet/productupdate6?id="+bean.getId());
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/product/productupdate5.jsp");
dispatcher.forward(request, response);
}
//上传商品图片操作
else if("productupdate6".equals(method)){
SmartUpload su = new SmartUpload();
su.initialize(this.getServletConfig(), request, response);
//限制上传文件的最大长度。
su.setMaxFileSize(1500000*8);
//设定允许上传的文件（通过扩展名限制）
su.setAllowedFilesList("jpeg,png,PNG,jpg,gif,bmp,JPG,GIF,BMP");
String imgpath="";
try {
// 上传文件
su.upload();
// 将上传文件全部保存到指定目录
com.jspsmart.upload.File file = su.getFiles().getFile(0);
if (!file.isMissing())
{
//将附件以 当前时间+附件扩展名 作为文件名保存
//后台servlet，用于处理后台的所有请求
public class ManageServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置获取的参数的编码格式
request.setCharacterEncoding("utf-8");
//获取绝对地址
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
//设置响应输出的字符串格式
response.setCharacterEncoding("utf-8");response.setContentType("text/html; charset=utf-8");
//获取输出对象
PrintWriter writer = response.getWriter();
//获取页面请求地址
String uri = request.getRequestURI();
String[] s = uri.split("/");
String method = s[3];
//初始化跳转的地址
String url ="";
//从数据库查询列表信息，带分页功能
Map<String,List<Fenlei>> map = fenleiDao.getList(pagenum,pagesize,url,where);
String pagerinfo = map.keySet().iterator().next();
List<Fenlei> list = map.get(pagerinfo);
//返回给jsp页面的信息
request.setAttribute("pagerinfo", pagerinfo);
request.setAttribute("list", list);
request.setAttribute("biaoti", "分类信息列表");
request.setAttribute("url", "manageServlet/fenleilist");
request.setAttribute("url2", "manageServlet/fenlei");
//定义跳转的地址
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/fenlei/fenleilist.jsp");
//跳转操作
dispatcher.forward(request, response);
}
//跳转到添加分类信息页面
else if("fenleiadd".equals(method)){
request.setAttribute("biaoti", "添加分类信息");
request.setAttribute("url", "manageServlet/fenleiadd2");
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/fenlei/fenleiadd.jsp");
dispatcher.forward(request, response);
}
//添加分类信息操作
else if("fenleiadd2".equals(method)){
//从JSP获取信息
String fname = request.getParameter("fname");
//定义对象
Fenlei bean = new Fenlei();
//设置对象的属性
bean.setFname(fname);
//插入数据库
fenleiDao.insertBean(bean);
//返回给JSP页面
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置获取的参数的编码格式
request.setCharacterEncoding("utf-8");
//获取绝对地址
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
//设置响应输出的字符串格式
response.setCharacterEncoding("utf-8");response.setContentType("text/html; charset=utf-8");
//获取输出对象
PrintWriter writer = response.getWriter();
//获取页面请求地址
String uri = request.getRequestURI();
String[] s = uri.split("/");
String method = s[3];
//初始化跳转的地址
String url ="";
int pagenum = 1;//当前页
int pagesize = 15;//每页显示的数量
//初始化调用的数据库操作对象
UserDao userDao = new UserDao();
FenleiDao fenleiDao = new FenleiDao();
ProductDao productDao = new ProductDao();
//设置对象的属性
bean.setCreatetime(Util.getTime());
bean.setDianjishu(0);
bean.setFenleiid(fenlei.getId()+"");
bean.setFname(fenlei.getFname());
bean.setJiage(Double.parseDouble(jiage));
bean.setMiaoshu(miaoshu);
bean.setPname(pname);
bean.setTuijian("未推荐");
bean.setXiaoliang(0);
//插入数据库
productDao.insertBean(bean);
//返回给JSP页面
}
//跳转到更新商品信息页面
else if("productupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Product bean = productDao.selectBean(" where id= "+id);
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));
request.setAttribute("orderid", orderid);
}
if(status!=null&&!"".equals(status)){
sb.append(" status like '%"+status+"%' ");
sb.append(" and ");
request.setAttribute("status", status);
}
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<Dingdan>> map = dingdanDao.getList(pagenum,pagesize,url,where);
String pagerinfo = map.keySet().iterator().next();
List<Dingdan> list = map.get(pagerinfo);
//返回给jsp页面的信息
request.setAttribute("pagerinfo", pagerinfo);
request.setAttribute("list", list);
//定义跳转的地址
RequestDispatcher dispatcher = request.getRequestDispatcher("/orderlist.jsp");
//跳转操作
dispatcher.forward(request, response);
}
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页面
}
//跳转到更新公告信息页面
else if("gonggaoupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//把对象传给jsp页面
request.setAttribute("bean", bean);
request.setAttribute("biaoti", "更新公告信息");
request.setAttribute("url", "manageServlet/gonggaoupdate2?id="+bean.getId());
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaoupdate.jsp");
dispatcher.forward(request, response);
}
//更新公告信息操作
else if("gonggaoupdate2".equals(method)){
//从JSP获取信息
String biaoti = request.getParameter("biaoti");
String neirong = request.getParameter("neirong");
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//更新对象属性
bean.setBiaoti(biaoti);
bean.setNeirong(neirong);
//更新操作
gonggaoDao.updateBean(bean);
}
//删除公告信息操作
else if("gonggaodelete".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
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页面
}
//跳转到更新公告信息页面
else if("gonggaoupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//把对象传给jsp页面
request.setAttribute("bean", bean);
request.setAttribute("biaoti", "更新公告信息");
request.setAttribute("url", "manageServlet/gonggaoupdate2?id="+bean.getId());
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaoupdate.jsp");
dispatcher.forward(request, response);
}
//更新公告信息操作
else if("gonggaoupdate2".equals(method)){
//从JSP获取信息
String biaoti = request.getParameter("biaoti");
String neirong = request.getParameter("neirong");
//通过ID获取对象
public class ManageServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置获取的参数的编码格式
request.setCharacterEncoding("utf-8");
//获取绝对地址
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
//设置响应输出的字符串格式
response.setCharacterEncoding("utf-8");response.setContentType("text/html; charset=utf-8");
//获取输出对象
PrintWriter writer = response.getWriter();
//获取页面请求地址
String uri = request.getRequestURI();
String[] s = uri.split("/");
String method = s[3];
//初始化跳转的地址
String url ="";
int pagenum = 1;//当前页
}
package servlet;
//首页Servlet
public class ShouyeServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置获取的参数的编码格式
request.setCharacterEncoding("utf-8");
String url = "shouye";
if(request.getParameter("pagenum")!=null){
pagenum = Integer.parseInt(request.getParameter("pagenum"));
}
StringBuffer sb = new StringBuffer();
sb.append(" where ");
if(jiage1!=null&&!"".equals(jiage1)){
sb.append(" jiage >= "+jiage1+"");
sb.append(" and ");
request.setAttribute("jiage1", jiage1);
}
if(jiage2!=null&&!"".equals(jiage2)){
sb.append(" jiage <= "+jiage2+"");
sb.append(" and ");
request.setAttribute("jiage2", jiage2);
}
if(pname!=null&&!"".equals(pname)){
sb.append(" pname like '%"+pname+"%' ");
sb.append(" and ");
request.setAttribute("pname", pname);
}
if(fenleiid!=null&&!"".equals(fenleiid)){
sb.append(" fenleiid like '%"+fenleiid+"%' ");
sb.append(" and ");
request.setAttribute("fenleiid", fenleiid);
}
}
}
package servlet;
//后台servlet，用于处理前台的所有请求
public class IndexServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void destroy() {
super.destroy();
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
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页面
}
//跳转到更新公告信息页面
else if("gonggaoupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//把对象传给jsp页面
request.setAttribute("bean", bean);
request.setAttribute("biaoti", "更新公告信息");
request.setAttribute("url", "manageServlet/gonggaoupdate2?id="+bean.getId());
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaoupdate.jsp");
dispatcher.forward(request, response);
}
//更新公告信息操作
else if("gonggaoupdate2".equals(method)){
//从JSP获取信息
String biaoti = request.getParameter("biaoti");
String neirong = request.getParameter("neirong");
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//更新对象属性
userDao.deleteBean(bean);
}
}
}
package servlet;
//后台servlet，用于处理前台的所有请求
public class IndexServlet extends HttpServlet {
//从JSP获取信息
String fname = request.getParameter("fname");
//定义对象
Fenlei bean = new Fenlei();
//设置对象的属性
bean.setFname(fname);
//插入数据库
fenleiDao.insertBean(bean);
//返回给JSP页面
}
//跳转到更新分类信息页面
else if("fenleiupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Fenlei bean = fenleiDao.selectBean(" where id= "+id);
//把对象传给jsp页面
request.setAttribute("bean", bean);
request.setAttribute("biaoti", "更新分类信息");
request.setAttribute("url", "manageServlet/fenleiupdate2?id="+bean.getId());
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/fenlei/fenleiupdate.jsp");
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获取对象
}
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
this.doPost(req, resp);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置获取的参数的编码格式
request.setCharacterEncoding("utf-8");
//获取绝对地址
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
//设置响应输出的字符串格式
response.setCharacterEncoding("utf-8");response.setContentType("text/html; charset=utf-8");
//获取输出对象
PrintWriter writer = response.getWriter();
//获取页面请求地址
String uri = request.getRequestURI();
String[] s = uri.split("/");
String method = s[3];
//初始化跳转的地址
String url ="";
int pagenum = 1;//当前页
int pagesize = 15;//每页显示的数量
//初始化调用的数据库操作对象
UserDao userDao = new UserDao();
ProductDao productDao = new ProductDao();
GonggaoDao gonggaoDao = new GonggaoDao();
GouwucheDao gouwucheDao = new GouwucheDao();
DingdanDao dingdanDao = new DingdanDao();
//新用户注册
if("register".equals(method)){
//从jsp页面获取用户名和密码
String username = request.getParameter("username");
String password = request.getParameter("password");
String xingming = request.getParameter("xingming");
//商品信息列表
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+"%' ");
sb.append(" and ");
request.setAttribute("fname", fname);
}
if(pname!=null&&!"".equals(pname)){
sb.append(" pname like '%"+pname+"%' ");
sb.append(" and ");
request.setAttribute("pname", pname);
}
sb.append(" 1=1 order by id desc ");
String where = sb.toString();
//获取当前的页数
if(request.getParameter("pagenum")!=null){
pagenum = Integer.parseInt(request.getParameter("pagenum"));
}
bean.setShuliang(Integer.parseInt(number));
gouwucheDao.updateBean(bean);
}
//删除购买的商品操作
else if("gouwuchedelete".equals(method)){
String id = request.getParameter("id");
Gouwuche bean = gouwucheDao.selectBean(" where id= "+id);
gouwucheDao.deleteBean(bean);
}
//跳转到生成订单页面
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 orderid = request.getParameter("orderid");
String status = request.getParameter("status");
//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where ");
if(orderid!=null&&!"".equals(orderid)){
sb.append(" orderid like '%"+orderid+"%' ");
sb.append(" and ");
request.setAttribute("orderid", orderid);
}
if(status!=null&&!"".equals(status)){
sb.append(" status like '%"+status+"%' ");
sb.append(" and ");
request.setAttribute("status", status);
}
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<Dingdan>> map = dingdanDao.getList(pagenum,pagesize,url,where);
String pagerinfo = map.keySet().iterator().next();
List<Dingdan> list = map.get(pagerinfo);
//返回给jsp页面的信息
}
//跳转到查看公告信息页面
else if("gonggaoupdate3".equals(method)){
request.setAttribute("biaoti", "查看公告信息");
//通过ID获取对象
String id = request.getParameter("id");
Gonggao bean = gonggaoDao.selectBean(" where id= "+id);
//把对象传给jsp页面
request.setAttribute("bean", bean);
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/gonggao/gonggaoupdate3.jsp");
dispatcher.forward(request, response);
}
//订单信息列表
else if("dingdanlist".equals(method)){
//定义跳转的地址
url = "manageServlet/dingdanlist";
//获取查询的信息
String status = request.getParameter("status");
String orderid = request.getParameter("orderid");
//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where ");
if(orderid!=null&&!"".equals(orderid)){
sb.append(" orderid like '%"+orderid+"%' ");
sb.append(" and ");
request.setAttribute("orderid", orderid);
}
if(status!=null&&!"".equals(status)){
Fenlei fenlei = fenleiDao.selectBean(" where id= "+fenleiid);
//定义对象
Product bean = new Product();
//设置对象的属性
bean.setCreatetime(Util.getTime());
bean.setDianjishu(0);
bean.setFenleiid(fenlei.getId()+"");
bean.setFname(fenlei.getFname());
bean.setJiage(Double.parseDouble(jiage));
bean.setMiaoshu(miaoshu);
bean.setPname(pname);
bean.setTuijian("未推荐");
bean.setXiaoliang(0);
//插入数据库
productDao.insertBean(bean);
//返回给JSP页面
}
//跳转到更新商品信息页面
else if("productupdate".equals(method)){
//通过ID获取对象
String id = request.getParameter("id");
Product bean = productDao.selectBean(" where id= "+id);
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获取对象
request.setAttribute("biaoti", "修改密码");
request.setAttribute("url", "manageServlet/passwordupdate2");
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/passwordupdate.jsp");
dispatcher.forward(request, response);
}
//修改密码操作
else if("passwordupdate2".equals(method)){
//从JSP获取信息
String password1 = request.getParameter("password1");
String password2 = request.getParameter("password2");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("manage");
User u = userDao.selectBean(" where username='"+user.getUsername()+"' and password='"+password1+"' ");
if(u!=null){
u.setPassword(password2);
userDao.updateBean(u);
}else{
}
}
//分类信息列表
else if("fenleilist".equals(method)){
//定义跳转的地址
url = "manageServlet/fenleilist";
//获取查询的信息
String fname = request.getParameter("fname");
//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where ");
if(fname!=null&&!"".equals(fname)){
sb.append(" fname like '%"+fname+"%' ");
sb.append(" and ");
request.setAttribute("fname", fname);
}
sb.append(" 1=1 order by id desc ");
String where = sb.toString();
//获取当前的页数
if(request.getParameter("pagenum")!=null){
pagenum = Integer.parseInt(request.getParameter("pagenum"));
}
//跳转到修改密码页面
else if("passwordupdate".equals(method)){
request.setAttribute("biaoti", "修改密码");
request.setAttribute("url", "manageServlet/passwordupdate2");
RequestDispatcher dispatcher = request.getRequestDispatcher("/manage/passwordupdate.jsp");
dispatcher.forward(request, response);
}
//修改密码操作
else if("passwordupdate2".equals(method)){
//从JSP获取信息
String password1 = request.getParameter("password1");
String password2 = request.getParameter("password2");
HttpSession session = request.getSession();
User user = (User)session.getAttribute("manage");
User u = userDao.selectBean(" where username='"+user.getUsername()+"' and password='"+password1+"' ");
if(u!=null){
u.setPassword(password2);
userDao.updateBean(u);
}else{
}
}
//分类信息列表
else if("fenleilist".equals(method)){
//定义跳转的地址
url = "manageServlet/fenleilist";
//获取查询的信息
String fname = request.getParameter("fname");
//组装查询的SQL语句
StringBuffer sb = new StringBuffer();
sb.append(" where ");
扫一扫
326
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
