基于javaweb的秒杀与竞价拍卖系统(java+jsp+bootstrap+jquery+mysql)

基于javaweb的秒杀与竞价拍卖系统(java+jsp+bootstrap+jquery+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的秒杀与竞价拍卖系统(java+JSP+bootstrap+jQuery+Mysql)

项目介绍

基于B2C的网上拍卖系统主要用于帮助人们应用互联网方便快捷买到自己所中意的商品，并参与到秒杀与竞拍当中。

主要功能包括： 1.前台模块 (1)普通用户登录/注册。 (2)分类查看商品(普通商品与促销商品) (3)查看商品详细信息 (4)查看秒杀商品 (5)查看竞拍商品 (6)将商品加入购物车 (7)购买，结算功能 (8)留言 2.后台模块 (1)修改密码 (2)商品管理: 编辑/删除 设置/取消促销 (3)秒杀商品：设置/取消秒杀 (4)竞拍商品：设置/取消竞拍 (5)订单管理：查看订单 (6)留言管理：查看/删除留言

环境需要

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

技术栈

1. 后端：Servlet 2. 前端：JSP+bootstrap+jQuery

使用说明

1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件； 2. 将项目中resources/ioc/dao.js配置文件中的数据库配置改为自己的配置; 3. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat，然后运行； 4.项目访问路径: 前台：http://localhost:8080/sale 后台：http://localhost:8080/sale/user/adminlogin

用户管理层：

public class UserServlet extends BaseBackServlet {

@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<>();

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

System.out.println(params);

int id = Integer.parseInt(params.get(“id”));

String password = params.get(“password”);

User user = userDAO.get(id);

user.setPassword(password);

userDAO.update(user);

return “@admin_user_list”;

@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 us = userDAO.list(page.getStart(), page.getCount());

int total = userDAO.getTotal();

page.setTotal(total);

request.setAttribute(“us”, us);

request.setAttribute(“page”, page);

return “admin/listUser.jsp”;

订单控制层：

public class OrderServlet extends BaseBackServlet {

@Override

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

return null;

@Override

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);

orderDAO.update(o);

return “@admin_order_list”;

@Override

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

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

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

List os = orderDAO.list(page.getStart(), page.getCount());

orderItemDAO.fill(os);

int total = orderDAO.getTotal();

page.setTotal(total);

request.setAttribute(“os”, os);

request.setAttribute(“page”, page);

return “admin/listOrder.jsp”;

商品管理控制层：

public class CategoryServlet extends BaseBackServlet {

@Override

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©;

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];

int length = 0;

while(-1 != (length = is.read(b))){

fos.write(b, 0, length);

fos.flush();

//通过以下代码，将文件保存为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

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

System.out.println(“调用了category update方法”);

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

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

System.out.println(params);

String name = params.get(“name”);

int id = Integer.parseInt(params.get(“id”));

Category c = new Category();

c.setName(name);

c.setId(id);

categoryDAO.update©;

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];

int length = 0;

while(-1 != (length = is.read(b))){

fos.write(b, 0, length);

fos.flush();

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

BufferedImage img = ImageUtil.change2jpg(file);

ImageIO.write(img, “jpg”, file);

} catch (IOException e) {

e.printStackTrace();

return “@admin_category_list”;

@Override

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

System.out.println(“调用了category edit方法”);

int id = Integer.parseInt(request.getParameter(“id”));

Category category = categoryDAO.get(id);

request.setAttribute(“c”, category);

return “admin/editCategory.jsp”;

@Override

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

List cs = categoryDAO.list(page.getStart(), page.getCount());

int total = categoryDAO.getTotal();

page.setTotal(total);

request.setAttribute(“thecs”, cs);

request.setAttribute(“page”, page);

return “admin/listCategory.jsp”;

---