基于javaweb+mysql的springboot嘟嘟二手书商城系统(java+html+springboot+maven+mysql+ajax)

基于javaweb+mysql的springboot嘟嘟二手书商城系统(java+html+springboot+maven+mysql+ajax)

运行环境

Java≥8、MySQL≥5.7

开发工具

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

适用

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

功能说明

基于javaweb+mysql的SpringBoot嘟嘟二手书商城系统(java+html+springboot+maven+mysql+ajax)

一、项目简述

功能： 主页显示商品； 所有二手书商品展示，可进行商品搜索； 点击商品进入商品详情页，具有立即购买和加入购物车功能，可增减购买商品数量亦可手动输入，热销商品展示。 立即购买进入确认订单页面，可选择已经添加的地址，亦可新增地址。 可选择购买哪些商品，可删除不需要的商品。 点击结算进入确认订单页面，确认后提交订单。后台管理：(修改密码等)，商品管理（商品批量添加、上下架等），订单管理。

二、项目运行

环境配置：

Jdk1.8 + Tomcat8.5 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）

项目技术：

JSP +Springboot+ SpringMVC + MyBatis + ThymeLeaf + FTP+ JavaScript + JQuery + Ajax + maven等等

    /**
     * 删除用户
     */
    @DeleteMapping("/deleteuser")
    public ResultResp deleteUser(@RequestParam int userId){
        return userService.deleteUser(userId);
    }

    /**
     * 恢复用户
     */
    @GetMapping("/adduser")
    public ResultResp addUser(@RequestParam int userId){
        return userService.adminAddUser(userId);
    }

    /**
     * 重置密码
     */
    @PostMapping("/resetpwd")
    public ResultResp resetPwd(@RequestParam int userId){
        return userService.resetPwd(userId);
    }

    /**
     * 修改密码
     */
    @GetMapping("/repwd")
    public ResultResp rePwd(@RequestParam String userName,
                            @RequestParam String userPwd,
                            @RequestParam String newPwd){
        return userService.rePwd(userName,userPwd,newPwd);
    }

    @PostMapping("/findName")
    public ResultResp findNmae(@RequestParam String userName){
        System.out.println(userName);
        return userService.isUsernameExist(userName);
    }

    /**

            ApiException apiException = (ApiException) e;
            if (apiException.getResponseEnum() == null) {
                return Response.info(apiException.getErr(), apiException.getMessage());
            }
            return Response.info(((ApiException) e).getResponseEnum());
        }
        return Response.serverErr(e.getMessage());
    }

}
package com.hq.secondhand_book.util.base;

public abstract class BaseController {

    protected final Logger logger = LoggerFactory.getLogger(getClass());

    @Autowired
    public WebApplicationContext webApplicationContext;

    @Autowired
    protected HttpServletRequest httpServletRequest;

    @Autowired
    protected HttpServletResponse httpServletResponse;

    public HttpSession getHttpSession() {
        return getHttpSession(true);
    }

    public HttpSession getHttpSession(boolean request) {

     * @param bookId
     * @return
     */
    @DeleteMapping("/deletebook")
    public ResultResp deleteBook(@RequestParam int bookId){
        return bookService.deleteBook(bookId);
    }

    /**
     * 上架图书
     * @param bookId
     * @return
     */
    @GetMapping("/addbook")
    public ResultResp addBook(@RequestParam int bookId){
        return bookService.addBook(bookId);
    }
}
package com.hq.secondhand_book.util.aop;

/**
 * 记录接口信息
 */
@Aspect
@Component
public class HttpAspect {

    protected final Logger logger = LoggerFactory.getLogger(getClass());

    @Pointcut("execution(public * com.hq.secondhand_book.controller.*.*(..))")
    public void log() {
    }

/**
 * @auther xinye
 * @create 2019 04 03
 */
@RestController
public class UserController {
    @Autowired
    UserService userService;

    /**
     * 用户登录
     */
    @PostMapping("/login")
    public ResultResp login(@RequestBody LoginVo loginVo){
        System.out.println(loginVo);
        return userService.login(loginVo);
    }

    /**
     * 根据用户名查找用户
     */
    @PostMapping("/userinfo")
    public ResultResp getUser(String userName){
        UserInfoVo vo = userService.getUser(userName);
        return Response.ok(vo);
    }

