基于javaweb+mysql的springboot前台展示+后台管理结合的在线购书系统(java+springboot+ssm+mysql+maven)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot前台展示+后台管理结合的在线购书系统(java+springboot+ssm+mysql+maven)
一、项目简述
功能:一个基于JavaWeb的网上书店的设计与实现,归纳 出了几个模块,首先是登录注册模块,图书查找模块,购物车模块,订单模块,个人中心模块,用户管理模块,图 书管理模块等。 该项目是javaJeb技术的实战操作,采用了MVC设计模 式,包括基本的entity, jscript, servlet,以及ajax异步请 求,查询分页,持久化层方法的封装等等,对javaweb技 术的巩固很有帮助,为J2EE的学习打下基础,适用于课程 设计,毕业设计。
二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: JSP +Springboot+ SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + maven等等
return new ResultVO(ResultCode.SUCCESS,"/admin/book_manage");
}
/**
* 用户退出
* @param session
* @return
*/
@GetMapping("/logout")
public String userLogout(HttpSession session){
session.removeAttribute("user");
return "redirect:/login";
}
/**
* 后台管理退出
* @param session
* @return
*/
@GetMapping("/admin/logout")
public String adminLogout(HttpSession session){
session.removeAttribute("admin");
return "redirect:/";
}
@GetMapping("/checkLoggedIn")
@ResponseBody
public ResultVO checkUserIsLoggedIn(HttpSession session) {
if (session.getAttribute("user") == null) {
throw new CustomizeException(ResultCode.USER_NOT_LOGGED_IN);
}
return new ResultVO(ResultCode.SUCCESS);
}
}
/**
* @Description: 首页商品展示模块控制器
*/
@Controller
@RequestMapping("/index")
public class BookDisplayController {
@Autowired
private BookDisplayService bookDisplayService;
/**
* 处理前台获取所有分类的请求
* @return
*/
@GetMapping("/category")
@ResponseBody
public ResultVO getCategories() {
List<Category> categories = bookDisplayService.getAllCategories();
return new ResultVO(ResultCode.SUCCESS,categories);
}
/**
* 根据前台传来的categoryCode,响应对应的分类的书籍
* 需要进行分页响应
* 如果categoryCode为null,则响应所有书籍
* @param categoryCode 分类代码
* @param page 页码
* @param limit 每页的数量
* @return
*/
@GetMapping("/books")
@ResponseBody
public ResultVO getBooksByCategoryCode(@RequestParam(required = false) String categoryCode, @RequestParam(required = false) Integer page, @RequestParam(required = false) Integer limit) {
List<Book> books = bookDisplayService.getBooksByCategoryCode(page==null?1:page, limit==null?10:limit, categoryCode);
PageInfo pageInfo = new PageInfo(books); //获得分页信息
return new ResultVO(ResultCode.SUCCESS, (int) pageInfo.getTotal(),books);
}
/**
* 根据请求的bookId,返回该Id的书籍信息,响应Html视图
* @param bookId
* @return
*/
@GetMapping("/books/details/{bookId}")
public String bookDetailsView(@PathVariable("bookId") Integer bookId, Model model) {
Book book = bookDisplayService.getBookDetailsByBookId(bookId);
model.addAttribute("book", book);
return "details";
}
List<Book> books = bookDisplayService.getBooksByCategoryCode(page==null?1:page, limit==null?10:limit, categoryCode);
PageInfo pageInfo = new PageInfo(books); //获得分页信息
return new ResultVO(ResultCode.SUCCESS, (int) pageInfo.getTotal(),books);
}
/**
* 根据请求的bookId,返回该Id的书籍信息,响应Html视图
* @param bookId
* @return
*/
@GetMapping("/books/details/{bookId}")
public String bookDetailsView(@PathVariable("bookId") Integer bookId, Model model) {
Book book = bookDisplayService.getBookDetailsByBookId(bookId);
model.addAttribute("book", book);
return "details";
}
/**
* 首页根据书名搜索书籍
* @param bookName
* @return
*/
@GetMapping("/books/search")
@ResponseBody
public ResultVO searchBook(@RequestParam(required = true) String bookName) {
List<Book> books = bookDisplayService.searchBooksByBookName(1, 10, bookName);
PageInfo pageInfo = new PageInfo(books);
return new ResultVO(ResultCode.SUCCESS, (int) pageInfo.getTotal(), books);
}
}
}
@Override
public void adminLogin(Admin admin, HttpSession session) {
}
}
/**
* @Description: 用户中心模块
*/
@Controller
@RequestMapping("/user_center")
public class UserCenterController {
@Autowired
private OrderHandleService orderHandleService;
/**
* 根据用户ID,获取用户订单
* @return
*/
@GetMapping("/orders")
@ResponseBody
public ResultVO getUserOrders(Integer page, Integer limit, HttpSession session) {
User user = (User) session.getAttribute("user");
public class ShoppingCartController {
@Autowired
private ShoppingCartService shoppingCartService;
/**
* 根据用户ID获取该用户的购物车
* @param session
* @return
*/
@GetMapping("/list")
public ResultVO getCartByUserId(HttpSession session) {
User user = (User) session.getAttribute("user");
List<ShoppingCart> carts = shoppingCartService.getShoppingCartsByUserId(user.getUserId());
return new ResultVO(ResultCode.SUCCESS, carts);
}
/**
* 更新购物车的商品数量
* @param cartId 购物车Id
* @param quantity 商品购买数量
* @return
*/
@PutMapping("/list/{cartId}")
public ResultVO updateCartItem(@PathVariable("cartId") Integer cartId,Integer quantity) {
if(quantity<=0){
throw new CustomizeException(ResultCode.FAILED,"购物数量必须大于0");
}
if(quantity>10){
throw new CustomizeException(ResultCode.FAILED,"每件商品限购10件");
}
ShoppingCart cart = new ShoppingCart();
cart.setCartId(cartId);
cart.setQuantity(quantity);
shoppingCartService.updateShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
/**
* 添加到购物车请求处理
*
* @param cart 接收前台传来的参数
* @return
*/
@PostMapping("/list")
public ResultVO addToShoppingCart(@Valid ShoppingCart cart, HttpSession session) {
User user = (User) session.getAttribute("user");
cart.setUserId(user.getUserId());
@RequestMapping("/cart")
public class ShoppingCartController {
@Autowired
private ShoppingCartService shoppingCartService;
/**
* 根据用户ID获取该用户的购物车
* @param session
* @return
*/
@GetMapping("/list")
public ResultVO getCartByUserId(HttpSession session) {
User user = (User) session.getAttribute("user");
List<ShoppingCart> carts = shoppingCartService.getShoppingCartsByUserId(user.getUserId());
return new ResultVO(ResultCode.SUCCESS, carts);
}
/**
* 更新购物车的商品数量
* @param cartId 购物车Id
* @param quantity 商品购买数量
* @return
*/
@PutMapping("/list/{cartId}")
public ResultVO updateCartItem(@PathVariable("cartId") Integer cartId,Integer quantity) {
if(quantity<=0){
throw new CustomizeException(ResultCode.FAILED,"购物数量必须大于0");
}
if(quantity>10){
throw new CustomizeException(ResultCode.FAILED,"每件商品限购10件");
}
ShoppingCart cart = new ShoppingCart();
cart.setCartId(cartId);
cart.setQuantity(quantity);
shoppingCartService.updateShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
/**
* 添加到购物车请求处理
*
* @param cart 接收前台传来的参数
* @return
*/
@PostMapping("/list")
public ResultVO addToShoppingCart(@Valid ShoppingCart cart, HttpSession session) {
User user = (User) session.getAttribute("user");
cart.setUserId(user.getUserId());
shoppingCartService.addToShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
@RequestMapping("/cart")
public class ShoppingCartController {
@Autowired
private ShoppingCartService shoppingCartService;
/**
* 根据用户ID获取该用户的购物车
* @param session
* @return
*/
@GetMapping("/list")
public ResultVO getCartByUserId(HttpSession session) {
User user = (User) session.getAttribute("user");
List<ShoppingCart> carts = shoppingCartService.getShoppingCartsByUserId(user.getUserId());
return new ResultVO(ResultCode.SUCCESS, carts);
}
/**
* 更新购物车的商品数量
* @param cartId 购物车Id
* @param quantity 商品购买数量
* @return
*/
@PutMapping("/list/{cartId}")
public ResultVO updateCartItem(@PathVariable("cartId") Integer cartId,Integer quantity) {
if(quantity<=0){
throw new CustomizeException(ResultCode.FAILED,"购物数量必须大于0");
}
if(quantity>10){
throw new CustomizeException(ResultCode.FAILED,"每件商品限购10件");
}
ShoppingCart cart = new ShoppingCart();
cart.setCartId(cartId);
cart.setQuantity(quantity);
shoppingCartService.updateShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
/**
* 添加到购物车请求处理
*
* @param cart 接收前台传来的参数
* @return
*/
@PostMapping("/list")
public ResultVO addToShoppingCart(@Valid ShoppingCart cart, HttpSession session) {
User user = (User) session.getAttribute("user");
cart.setUserId(user.getUserId());
shoppingCartService.addToShoppingCart(cart);
* 根据用户ID获取该用户的购物车
* @param session
* @return
*/
@GetMapping("/list")
public ResultVO getCartByUserId(HttpSession session) {
User user = (User) session.getAttribute("user");
List<ShoppingCart> carts = shoppingCartService.getShoppingCartsByUserId(user.getUserId());
return new ResultVO(ResultCode.SUCCESS, carts);
}
/**
* 更新购物车的商品数量
* @param cartId 购物车Id
* @param quantity 商品购买数量
* @return
*/
@PutMapping("/list/{cartId}")
public ResultVO updateCartItem(@PathVariable("cartId") Integer cartId,Integer quantity) {
if(quantity<=0){
throw new CustomizeException(ResultCode.FAILED,"购物数量必须大于0");
}
if(quantity>10){
throw new CustomizeException(ResultCode.FAILED,"每件商品限购10件");
}
ShoppingCart cart = new ShoppingCart();
cart.setCartId(cartId);
cart.setQuantity(quantity);
shoppingCartService.updateShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
/**
* 添加到购物车请求处理
*
* @param cart 接收前台传来的参数
* @return
*/
@PostMapping("/list")
public ResultVO addToShoppingCart(@Valid ShoppingCart cart, HttpSession session) {
User user = (User) session.getAttribute("user");
cart.setUserId(user.getUserId());
shoppingCartService.addToShoppingCart(cart);
return new ResultVO(ResultCode.SUCCESS);
}
/**
* 删除前台传来的cartId的购物车项
* @param cartId
@Override
public void userLogin(User record, HttpSession session) {
User user=userMapper.selectByUserName(record.getUserName());
if(user==null){
//用户不存在
throw new CustomizeException(ResultCode.USER_NOT_FOUND);
}
if(!user.getPassword().equals(record.getPassword())){
//密码错误
throw new CustomizeException(ResultCode.PASSWORD_ERROR);
}
session.setAttribute("user",user);
}
/**
* 用户注册处理
* @param record
*/
@Override
public void userRegister(User record) {
User user=userMapper.selectByUserName(record.getUserName());
if(user!=null){
throw new CustomizeException(ResultCode.FAILED,"用户名已存在");
}
userMapper.insert(record);
}
@Override
public void adminLogin(Admin admin, HttpSession session) {
}
}
return new ResultVO(ResultCode.SUCCESS,orders);
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND,null);
}
/**
* 多条件搜索订单 ---- by guozongchao
* @param order
* @param page
* @param limit
* @return
*/
@GetMapping("/search")
public ResultVO searchOrders(Order order, Integer page, Integer limit) {
if (order.getConsigneeName().isEmpty()) {
order.setConsigneeName(null);
}
List<Order> orders = orderService.searchOrders(order, page, limit);
PageInfo pageInfo = new PageInfo(orders);
return new ResultVO(ResultCode.SUCCESS, (int) pageInfo.getTotal(), orders);
}
}
/**
* @Description: 购物城模块控制器
*/
@PostMapping("/user/login")
@ResponseBody
public ResultVO userLoginHandler(@RequestBody @Valid User user, HttpSession session) {
loginRegisterService.userLogin(user,session);
return new ResultVO(ResultCode.SUCCESS,"/");
}
/**
* 用户注册请求处理
* @param user
* @return
*/
@PostMapping("/user/register")
@ResponseBody
public ResultVO userRegisterHandler(@RequestBody @Valid User user) {
loginRegisterService.userRegister(user);
return new ResultVO(ResultCode.SUCCESS,"/login");
}
/**
* 管理员登录请求处理
* @param admin
* @return
*/
@PostMapping("/admin/login")
@ResponseBody
public ResultVO adminLoginHandler(@RequestBody Admin admin, HttpSession session) {
if(!("admin".equals(admin.getAdminName())&& "123456".equals(admin.getPassword()))){
throw new CustomizeException(ResultCode.FAILED,"管理员账户或密码错误");
}
session.setAttribute("admin",admin);
return new ResultVO(ResultCode.SUCCESS,"/admin/book_manage");
}
/**
* 用户退出
* @param session
* @return
*/
@GetMapping("/logout")
public String userLogout(HttpSession session){
session.removeAttribute("user");
return "redirect:/login";
}
/**
* 后台管理退出
* @param session
*/
@Controller
public class LoginRegisterController {
@Autowired
private LoginRegisterService loginRegisterService;
/**
* 用户登录请求处理
* @param user
* @return
*/
@PostMapping("/user/login")
@ResponseBody
public ResultVO userLoginHandler(@RequestBody @Valid User user, HttpSession session) {
loginRegisterService.userLogin(user,session);
return new ResultVO(ResultCode.SUCCESS,"/");
}
/**
* 用户注册请求处理
* @param user
* @return
*/
@PostMapping("/user/register")
@ResponseBody
public ResultVO userRegisterHandler(@RequestBody @Valid User user) {
loginRegisterService.userRegister(user);
return new ResultVO(ResultCode.SUCCESS,"/login");
}
/**
* 管理员登录请求处理
* @param admin
* @return
*/
@PostMapping("/admin/login")
@ResponseBody
public ResultVO adminLoginHandler(@RequestBody Admin admin, HttpSession session) {
if(!("admin".equals(admin.getAdminName())&& "123456".equals(admin.getPassword()))){
throw new CustomizeException(ResultCode.FAILED,"管理员账户或密码错误");
}
session.setAttribute("admin",admin);
private CategoryMapper categoryMapper;
@GetMapping("/searchcode")
public ResultVO categorySearchByCode(String categoryCode)
{
Category categories = categoryService.selectByByCategoryCode(categoryCode);
if(categories!=null)
return new ResultVO(ResultCode.SUCCESS,categories);
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND,null);
}
@PostMapping("/delete")
public ResultVO categoryDelete(String categoryCode)
{
int categories = categoryService.deleteByByCategoryCode(categoryCode);
return new ResultVO(ResultCode.SUCCESS,null);
}
//添加验证
@PostMapping("/insert")
public ResultVO categoryInsert(@Valid Category record)
{
int categories = categoryService.insert(record);
return new ResultVO(ResultCode.SUCCESS,null);
}
//添加验证
@PostMapping("/update")
public ResultVO categoryUpdate(@Valid Category record)
{
int categories = categoryService.updateByCategoryCode(record);
return new ResultVO(ResultCode.SUCCESS,null);
}
//添加分页
@GetMapping("/searchall")
public ResultVO categorySearchAll(Integer page,Integer limit)
{
List<Category> categories = categoryService.selectAll(page==null?0:page,limit==null?10:limit);
if(categories.size()!=0)
return new ResultVO(ResultCode.SUCCESS,categories);
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND,null);
}
}
/**
* @Description: 书籍管理模块控制器
*/
@RestController
@RequestMapping("/book")
public class BookController {
@Autowired
private BookService bookService;
@GetMapping("/searchid")
public ResultVO bookSearchByBookId(Integer bookId) {
// Book books=bookMapper.selectByBookId(bookIde);
Book books = bookService.bookSearchById(bookId);
if (books != null)
return new ResultVO(ResultCode.SUCCESS,books);
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND, null);
}
@PostMapping("/delete")
public ResultVO bookDelete(Integer bookId) {
int books = bookService.bookDeleteSearchById(bookId);
return new ResultVO(ResultCode.SUCCESS, null);
}
//添加验证注解
@PostMapping("/insert")
public ResultVO bookInsert(@Valid Book record) {
int books = bookService.bookInsert(record);
return new ResultVO(ResultCode.SUCCESS, null);
}
@GetMapping("/searchcode")
public ResultVO bookSerchByCategoryCode(String catrgoryCode,Integer page,Integer limit) {
List<Book> books = bookService.bookSearchByCode(catrgoryCode,page,limit);
PageInfo pageInfo = new PageInfo(books);
if(books.size()!=0)
@Override
public void userRegister(User record) {
User user=userMapper.selectByUserName(record.getUserName());
if(user!=null){
throw new CustomizeException(ResultCode.FAILED,"用户名已存在");
}
userMapper.insert(record);
}
@Override
public void adminLogin(Admin admin, HttpSession session) {
}
}
/**
* @Description: 用户中心模块
*/
@Controller
@RequestMapping("/user_center")
public class UserCenterController {
@Autowired
private OrderHandleService orderHandleService;
/**
@Controller
public class ClientRouterController {
//跳转首页
@GetMapping({"/","/index"})
public String toHomePage(){
return "index";
}
//跳转登录页面
@GetMapping("/login")
public String toLogin(HttpSession session){
if(session.getAttribute("user")!=null){
return "redirect:/";
}
return "login";
}
//跳转注册页面
@GetMapping("/register")
public String toRegister(){
return "register";
}
//跳转个人订单页面
@GetMapping("/{userName}/orders")
public String toOrderCenter(@PathVariable("userName") String userName,HttpSession session){
User user= (User) session.getAttribute("user");
if(user!=null && user.getUserName().equals(userName)){
return "user_orders";
}
return "redirect:/login";
}
//跳转购物车页面
@GetMapping("/{userName}/shopping_cart")
public String toUserShoppingCart(@PathVariable("userName") String userName,HttpSession session){
User user= (User) session.getAttribute("user");
if(user!=null && user.getUserName().equals(userName)){
return "shopping_cart";
}
return "redirect:/login";
/**
* 批量删除购物车
* @param cartIds
* @return
*/
@DeleteMapping("/list")
public ResultVO deleteCartItem(@RequestBody int[] cartIds) {
shoppingCartService.deleteShoppingCarts(cartIds);
return new ResultVO(ResultCode.SUCCESS);
}
}
/**
* @Description: 用户管理模块控制器
*/
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
/**
* 分页获取用户列表
* @param page
* @param limit
* @return
*/
@GetMapping("/list")
public ResultVO getUserList(@RequestParam(required = false) Integer page, @RequestParam(required = false) Integer limit) {
List<User> users= userService.selectAll(page,limit);
PageInfo pageInfo = new PageInfo(users);
return new ResultVO(ResultCode.SUCCESS,(int)pageInfo.getTotal(),users);
public ResultVO deleteOrder(@PathVariable("orderId") Integer orderId) {
int orders = orderService.deleteByOrderId(orderId);
return new ResultVO(ResultCode.SUCCESS,null);
}
/* @GetMapping("/list/user_order/{userId}")
public ResultVO getOrderByUserId(@PathVariable("userId") Integer userId) {
List<Order> orders = orderService.selectByUserId(userId);
if(orders.size()!=0)
{
return new ResultVO(ResultCode.SUCCESS,orders);
}
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND,null);
}*/
@GetMapping("/list/{orderId}")
public ResultVO getOrderByOrderId(@PathVariable("orderId") Integer orderId) {
Order orders = orderService.selectByOrderId(orderId);
if(orders!=null)
return new ResultVO(ResultCode.SUCCESS,orders);
else
return new ResultVO(ResultCode.RECORD_NOT_FOUND,null);
}
/**
* 多条件搜索订单 ---- by guozongchao
* @param order
* @param page
* @param limit
* @return
*/
@GetMapping("/search")
public ResultVO searchOrders(Order order, Integer page, Integer limit) {
if (order.getConsigneeName().isEmpty()) {
order.setConsigneeName(null);
}
List<Order> orders = orderService.searchOrders(order, page, limit);
PageInfo pageInfo = new PageInfo(orders);
return new ResultVO(ResultCode.SUCCESS, (int) pageInfo.getTotal(), orders);
}
}