毕业设计商城后台管理系统
文章目录
商城后端管理系统
1商品管理
1.1分页查询
使用pageHelper插件,注意那个jar包是和springBoot整合的。
1.11controller层
@RequestMapping(value = "/list",method = RequestMethod.POST) public PageInfo listGoods(@RequestBody ProductVO productVO){ System.out.println(productVO); PageInfo pageInfo=productService.selecProductBypage(productVO); return pageInfo; }
1.12 Service层
@Override public PageInfo selecProductBypage(com.qfedu.fmmall.vo.ProductVO productVO) { productVO.setPageSize(10); //分页处理 com.github.pagehelper.PageHelper.startPage(productVO.getPageNum(), productVO.getPageSize()); List list = productMapper.selectProductByPage(productVO); System.out.println(list.size()); PageInfo pageInfo = new PageInfo(list); pageInfo.setSize(list.size()); return pageInfo; }
1.13查询封装的VO
package com.qfedu.fmmall.vo;import com.fasterxml.jackson.annotation.JsonFormat;import com.fasterxml.jackson.annotation.JsonIgnoreProperties;import lombok.Data;import lombok.Getter;import lombok.Setter;import java.io.Serializable;import java.util.Date;@Data@Getter@Setterpublic class ProductVO implements Serializable { private Integer pageNum = 1; //当前页 private Integer pageSize = 9; //页大小 private String id; private String product_name; private String product_id; private String content; /* * * 商品的分类id*/ private String category_id; /* * 商品套餐名字 * */ private String sku_name; /* * 商品的口味 * */ private String untitled; /* * 商品图片路径 * * */ private String url; /* * * 商品的分类名称*/ private String category_name; /*商品是否上架 * */ private String isup; /* * 商品销售数量 * */ private Integer sold_num; @JsonFormat(pattern = "yy-MM-dd") private Date create_time; @JsonFormat(pattern = "yy-MM-dd") private Date update_time;// category_id// root_category_id// sold_num// product_status// content// create_time// update_time// isup}
1.14mapper实现
public List<com.qfedu.fmmall.vo.ProductVO> selectProductByPage(com.qfedu.fmmall.vo.ProductVO productVO);
1.15 sql实现
<select id="selectProductByPage" parameterType="com.qfedu.fmmall.vo.ProductVO" resultType="com.qfedu.fmmall.vo.ProductVO"> SELECT p.product_id,product_name,ps.sku_name,ps.untitled, i.url,p.isup,p.category_id,c.category_name,sold_num,content,p.create_time,p.update_time from product p, category c,product_img i,product_sku ps where p.category_id=c.category_id and p.product_id=i.item_id and p.product_id=ps.product_id and p.product_status=1 <if test="product_name != null and product_name != ''"> and product_name like concat('%',#{product_name},'%') </if> <if test="category_name != null and category_name != ''"> and category_name =#{category_name} </if> <if test="isup !=null and isup!=''"> and isup=#{isup} </if> <if test="create_time != null and create_time != ''"> and create_time = #{create_time} </if> <if test="update_time != null and update_time != ''"> and update_time = #{update_time} </if> ORDER BY p.create_time desc </select>
if 里面对应你的前端的输入框的查询功能,没有输入就为空
2地址管理
2.11controller层(需要token校验才可以进行登录)
@GetMapping("/query_page") @ApiImplicitParams({ @ApiImplicitParam(dataType = "string",name = "userId",value = "用户Id",required = true), @ApiImplicitParam(dataType = "string",name = "status",value = "地址状态",required = false), @ApiImplicitParam(dataType = "int",name = "pageNum",value = "当前页数",required = true), @ApiImplicitParam(dataType = "int",name = "limit",value = "页数大小",required = false), }) public ResultVO queryAddressByUserIdByPage( @RequestParam("token")String token,String userId, String status, int pageNum, int limit){ return userAddrService.queryAddressByPage(userId,status,pageNum,limit); }
2.12 Service层
//通过地址id进行相关的查询dfdsf @Override public ResultVO deleteByAddrId(String AddrId) { Integer AddrId1 = Integer.valueOf(AddrId); UserAddr userAddr = userAddrMapper.selectByPrimaryKey(AddrId1); System.out.println(userAddr); userAddr.setStatus("0"); //这个是tkmapper自己封装的方法 int i = userAddrMapper.updateByPrimaryKey(userAddr); return new ResultVO(ResultStatus.OK,"通过地址Id删除用户地址成功",i); }
3.订单管理
商品的相关的订单展现 这里就不作为展示
4 用户管理
功能:可以进行锁定用户,可以对用户进行修改,增加相关的信息,可以对评论进行审核
4.11用户进行查询
4.12controller层
// 用户分页查询 public ResultVO queryAllUserByPasge(@RequestBody Users users,@RequestHeader String token){ System.out.println(token+"token-------------"); PageInfo pageInfo = userService.queryAllUsersByPage(users,token); return new ResultVO(ResultStatus.OK, "用户分页查询成功", pageInfo); }
4.13 Service层
@Override public PageInfo queryAllUsersByPage(Users users,String token) { if(StringUtil.isNotEmpty(token)) { users.setPageSize(10); //分页处理 com.github.pagehelper.PageHelper.startPage(users.getPageNum(), users.getPageSize()); List<Users> list = userDao.queryAllUsersByPage(users); System.out.println(list.size()); PageInfo<Users> pageInfo = new PageInfo<>(list); pageInfo.setSize(list.size()); return pageInfo; }else { return null; } }
4.14 sql实现
<select id="queryAllUsersByPage" resultType="com.qfedu.fmmall.entity.Users"> select user_id userId, username, password, nickname, realname, user_img, user_mobile, user_email, user_sex, user_birth, user_regtime, user_modtime, islockfrom userswhere 1=1 <if test="islock !=null and islock!=''"> and islock=#{islock} </if> <if test="username !=null and username!=''"> and username like concat('%',#{username},'%') </if> <if test="userMobile !=null and userMobile!=''"> and user_mobile like concat('%',#{userMobile},'%') </if> <if test=" userRegtime!=null and userRegtime!=''"> and user_modtime=#{userRegtime} </if> </select>
注意在企业开发中需要列出来需要查询的字段名称
需要源码的可以加上我的QQ,或者微信,点击下面的链接,鼠标放到微信图标就行。
微信地址