    @PostMapping("/updateuser")
    public ResultResp updateUser(UserDto userDto){
        return userService.updateUser(userDto);
    }

    /**
     * 用户列表
     * @return
     */
    @GetMapping("/userlist")
    public ResultResp UserList(@RequestParam(required = false, defaultValue = "1") int pageIndex,
                               @RequestParam(required = false, defaultValue = "8") int pageSize){
        return userService.userList(pageIndex,pageSize);
    }

    /**
     * 我的中心数据统计
     * @return
     */

@RestController
public class BookController {
    @Autowired
    BookService bookService;

    /**
     * 图书列表
     * @return
     */
    @GetMapping("/booklist")
    public ResultResp bookList(@RequestParam(required = false, defaultValue = "1") int pageIndex,
                               @RequestParam(required = false, defaultValue = "8") int pageSize){
        return bookService.bookList(pageIndex,pageSize);
    }

    /**
     * 后台图书列表
     * @return
     */
    @GetMapping("/bookadminlist")
    public ResultResp bookAdminList(@RequestParam(required = false, defaultValue = "1") int pageIndex,
                               @RequestParam(required = false, defaultValue = "8") int pageSize){
        return bookService.bookAdminList(pageIndex,pageSize);
    }

    /**
     * 通过图书名搜索后台图书列表
     * @return
     */
    @GetMapping("/findbooknameadminlist")
    public ResultResp finByBookNameAdminList(@RequestParam String bookName,
                                             @RequestParam(required = false, defaultValue = "1") int pageIndex,
                                             @RequestParam(required = false, defaultValue = "8") int pageSize){
        return bookService.findByBookNameAdminList(bookName, pageIndex, pageSize);
    }

    @GetMapping("/findbybooknamelist")
    public ResultResp findByBookNameList(@RequestParam String bookName,
                                         @RequestParam(required = false, defaultValue = "1") int pageIndex,
                                         @RequestParam(required = false, defaultValue = "8") int pageSize){
        return bookService.findByBookNameList(bookName,pageIndex,pageSize);

    @After("log()")
    public void doAfter() {
    }

    @AfterReturning(returning = "object", pointcut = "log()")
    public void doAfterReturning(Object object) {
        if (object != null) {
            logger.info("response: {}", JSON.toJSON(object));
        } else {
            logger.info("response={}", "object is null");
        }
    }
}
package com.hq.secondhand_book.controller;

@RestController
public class BookCategoryController {
    @Autowired
    BookCategoryService bookCategoryService;
    //图书类别下拉框
    @GetMapping("/findbookcategory")
    public ResultResp findAll(){
        List<BookCategoryVo> bookCategoryVos = bookCategoryService.findAll();
        return Response.ok(bookCategoryVos);
    }

    //图书类别列表
    @GetMapping("/bookcategoryList")
    public ResultResp bookCategoryList(@RequestParam(required = false, defaultValue = "1") int pageIndex,
                                       @RequestParam(required = false, defaultValue = "10") int pageSize) {
        return bookCategoryService.bookCategoryList(pageIndex, pageSize);
    }

    /**
     * 查找
     * @param categoryName
     * @param pageIndex
     * @param pageSize
     * @return
     */

     * 生成订单
     * @param userName
     * @param bookId
     * @param addressId
     * @return
     */
    @PostMapping("/addorder")
    public ResultResp addOrder(@RequestParam String userName,
                               @RequestParam int bookId,
                               @RequestParam int addressId){
        return orderService.addOrder(bookId,addressId,userName);
    }

    /**
     * 订单列表
     * @return
     */
    @GetMapping("/orderlist")
    public ResultResp orderList(@RequestParam String userName){
        return orderService.orderList(userName);
    }

    /**
     * 订单详情
     * @return
     */
    @GetMapping("/orderlist/detail")
    public ResultResp orderList(@RequestParam int orderId){
        return orderService.orderDetail(orderId);
    }

    /**
     * 确认收货
     * @return
     */
    @PostMapping("/confirmreceipt")
    public ResultResp confirmReceipt(@RequestParam int orderId){
        return orderService.confirmReceipt(orderId);
    }

    /**
     * 取消收货
     * @return
     */
    @PostMapping("/cancelorder")
    public ResultResp cancelOrder(@RequestParam int orderId){
        return orderService.cancelOrder(orderId);
    }
}
package com.hq.secondhand_book.util.base;

