基于javaweb+mysql的jsp+servlet婚品婚纱商城系统(java+servlet+jsp+javascript+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet婚品婚纱商城系统(java+servlet+jsp+javascript+mysql)
一、项目运行
运行环境
jdk8+tomcat8+mysql+IntelliJ IDEA( Eclispe , MyEclispe ,Sts 都支持,代码与开发环境运行无关啦,只需要调整环境即可)
项目技术
Servlet、JSP 、、MySQL 、 Ajax 、JavaScript、CSS、等等
}
//删除信息
public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code = request.getParameter("code");
String[] ids = request.getParameterValues("id");
//执行
service.delete(code, ids);
switch (code) {
case "user":
//若code是user时,跳转到会员查询所有页面
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=user");
break;
case "product":
//若code是product时,跳转到商品查询所有页面
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=product");
break;
case "order":
//若code是order时,跳转到订单查询所有页面
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=order");
break;
case "category":
//若code是order时,跳转到订单查询所有页面
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=category");
break;
}
}
//上架商品
public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Product product = new Product();
try {
//将生日String转换成Date类型
ConvertUtils.register(new Converter() {
//实现类型转换,第一个参数:目标数据类型 第二个参数:需要转换的数据
@Override
public Object convert(Class cla, Object value) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date date = null;
try {
Cart cart = (Cart)session.getAttribute("cart");
//2.获取购物车中的map集合(购物车明细)
Map<String, CartItem> cartMap = cart.getMap();
//3.重新计算总金额 = 原来购物车的总金额 - 当前移除的购物项的小计
double total = cart.getTotal() - cartMap.get(pid).getSubTotal();
//4.购物车移除当前购物项
cartMap.remove(pid);
//5.封装Cart对象
cart.setTotal(total);
//6.添加至会话中
session.setAttribute("cart",cart);
//7.跳转cart.jsp 避免重复提交表单
response.sendRedirect("cart.jsp");
}
//清空购物车
public void clearCart(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
//清除会话中的购物车信息
session.removeAttribute("cart");
response.sendRedirect("cart.jsp");
}
}
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=order");
break;
case "category":
//若code是order时,跳转到订单查询所有页面
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=category");
break;
}
}
//上架商品
public void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Product product = new Product();
try {
//将生日String转换成Date类型
ConvertUtils.register(new Converter() {
//实现类型转换,第一个参数:目标数据类型 第二个参数:需要转换的数据
@Override
public Object convert(Class cla, Object value) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date date = null;
try {
date = sdf.parse(value.toString());
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}
}, Date.class);
BeanUtils.populate(product, request.getParameterMap());
//商品类别
String cid = request.getParameter("categoryId");
String cname = null;
List<Map<String, Object>> mapListCategory = service.findOneById("category", cid);
for (Map<String, Object> map : mapListCategory) {
cname = (String) map.get("cname");
}
product.setCategory(new Category(cid, cname));
//商品编号
product.setPid(CommonUtils.getUUID().replace("-", ""));
//图片处理
Part file = request.getPart("file");
if (file != null) {
String oldName = file.getHeader("content-disposition");
if (oldName != null && oldName.indexOf(".") > 0) {
String newName = UUID.randomUUID() + oldName.substring(oldName.lastIndexOf("."), oldName.length() - 1);
product.setPimage("img/product/" + newName);
file.write(imageUploadPath + newName);
}
}
//设置明细编号
orderItem.setItemid(CommonUtils.getUUID().replaceAll("-", ""));
//设置购买数量
orderItem.setCount(cartItem.getBuyNum());
//设置小计
orderItem.setSubtotal(cartItem.getSubTotal());
//设置购买商品信息
orderItem.setProduct(cartItem.getProduct());
//设置所属订单
orderItem.setOrders(orders);
//设置订单中的多个订单明细
orders.getItemsList().add(orderItem);
}
//提交订单
boolean flag = service.submitOrder(orders);
if (flag) {
//提交成功
session.setAttribute("orders", orders);
response.sendRedirect("order.jsp");
} else {
//提交失败
request.setAttribute("msg", "当前订单提交失败,请重新提交");
request.getRequestDispatcher("cart.jsp").forward(request, response);
}
}
//确认订单
public void confirmOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1.收集表单数据
Map<String, String[]> map = request.getParameterMap();
HttpSession session = request.getSession();
Orders orders = (Orders) session.getAttribute("orders");
//当前合并后,重新计算小计
newSubTotal = buyNum * product.getShop_price();
}
//封装CartItem购物车明细
CartItem cartItem = new CartItem(product,buyNum,newSubTotal);
//封装购物车
cartItemMap.put(pid,cartItem);
//将购物车明细添加进来
cart.setMap(cartItemMap);
//将总金额添加进来
double total = cart.getTotal() + subTotal;
cart.setTotal(total);
session.setAttribute("cart",cart);
response.sendRedirect("cart.jsp");
}
//删除当前购物项
public void delCart(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String pid = request.getParameter("pid");
//1.从会话中获取购物车
HttpSession session = request.getSession();
Cart cart = (Cart)session.getAttribute("cart");
//2.获取购物车中的map集合(购物车明细)
Map<String, CartItem> cartMap = cart.getMap();
//3.重新计算总金额 = 原来购物车的总金额 - 当前移除的购物项的小计
double total = cart.getTotal() - cartMap.get(pid).getSubTotal();
//4.购物车移除当前购物项
cartMap.remove(pid);
//5.封装Cart对象
cart.setTotal(total);
//6.添加至会话中
session.setAttribute("cart",cart);
//7.跳转cart.jsp 避免重复提交表单
response.sendRedirect("cart.jsp");
}
HttpServletResponse response = (HttpServletResponse)servletResponse;
//获取会话对象
HttpSession session = request.getSession();
//从会话中获取登录者的信息
User user = (User)session.getAttribute("user");
//若user为null,则直接跳转至登录界面
if(user==null){
response.sendRedirect("login.jsp");
return;
}
//若user不为null,则直接将过滤链传递下去
filterChain.doFilter(request,response);
}
@Override
public void destroy() {
}
}
public class BaseServlet extends HttpServlet {
@Override
public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String methodName = request.getParameter("method");
Class<? extends BaseServlet> clazz = this.getClass();
public void init(FilterConfig filterConfig) throws ServletException {
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest)servletRequest;
HttpServletResponse response = (HttpServletResponse)servletResponse;
//获取会话对象
HttpSession session = request.getSession();
//从会话中获取登录者的信息
User user = (User)session.getAttribute("user");
//若user为null,则直接跳转至登录界面
if(user==null){
response.sendRedirect("login.jsp");
return;
}
//若user不为null,则直接将过滤链传递下去
filterChain.doFilter(request,response);
}
@Override
public void destroy() {
}
}
public class BaseServlet extends HttpServlet {
@Override
public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String methodName = request.getParameter("method");
Class<? extends BaseServlet> clazz = this.getClass();
}else{
//注册失败,跳转到registFail.jsp
request.getRequestDispatcher("registFail.jsp").forward(request,response);
}
}
//账户激活
public void active(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//根据激活码code,修改状态state
String code = request.getParameter("code");
//调用service进行修改状态
boolean flag = service.active(code);
if(flag){
//激活成功
response.sendRedirect("index.jsp");
}else{
//激活失败
response.sendRedirect("error.jsp");
}
}
//校验用户名是否存在
public void validateName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
boolean flag = service.validateName(username);
String json = "{\"flag\":"+flag+"}";
response.getWriter().write(json);
}
//登录
public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
String username = request.getParameter("username");
String password = request.getParameter("password");
// request.getRequestDispatcher("login.jsp").forward(request,response);
}
}
/**
* 订单的控制层
*/
@WebServlet(urlPatterns = "/order")
public class OrderServlet extends BaseServlet {
private OrderService service = new OrderService();
//提交订单
public void submitOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//大前提 当前必须是登录状态
HttpSession session = request.getSession();
//创建订单
Orders orders = new Orders();
//随机产生订单号
orders.setOid(CommonUtils.getUUID().replaceAll("-", ""));
//设置下单时间
orders.setOrdertime(new Date());
//图片处理
Part file = request.getPart("file");
if (file != null) {
String oldName = file.getHeader("content-disposition");
if (oldName != null && oldName.indexOf(".") > 0) {
String newName = UUID.randomUUID() + oldName.substring(oldName.lastIndexOf("."), oldName.length() - 1);
product.setPimage("img/product/" + newName);
file.write(imageUploadPath + newName);
}
}
String currentImg = product.getPimage();
if (currentImg == null) { //未上传
List<Map<String, Object>> mapList = service.findOneById("product", product.getPid());
String img = null;
for (Map<String, Object> map : mapList) {
img = (String) map.get("pimage");
}
//System.out.println("img = "+img);
if (img != null) {
product.setPimage(img); //设置未原图片
}
}
service.update(product);
response.sendRedirect(request.getContextPath() + "/admin?method=findAll&code=product");
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
}
//商品导出
public void download(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//表格表头信息
String[] title = {"商品编号", "商品名称", "商品描述", "商品价格", "商品图片", "商品日期"};
String[] prop = {"pid", "pname", "pdesc", "shop_price", "pimage", "pdate"};
//excel的名字
String fileName = "goods.xls";
e.printStackTrace();
}
}
//查询所有商品类别,返回json数据
public void findAllCategory(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<Category> categoryList = service.findAllCategory();
Gson gson = new Gson();
String json = gson.toJson(categoryList);
response.getWriter().write(json);
}
//修改商品
public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Product product = new Product();
try {
//将生日String转换成Date类型
ConvertUtils.register(new Converter() {
//实现类型转换,第一个参数:目标数据类型 第二个参数:需要转换的数据
@Override
public Object convert(Class cla, Object value) {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date date = null;
try {
date = sdf.parse(value.toString());
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}
}, Date.class);
BeanUtils.populate(product, request.getParameterMap());
String cid = request.getParameter("categoryId");
String cname = null;
List<Map<String, Object>> mapListCategory = service.findOneById("category", cid);
for (Map<String, Object> map : mapListCategory) {
cname = (String) map.get("cname");
}
product.setCategory(new Category(cid, cname));
//图片处理
Part file = request.getPart("file");
}
//自动登录,若点击free,则再Cookie中存储用户名和密码
else if(free!=null && free.equals("free")){
Cookie usernameCookie = new Cookie("username", URLEncoder.encode(username,"UTF-8"));
Cookie passwordCookie = new Cookie("password",password);
usernameCookie.setMaxAge(7*24*60*60);
passwordCookie.setMaxAge(7*24*60*60);
response.addCookie(usernameCookie);
response.addCookie(passwordCookie);
}
session.setAttribute("user",user);
response.sendRedirect(request.getContextPath()+"/product?method=index");
request.getRequestDispatcher("index.jsp").forward(request,response);
}else{
request.setAttribute("msg","当前账户未激活,请尽快前往邮箱激活");
request.getRequestDispatcher("login.jsp").forward(request,response);
}
}else{
request.setAttribute("msg","用户名与密码不匹配");
request.getRequestDispatcher("login.jsp").forward(request,response);
}
}
//登出
public void logout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
session.invalidate();
Cookie usernameCookie = new Cookie("username","");
Cookie passwordCookie = new Cookie("password","");
usernameCookie.setMaxAge(0);
passwordCookie.setMaxAge(0);
response.addCookie(usernameCookie);
response.addCookie(passwordCookie);
response.sendRedirect(request.getContextPath()+"/product?method=index");
// request.getRequestDispatcher("login.jsp").forward(request,response);
}
}
}
request.getRequestDispatcher("order-list.jsp").forward(request, response);
}
}
@WebServlet(urlPatterns = "/cart")
public class CartServlet extends BaseServlet {
private ProductService service = new ProductService();
//添加至购物车
public void addCart(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//创建会话对象
HttpSession session = request.getSession();
//获取请求参数中的商品编号pid
String pid = request.getParameter("pid");
//获取请求参数中的购买数量buyNum
int buyNum = Integer.parseInt(request.getParameter("buyNum"));
//通过pid查询商品信息
Product product = service.viewProductById(pid);
//计算当前加入购物车的商品的小计
double subTotal =buyNum * product.getShop_price();
//先从会话中获取购物车
Cart cart = (Cart) session.getAttribute("cart");
//若是第一次从会话中获取购物车
if(cart==null){
cart = new Cart();
}
public void active(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//根据激活码code,修改状态state
String code = request.getParameter("code");
//调用service进行修改状态
boolean flag = service.active(code);
if(flag){
//激活成功
response.sendRedirect("index.jsp");
}else{
//激活失败
response.sendRedirect("error.jsp");
}
}
//校验用户名是否存在
public void validateName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
boolean flag = service.validateName(username);
String json = "{\"flag\":"+flag+"}";
response.getWriter().write(json);
}
//登录
public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
String username = request.getParameter("username");
String password = request.getParameter("password");
String code = request.getParameter("code");
//不是自动登录
if(code==null){
password = MD5Utils.md5(password);
}
User user = service.login(username, password);
if(user!=null){
/**
* 订单的控制层
*/
@WebServlet(urlPatterns = "/order")
public class OrderServlet extends BaseServlet {
private OrderService service = new OrderService();
//提交订单
public void submitOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//大前提 当前必须是登录状态
HttpSession session = request.getSession();
//创建订单
Orders orders = new Orders();
//随机产生订单号
orders.setOid(CommonUtils.getUUID().replaceAll("-", ""));
//设置下单时间
orders.setOrdertime(new Date());
//从会话中获取购物车信息
Cart cart = (Cart) session.getAttribute("cart");
//设置订单总金额
orders.setTotal(cart.getTotal());
}
//账户激活
public void active(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//根据激活码code,修改状态state
String code = request.getParameter("code");
//调用service进行修改状态
boolean flag = service.active(code);
if(flag){
//激活成功
response.sendRedirect("index.jsp");
}else{
//激活失败
response.sendRedirect("error.jsp");
}
}
//校验用户名是否存在
public void validateName(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
boolean flag = service.validateName(username);
String json = "{\"flag\":"+flag+"}";
response.getWriter().write(json);
}
//登录
public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
HttpSession session = request.getSession();
String username = request.getParameter("username");
String password = request.getParameter("password");
String code = request.getParameter("code");
//不是自动登录
if(code==null){
password = MD5Utils.md5(password);
}
User user = service.login(username, password);
if(user!=null){
//状态码为1,才可以登录
if(user.getState()==1){
//记住用户名
String remember = request.getParameter("remember");
//自动登录
String free = request.getParameter("free");
case "order":
//若code是order时,跳转到订单管理界面
request.getRequestDispatcher(request.getContextPath() + "/admin/order/order.jsp").forward(request, response);
break;
case "category":
//若code是order时,跳转到订单管理界面
request.getRequestDispatcher(request.getContextPath() + "/admin/category/category.jsp").forward(request, response);
break;
}
}
//查询单个
public void findOneById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
/**
* code的值:user、product、order
* 1.若code是user时,通过会员编号查询会员及拥有的订单信息
* 2.若code是product时,通过商品编号查询商品信息及商品类别
* 3.若code是order时,
*/
String code = request.getParameter("code");
String id = request.getParameter("id");
List<Map<String, Object>> mapList = service.findOneById(code, id);
if (code.equals("product")) {
for (Map<String, Object> map : mapList) {
Date pdate = (Date) map.get("pdate");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String date = sdf.format(pdate);
map.put("date", date);
}
}
Gson gson = new Gson();
String json = gson.toJson(mapList);
response.getWriter().write(json);
}
//删除信息
public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String code = request.getParameter("code");
String[] ids = request.getParameterValues("id");
//执行
service.delete(code, ids);
String page = request.getParameter("pageNow");
int pageNow = 1; //默认查询第一页
if(page!=null){
pageNow = Integer.parseInt(page);
}
//从请求参数中获取查询条件 pname cid
String pname = request.getParameter("pname");
if(pname==null){
pname = ""; //默认查询所有
}
String cid = request.getParameter("cid");
// 执行service的分页方法
PageVO<Product> vo = service.viewProductListByCid(cid, pname, pageNow);
//将vo传递到页面中
request.setAttribute("vo",vo);
request.setAttribute("cid",cid);
request.getRequestDispatcher("shop.jsp").forward(request,response);
}
//通过ID编号查询商品信息
public void viewProductById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String pid = request.getParameter("pid");
//商品信息
Product product = service.viewProductById(pid);
request.setAttribute("product",product);
//商品类别名称
String cid = request.getParameter("cid");
if(cid!=null){
String cname = categoryService.viewCname(cid);
request.setAttribute("cname",cname);
request.setAttribute("cid",cid);
}
//获取当前页
String pageNow = request.getParameter("pageNow");
request.setAttribute("pageNow",pageNow);