基于javaweb+mysql的jsp+servlet小蜜蜂扩音器网上商城系统(java+jsp+servlet+jdbc+ajax+mysql)

基于javaweb+mysql的jsp+servlet小蜜蜂扩音器网上商城系统(java+jsp+servlet+jdbc+ajax+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的JSP+Servlet小蜜蜂扩音器网上商城系统(java+jsp+servlet+jdbc+ajax+mysql)

一、项目简述

用户功能模块: 用户注册: 用户登录:商品模块:订单模块;后台管理系统功能:管理员模块: 商品模块:订单管理模块 ;

二、项目运行

1.运行环境

JDK1.8+Tomcat8.5+MYSQL+Eclispe(Eclispe,MyEclispe,Sts,IntelliJ IDEA都支持,小伙伴自行配置即可)

2.技术栈

JSP + Servlet + JDBC + Ajax + JavaScript + CSS + +DBUtil 等等


@Override

public String update(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了Product update方法");

Map<String, String> params = new HashMap<>();

InputStream inputStream = super.parseUpload(request, params);

int cid = Integer.parseInt(params.get("cid"));

Category c = categoryDAO.get(cid);

int id = Integer.parseInt(params.get("id"));

String name = params.get("name");

String subTitle = params.get("subTitle");

float originalPrice = Float.parseFloat(params.get("originalPrice"));


int cid = Integer.parseInt(params.get("cid"));

Category c = categoryDAO.get(cid);

int id = Integer.parseInt(params.get("id"));

String name = params.get("name");

String subTitle = params.get("subTitle");

float originalPrice = Float.parseFloat(params.get("originalPrice"));

float promotePrice = Float.parseFloat(params.get("promotePrice"));

int stock = Integer.parseInt(params.get("stock"));

Product p = new Product();

p.setId(id);

p.setName(name);

p.setSubTitle(subTitle);


return "admin/editProduct.jsp";

public String updatePropertyValue(HttpServletRequest request, HttpServletResponse response, Page page){

System.out.println("调用了Product updatePropertyValue方法");

int  pvid = Integer.parseInt(request.getParameter("pvid"));

String value = request.getParameter("value");

PropertyValue pv = propertyValueDAO.get(pvid);

pv.setValue(value);

propertyValueDAO.update(pv);

return "%success";

public String editPropertyValue(HttpServletRequest request, HttpServletResponse response, Page page){

System.out.println("调用了Product editPropertyValue方法");

int id = Integer.parseInt(request.getParameter("id"));


//通过以下代码,将文件保存为jsp格式

BufferedImage img = ImageUtil.change2jpg(file);

ImageIO.write(img, "jpg", file);

} catch (IOException e) {

e.printStackTrace();

return "@admin_category_list";

@Override

public String delete(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了category delete方法");

int id = Integer.parseInt(request.getParameter("id"));

categoryDAO.delete(id);

return "@admin_category_list";

@Override


return null;

@Override

public String delete(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet delete方法");

int id = Integer.parseInt(request.getParameter("id"));

userDAO.delete(id);

return "@admin_user_list";

@Override

public String update(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet update方法");

Map<String, String> params = new HashMap<>();

InputStream is = super.parseUpload(request, params);

@Override

public String add(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet add方法");

return null;

@Override

public String delete(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet delete方法");

int id = Integer.parseInt(request.getParameter("id"));

userDAO.delete(id);

return "@admin_user_list";

@Override

public String update(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet update方法");

Map<String, String> params = new HashMap<>();

public String editPropertyValue(HttpServletRequest request, HttpServletResponse response, Page page){

System.out.println("调用了Product editPropertyValue方法");

int id = Integer.parseInt(request.getParameter("id"));

Product p = productDAO.get(id);

request.setAttribute("p", p);

// 初始化属性,将产品对应的属性全部

propertyValueDAO.init(p);

List<PropertyValue> pvs = propertyValueDAO.list(p.getId());

request.setAttribute("pvs", pvs);

return "admin/editPropertyValue.jsp";

@Override


return null;

public String delivery(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 OrderServlet delivery方法");

int id = Integer.parseInt(request.getParameter("id"));

Order o = orderDAO.get(id);

o.setDeliveryDate(new Date());

o.setStatus(OrderDAO.waitConfirm);

orderDAO.update(o);

return "@admin_order_list";

@Override

public String list(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 OrderServlet list方法");

// 对订单对应的订单项进行初始化

Category c = new Category();

c.setName(name);

c.setId(id);

categoryDAO.update(c);

File imageFolder = new File(request.getSession().getServletContext().getRealPath("img/category"));

File file = new File(imageFolder, c.getId() + ".jpg");

try{

if(null != is && 0 != is.available()){

try(

FileOutputStream fos = new FileOutputStream(file);

){

byte[] b = new byte[1024 * 1024];

@Override

public String edit(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet edit方法");

int id = Integer.parseInt(request.getParameter("id"));

User u = userDAO.get(id);

request.setAttribute("u", u);

return "admin/editUser.jsp";

@Override

public String list(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet list方法");

List<User> us = userDAO.list(page.getStart(), page.getCount());

int total = userDAO.getTotal();


public String add(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了category add方法");

Map<String,String> params = new HashMap<>();

InputStream is = super.parseUpload(request, params);

System.out.println(params);

String name = params.get("name");

Category c = new Category();

c.setName(name);

categoryDAO.add(c);

File imageFolder = new File(request.getSession().getServletContext().getRealPath("img/category"));

File file = new File(imageFolder, c.getId() + ".jpg");

try{

if(null != is && 0 != is.available()){


return null;

public String delivery(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 OrderServlet delivery方法");

int id = Integer.parseInt(request.getParameter("id"));

Order o = orderDAO.get(id);

o.setDeliveryDate(new Date());

o.setStatus(OrderDAO.waitConfirm);

orderDAO.update(o);

return "@admin_order_list";

@Override

public String list(HttpServletRequest request, HttpServletResponse response, Page page) {


public String delete(HttpServletRequest request, HttpServletResponse response, Page page) {

return null;

@Override

public String update(HttpServletRequest request, HttpServletResponse response, Page page) {

return null;

@Override

public String edit(HttpServletRequest request, HttpServletResponse response, Page page) {

return null;

public String delivery(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 OrderServlet delivery方法");

int id = Integer.parseInt(request.getParameter("id"));

Order o = orderDAO.get(id);

o.setDeliveryDate(new Date());

o.setStatus(OrderDAO.waitConfirm);

propertyValueDAO.init(p);

List<PropertyValue> pvs = propertyValueDAO.list(p.getId());

request.setAttribute("pvs", pvs);

return "admin/editPropertyValue.jsp";

@Override

public String list(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了Product list方法");

int cid = Integer.parseInt(request.getParameter("cid"));

Category c = categoryDAO.get(cid);

List<Product> ps = productDAO.list(cid, page.getStart(), page.getCount());


return null;

@Override

public String delete(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet delete方法");

int id = Integer.parseInt(request.getParameter("id"));

userDAO.delete(id);

return "@admin_user_list";

@Override

public String update(HttpServletRequest request, HttpServletResponse response, Page page) {

System.out.println("调用了 UserServlet update方法");

Map<String, String> params = new HashMap<>();


InputStream is = super.parseUpload(request, params);

System.out.println(params);

String name = params.get("name");

Category c = new Category();

c.setName(name);

categoryDAO.add(c);

File imageFolder = new File(request.getSession().getServletContext().getRealPath("img/category"));

File file = new File(imageFolder, c.getId() + ".jpg");

try{

if(null != is && 0 != is.available()){


float promotePrice = Float.parseFloat(params.get("promotePrice"));

int stock = Integer.parseInt(params.get("stock"));

Product p = new Product();

p.setId(id);

p.setName(name);

p.setSubTitle(subTitle);

p.setOriginalPrice(originalPrice);

p.setPromotePrice(promotePrice);

p.setStock(stock);

p.setCategory(c);

p.setCreateDate(new Date());

productDAO.update(p);

请添加图片描述

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值