    @PostMapping("/updatecategory")
    public ResultResp updateCategory(@RequestParam int catergoryId,
                                     @RequestParam String catergoryName,
                                     @RequestParam String fatherCategoryName){
        return bookCategoryService.updateCategory(catergoryId, catergoryName, fatherCategoryName);
    }

}
package com.hq.secondhand_book.controller;

@RestController
public class PlaceTransactionController {
    @Autowired
    PlaceTransactionService placeTransactionService;

    /**
     * 交易地点下拉列表
     * @return
     */
    @GetMapping("/placelist")
    public ResultResp getPlace(){
        return placeTransactionService.getPlace();
    }

    //交易地点列表
    @GetMapping("/placepagelist")
    public ResultResp bookCategoryList(@RequestParam(required = false, defaultValue = "1") int pageIndex,
                                       @RequestParam(required = false, defaultValue = "10") int pageSize) {
        return placeTransactionService.placeList(pageIndex, pageSize);
    }

    //交易地点列表
    @GetMapping("/placepagebyplacenamelist")
    public ResultResp bookCategoryList(@RequestParam String placeName,
                                       @RequestParam(required = false, defaultValue = "1") int pageIndex,
                                       @RequestParam(required = false, defaultValue = "10") int pageSize) {
        return placeTransactionService.findByPlaceNameList(placeName,pageIndex, pageSize);
    }

