商品列表

点击后台管理系统的head.jsp头部的“商品管理”功能选项#xff0c;向服务器发送请求/admin/goods_list

因此需要在servlet包中创建AdminGoodsListServlet类#xff0c;用于获取商品信息列表

…概念

点击后台管理系统的head.jsp头部的“商品管理”功能选项向服务器发送请求/admin/goods_list

因此需要在servlet包中创建AdminGoodsListServlet类用于获取商品信息列表

package

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

java.io.IOException;WebServlet(name

/admin/goods_list)

HttpServlet#doGet(HttpServletRequest

request,

0;//推荐类型if(request.getParameter(type)

null)

{typeInteger.parseInt(request.getParameter(type)

;}int

1;if(request.getParameter(pageNumber)

null)

{pageNumberInteger.parseInt(request.getParameter(pageNumber)

;}catch

e){}}if(pageNumber0)pageNumber1;Page

gService.getGoodsRecommendPage(type,

pageNumber);if(p.getTotalPage()0){p.setTotalPage(1);p.setPageNumber(1);}else

{if(pageNumberp.getTotalPage()1){p

gService.getGoodsRecommendPage(type,

pageNumber);}}request.setAttribute(p,

type);request.getRequestDispatcher(/admin/goods_list.jsp).forward(request,

response);}/***

HttpServlet#doPost(HttpServletRequest

request,

以上代码中接收浏览器请求并判断浏览器是否传递了分类参数商品分类为条幅热销新品等如果没有传递分类参数则默认获取所有商品信息并分页显示将参数传递给业务逻辑层这里功能已经实现了则不再重复赘述。

最后将查询的数据显示在goods_list.jsp页面上

page

urihttp://java.sun.com/jsp/jstl/core

prefixc

classcontainer-fluidjsp:include

page/admin/header.jsp/jsp:includediv

classtext-righta

href/admin/goods_add.jsp添加商品/a/divbrul

roletablist

href/admin/goods_list全部商品/a/lili

c:if

href/admin/goods_list?type1条幅推荐/a/lili

c:if

href/admin/goods_list?type2热销推荐/a/lili

c:if

href/admin/goods_list?type3新品推荐/a/li/ulbrtable

classtable

target_blank${g.name}/a/p/tdtdp${g.intro}/p/tdtdp${g.price}/p/tdtdp${g.type.name}/p/tdtdpc:choosec:when

test${g.isScroll

href/admin/goods_recommend?id${g.id

}methodremovetypeTarget1pageNumber${p.pageNumber}type${type}移出条幅/a/c:whenc:otherwisea

classbtn

href/admin/goods_recommend?id${g.id

}methodaddtypeTarget1pageNumber${p.pageNumber}type${type}加入条幅/a/c:otherwise/c:choosec:choosec:when

test${g.isHot

href/admin/goods_recommend?id${g.id

}methodremovetypeTarget2pageNumber${p.pageNumber}type${type}移出热销/a/c:whenc:otherwisea

classbtn

href/admin/goods_recommend?id${g.id

}methodaddtypeTarget2pageNumber${p.pageNumber}type${type}加入热销/a/c:otherwise/c:choosec:choosec:when

test${g.isNew

href/admin/goods_recommend?id${g.id

}methodremovetypeTarget3pageNumber${p.pageNumber}type${type}移出新品/a/c:whenc:otherwisea

classbtn

href/admin/goods_recommend?id${g.id

}methodaddtypeTarget3pageNumber${p.pageNumber}type${type}加入新品/a/c:otherwise/c:choose/pa

classbtn

href/admin/goods_editshow?id${g.id

pageNumber${p.pageNumber}type${type}修改/aa

classbtn

href/admin/goods_delete?id${g.id

}pageNumber${p.pageNumber}type${type}删除/a/td/tr/c:forEach/tablebrjsp:include

nameurl/jsp:param

以上页面代码中通过分支语句判断每一个商品的类型来区分该商品是加入还是移出的按钮文本信息。

当用户点击条幅推荐热销推荐新品推荐时则还是向以上服务器地址发送请求只不过这里需要携带分类参数。

加入移出分类

每一个商品都有可能加入条幅热销新品等分类加入的了商品也有可能移出条幅热销和新品分类没有任何一个商品永久性的进行促销活动因此每一个商品都有可能进行加入某一个分类或者移出某一个分类。

这里当点击加入或者移出条幅热销和新品分类时向服务器发送请求地址/admin/goods_recommend并携带商品编号页码加入还是移出参数分类参数等等

因此需要在servlet包中创建AdminGoodsRecommendServlet类完成以上功能

package

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

java.io.IOException;WebServlet(name

admin_goods_recommend,urlPatterns

public

HttpServlet#doGet(HttpServletRequest

request,

Integer.parseInt(request.getParameter(id));String

method

request.getParameter(method);int

typeTargetInteger.parseInt(request.getParameter(typeTarget));if(method.equals(add))

typeTarget);}else

typeTarget);}request.getRequestDispatcher(/admin/goods_list).forward(request,

response);}/***

HttpServlet#doPost(HttpServletRequest

request,

以上代码中根据浏览器传递的method参数是add还是remove还区分是加入分类还是移出分类操作这里需要将参数信息发送给业务逻辑层执行

//将某个商品分类添加至标识

QueryRunner(DataSourceUtils.getDataSource());String

sql

values(?,?);r.update(sql,type,id);

public

QueryRunner(DataSourceUtils.getDataSource());String

sql

goods_id?;r.update(sql,type,id);

添加新商品

点击商品列表页面中的“添加商品”按钮跳转至goods_add.jsp页面

page

urihttp://java.sun.com/jsp/jstl/core

prefixc

classcontainer-fluidjsp:include

page/admin/header.jsp/jsp:includebrbrform

classform-horizontal

}/option/c:forEach/select/div/divdiv

classform-groupdiv

btn-success提交保存/button/div/div/form

/div

当管理员填写商品信息并上传商品图片后点击“提交保存”按钮将所有信息提交给服务器/admin/goods_add

因此需要在servlet包中创建AdminGoodsAddServlet类

package

org.apache.commons.fileupload.FileItem;

import

org.apache.commons.fileupload.FileUploadException;

import

org.apache.commons.fileupload.disk.DiskFileItemFactory;

import

org.apache.commons.fileupload.servlet.ServletFileUpload;

import

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

HttpServlet#doGet(HttpServletRequest

request,

DiskFileItemFactory();ServletFileUpload

upload

upload.parseRequest(request);Goods

new

name:g.setName(item.getString(utf-8));break;case

price:g.setPrice(Integer.parseInt(item.getString(utf-8)));break;case

intro:g.setIntro(item.getString(utf-8));break;case

stock:g.setStock(Integer.parseInt(item.getString(utf-8)));break;case

typeid:g.setTypeid(Integer.parseInt(item.getString(utf-8)));break;}}else

{if(item.getInputStream().available()0)continue;String

fileName

fileName.substring(fileName.lastIndexOf(.));fileName

/new

Date().getTime()fileName;String

path

this.getServletContext().getRealPath(/picture)fileName;InputStream

item.getInputStream();FileOutputStream

out

{out.write(buffer);}in.close();out.close();item.delete();switch(item.getFieldName())

{case

cover:g.setCover(/picturefileName);break;case

image1:g.setImage1(/picturefileName);break;case

image2:g.setImage2(/picturefileName);break;}}}gService.insert(g);request.getRequestDispatcher(/admin/goods_list).forward(request,

response);}

blocke.printStackTrace();}}/***

see

HttpServlet#doPost(HttpServletRequest

request,

以上代码中接收新商品的所有信息通过request请求对象获得所有表单属性并通过分支语句区分不同的表单数据对上传的图片做单独的处理使用当前的实时时间拼接图片名称作为图片的新名称并将上传的图片指定存储在项目资源的picture文件夹中接着将商品信息封装在goods对象中发送给业务逻辑层执行

//添加新商品信息

QueryRunner(DataSourceUtils.getDataSource());String

sql

goods(name,cover,image1,image2,price,intro,stock,type_id)

values(?,?,?,?,?,?,?,?);r.update(sql,g.getName(),g.getCover(),g.getImage1(),g.getImage2(),g.getPrice(),g.getIntro(),g.getStock(),g.getType().getId());

修改商品信息

在商品列表页面中选择要修改的商品中的“修改”按钮向服务器发送请求地址/admin/goods_editshow并携带商品编号页码以及分类参数

因此需要在servlet包中创建AdminGoodsEditshowServelt类

package

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

java.io.IOException;WebServlet(name

admin_goods_editshow,urlPatterns

public

HttpServlet#doGet(HttpServletRequest

request,

Integer.parseInt(request.getParameter(id));Goods

gService.getGoodsById(id);request.setAttribute(g,

g);request.getRequestDispatcher(/admin/goods_edit.jsp).forward(request,

response);}/***

HttpServlet#doPost(HttpServletRequest

request,

以上代码中接收浏览器要修改的商品编号作为查询条件将要修改的商品的信息从数据库中查询出来并显示在goods_edit.jsp修改页面上

page

urihttp://java.sun.com/jsp/jstl/core

prefixc

classcontainer-fluidjsp:include

page/admin/header.jsp/jsp:includebrbrform

classform-horizontal

enctypemultipart/form-datainput

typehidden

src${pageContext.request.contextPath

}${g.cover

src${pageContext.request.contextPath

}${g.image1

src${pageContext.request.contextPath

}${g.image2

}/option/c:forEach/select/div/divdiv

classform-groupdiv

btn-success提交修改/button/div/div/form

/div

当管理员在该页面上修改了商品信息后将更新后的商品信息提交给服务器地址/admin/goods_edit

因此需要在servlet包中创建AdminGoodsEditServlet类

package

org.apache.commons.fileupload.FileItem;

import

org.apache.commons.fileupload.FileUploadException;

import

org.apache.commons.fileupload.disk.DiskFileItemFactory;

import

org.apache.commons.fileupload.servlet.ServletFileUpload;

import

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

HttpServlet#doGet(HttpServletRequest

request,

DiskFileItemFactory();ServletFileUpload

upload

upload.parseRequest(request);Goods

new

id:g.setId(Integer.parseInt(item.getString(utf-8)));break;case

name:g.setName(item.getString(utf-8));break;case

price:g.setPrice(Float.parseFloat(item.getString(utf-8)));break;case

intro:g.setIntro(item.getString(utf-8));break;case

cover:g.setCover(item.getString(utf-8));break;case

image1:g.setImage1(item.getString(utf-8));break;case

image2:g.setImage2(item.getString(utf-8));break;case

stock:g.setStock(Integer.parseInt(item.getString(utf-8)));break;case

typeid:g.setTypeid(Integer.parseInt(item.getString(utf-8)));break;case

pageNumber:pageNumberInteger.parseInt(item.getString(utf-8));break;case

type:type

Integer.parseInt(item.getString(utf-8));break;}}else

{if(item.getInputStream().available()0)continue;String

fileName

fileName.substring(fileName.lastIndexOf(.));fileName

/new

Date().getTime()fileName;String

path

this.getServletContext().getRealPath(/picture)fileName;InputStream

item.getInputStream();FileOutputStream

out

{out.write(buffer);}in.close();out.close();item.delete();switch(item.getFieldName())

{case

cover:g.setCover(/picturefileName);break;case

image1:g.setImage1(/picturefileName);break;case

image2:g.setImage2(/picturefileName);break;}}}gService.update(g);request.getRequestDispatcher(/admin/goods_list?pageNumberpageNumbertypetype).forward(request,

response);}

blocke.printStackTrace();}}/***

see

HttpServlet#doPost(HttpServletRequest

request,

以上代码中所执行的代码基本和添加新商品的代码执行功能类似只是该功能不是添加至数据库而是修改已存在的商品信息。

//修改商品信息

QueryRunner(DataSourceUtils.getDataSource());String

sql

name?,cover?,image1?,image2?,price?,intro?,stock?,type_id?

where

id?;r.update(sql,g.getName(),g.getCover(),g.getImage1(),g.getImage2(),g.getPrice(),g.getIntro(),g.getStock(),g.getType().getId(),g.getId());

删除商品

在商品列表页面中选择要删除的商品中的“删除”按钮向服务器发送请求/admin/goods_delete

因此需要在servlet包中创建AdminGoodsDeleteServlet类

package

javax.servlet.ServletException;

import

javax.servlet.annotation.WebServlet;

import

javax.servlet.http.HttpServlet;

import

javax.servlet.http.HttpServletRequest;

import

javax.servlet.http.HttpServletResponse;

import

java.io.IOException;WebServlet(name

/admin/goods_delete)

HttpServlet#doGet(HttpServletRequest

request,

Integer.parseInt(request.getParameter(id));gService.delete(id);request.getRequestDispatcher(/admin/goods_list).forward(request,

response);}/***

HttpServlet#doPost(HttpServletRequest

request,

以上代码中接收浏览器发送的商品编号发送给业务逻辑层执行删除成功后刷新商品列表页面

//根据id删除商品信息

QueryRunner(DataSourceUtils.getDataSource());String

sql

到此本项目所有功能讲解完毕该项目还有很大的功能扩充和代码优化的空间读者可以自行优化和更新该项目的功能。