    /**
     * 删除交易地点
     * @param placeId
     * @return
     */
    @DeleteMapping("/deleteplace")
    public ResultResp deleteByBookCategoryName(@RequestParam int placeId){
        return placeTransactionService.deletePlace(placeId);

@Aspect
@Component
public class HttpAspect {

    protected final Logger logger = LoggerFactory.getLogger(getClass());

    @Pointcut("execution(public * com.hq.secondhand_book.controller.*.*(..))")
    public void log() {
    }

    @Before("log()")
    public void doBefore(JoinPoint joinPoint) {
        ServletRequestAttributes attributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
        HttpServletRequest request = attributes.getRequest();
        logger.info("url={}", request.getRequestURL());
        logger.info("method={}", request.getMethod());
        logger.info("class_method={}", joinPoint.getSignature().getDeclaringTypeName() + "."
                + joinPoint.getSignature().getName());

        StringBuilder sb = new StringBuilder();
        Enumeration<String> parameterNames = request.getParameterNames();
        while (parameterNames.hasMoreElements()) {
            String name = parameterNames.nextElement();
            String value = request.getParameter(name);
            sb.append(" ");
            sb.append(name);
            sb.append("=");
            sb.append(value);
        }

        logger.info("param={} ", sb.toString());

        if (request.getMethod().equals("POST") || request.getMethod().equals("PUT")) {
            MethodSignature methodSignature = (MethodSignature) joinPoint.getSignature();
            Method method = methodSignature.getMethod();
            Parameter[] parameters = method.getParameters();
            for (int j = 0; j < parameters.length; j++) {
                Parameter parameter = parameters[j];
                Annotation[] annotations = parameter.getDeclaredAnnotations();
                for (int k = 0; k < annotations.length; k++) {
                    Annotation annotation = annotations[k];

public abstract class BaseController {

    protected final Logger logger = LoggerFactory.getLogger(getClass());

    @Autowired
    public WebApplicationContext webApplicationContext;

    @Autowired
    protected HttpServletRequest httpServletRequest;

    @Autowired
    protected HttpServletResponse httpServletResponse;

    public HttpSession getHttpSession() {
        return getHttpSession(true);
    }

    public HttpSession getHttpSession(boolean request) {
        return httpServletRequest.getSession(request);
    }

}
package com.hq.secondhand_book.controller;

/**
 * @auther xinye
 * @create 2019 04 03
 */
@RestController
public class RegisterController {
    @Resource

 * @create 2017 11 17
 * 重写自带的error
 */
@RestController
public class ApiErrorController extends BasicErrorController {

    public ApiErrorController() {
        super(new DefaultErrorAttributes(), new ErrorProperties());
    }

    @RequestMapping(produces = {MediaType.APPLICATION_JSON_VALUE})
    public ResponseEntity<Map<String, Object>> error(HttpServletRequest request) {
        Map<String, Object> body = getErrorAttributes(request,
                isIncludeStackTrace(request, MediaType.ALL));
        HttpStatus status = getStatus(request);

        Map<String, Object> resultResp = new HashMap<>();
        resultResp.put("err", ResponseErr.SERVER_ERROR.getErr());
        resultResp.put("msg", "http error");
        resultResp.put("data", body);

        return new ResponseEntity<>(resultResp, status);
    }
}
package com.hq.secondhand_book.controller;

/**
 * @auther xinye
 * @create 2019 04 09
 */
@RestController
public class FileController {

    @Autowired
    UserService userService;
    @Autowired
    FileService fileService;

    @PostMapping(value = "/singlefile")
    public ResultResp headImg(@RequestParam(value="file",required=false) MultipartFile file, String userName) throws Exception {
        fileService.singleFile(file,userName);

 */
@RestController
public class FileController {

    @Autowired
    UserService userService;
    @Autowired
    FileService fileService;

    @PostMapping(value = "/singlefile")
    public ResultResp headImg(@RequestParam(value="file",required=false) MultipartFile file, String userName) throws Exception {
        fileService.singleFile(file,userName);
        return Response.ok();
    }

    //上传图书
    @PostMapping("/morefile")
    public ResultResp moreFile(@RequestParam(value = "file", required = false) MultipartFile[] files,String userName,String bookName,
        String bookSynopsis, Double bookPrice,int bookCategoryId){
        if(files.length == 0){
            return Response.dataErr("未上传图片！");
        }else{
            fileService.moreFile(files, userName,bookName,bookSynopsis,bookPrice,bookCategoryId);
            return Response.ok();
        }
    }
}
package com.hq.secondhand_book.controller;

@RestController
public class CollectionController {
    @Autowired
    CollectionService collectionService;

    /**

    @GetMapping("/userdetail")
    public ResultResp findByUserId(@RequestParam String userName){
        return userService.findByUserName(userName);
    }

    /**
     * 删除用户
     */
    @DeleteMapping("/deleteuser")
    public ResultResp deleteUser(@RequestParam int userId){
        return userService.deleteUser(userId);
    }

    /**
     * 恢复用户
     */
    @GetMapping("/adduser")
    public ResultResp addUser(@RequestParam int userId){
        return userService.adminAddUser(userId);
    }

    /**
     * 重置密码
     */
    @PostMapping("/resetpwd")
    public ResultResp resetPwd(@RequestParam int userId){
        return userService.resetPwd(userId);
    }

    /**
     * 修改密码
     */
    @GetMapping("/repwd")
    public ResultResp rePwd(@RequestParam String userName,
                            @RequestParam String userPwd,
                            @RequestParam String newPwd){
        return userService.rePwd(userName,userPwd,newPwd);
    }

    @PostMapping("/findName")
    public ResultResp findNmae(@RequestParam String userName){
        System.out.println(userName);
        return userService.isUsernameExist(userName);
    }

    /**
     * 添加用户
     */
    @GetMapping("/adduserName")
    public ResultResp adduserName(@RequestParam String userName,
                                  @RequestParam String userPwd ){

    @Pointcut("execution(public * com.hq.secondhand_book.controller.*.*(..))")
    public void log() {
    }

    @Before("log()")
    public void doBefore(JoinPoint joinPoint) {
        ServletRequestAttributes attributes = (ServletRequestAttributes) RequestContextHolder.getRequestAttributes();
        HttpServletRequest request = attributes.getRequest();
        logger.info("url={}", request.getRequestURL());
        logger.info("method={}", request.getMethod());
        logger.info("class_method={}", joinPoint.getSignature().getDeclaringTypeName() + "."
                + joinPoint.getSignature().getName());

        StringBuilder sb = new StringBuilder();
        Enumeration<String> parameterNames = request.getParameterNames();
        while (parameterNames.hasMoreElements()) {
            String name = parameterNames.nextElement();
            String value = request.getParameter(name);
            sb.append(" ");
            sb.append(name);
            sb.append("=");
            sb.append(value);
        }

        logger.info("param={} ", sb.toString());

        if (request.getMethod().equals("POST") || request.getMethod().equals("PUT")) {
            MethodSignature methodSignature = (MethodSignature) joinPoint.getSignature();
            Method method = methodSignature.getMethod();
            Parameter[] parameters = method.getParameters();
            for (int j = 0; j < parameters.length; j++) {
                Parameter parameter = parameters[j];
                Annotation[] annotations = parameter.getDeclaredAnnotations();
                for (int k = 0; k < annotations.length; k++) {
                    Annotation annotation = annotations[k];
                    if (annotation instanceof RequestBody) {
                        logger.info("body={}", JSON.toJSON(joinPoint.getArgs()[j]));
                    }
                }
            }
        }
    }

    @After("log()")
    public void doAfter() {
    }

    @AfterReturning(returning = "object", pointcut = "log()")
    public void doAfterReturning(Object object) {
        if (object != null) {
            logger.info("response: {}", JSON.toJSON(object));
        } else {
            logger.info("response={}", "object is null");
        }

    @GetMapping("/findbyadminusernamelist")
    public ResultResp findByAdminUserNameList(@RequestParam String userName,
                                             @RequestParam(required = false, defaultValue = "1") int pageIndex,
                                             @RequestParam(required = false, defaultValue = "8") int pageSize){
        return userService.findByAdminUserNameList(userName, pageIndex, pageSize);
    }

    /**
     * 通过用户编号查看详情
     */
    @GetMapping("/userdetail")
    public ResultResp findByUserId(@RequestParam String userName){
        return userService.findByUserName(userName);
    }

    /**
     * 删除用户
     */
    @DeleteMapping("/deleteuser")
    public ResultResp deleteUser(@RequestParam int userId){
        return userService.deleteUser(userId);
    }

    /**
     * 恢复用户
     */
    @GetMapping("/adduser")
    public ResultResp addUser(@RequestParam int userId){
        return userService.adminAddUser(userId);
    }

    /**
     * 重置密码
     */
    @PostMapping("/resetpwd")
    public ResultResp resetPwd(@RequestParam int userId){
        return userService.resetPwd(userId);
    }

    /**
     * 修改密码

        System.out.println(categoryName);
        return bookCategoryService.findByBookCategoryNameList(categoryName,pageIndex,pageSize);
    }

    /**
     * 删除类别
     * @param categoryName
     * @return
     */
    @DeleteMapping("/deletebookcategory")
    public ResultResp deleteByBookCategoryName(@RequestParam String categoryName){
        return bookCategoryService.deleteBookCategory(categoryName);
    }

    /**
     * 添加类别
     */
    @PostMapping("/addcategory")
    public ResultResp addCategory(@RequestParam String catergoryName,
                                  @RequestParam String fatherCategoryName){
        return bookCategoryService.addCategory(catergoryName,fatherCategoryName);
    }

    /**
     * 更新类别
     * @param catergoryId
     * @param catergoryName
     * @param fatherCategoryName
     * @return
     */
    @PostMapping("/updatecategory")
    public ResultResp updateCategory(@RequestParam int catergoryId,
                                     @RequestParam String catergoryName,
                                     @RequestParam String fatherCategoryName){
        return bookCategoryService.updateCategory(catergoryId, catergoryName, fatherCategoryName);
    }

}
package com.hq.secondhand_book.controller;

@RestController
public class PlaceTransactionController {
    @Autowired

    public ResultResp start(@RequestParam String  userName,
                                  @RequestParam int bookId){
        return collectionService.start(userName,bookId);
    }
    /**
     * 收藏图书列表
     */
    @GetMapping("startlist")
    public ResultResp startList(@RequestParam String  userName,
                            @RequestParam(required = false, defaultValue = "1") int pageIndex,
                            @RequestParam(required = false, defaultValue = "8") int pageSize){
        return collectionService.startList(userName,pageIndex,pageSize);
    }
}
package com.hq.secondhand_book.controller;

@RestController
public class ReceiveAdressController {
    @Autowired
    ReceiveAdressService receiveAdressService;

    /**
     * 用户的收货地址列表
     * @param userName
     * @return
     */
    @GetMapping("/getreceiveadress")
    public ResultResp getReceiveAdress(String userName){
        return receiveAdressService.getRececiveAdress(userName);
    }

    /**
     * 添加收货地址
     * @return
     */
    @PostMapping("/addreceiveadress")
    public ResultResp addReceiveAdress(@RequestBody ReceiveAdressDto dto){