毕业设计商城后台管理系统

商城后端管理系统

1商品管理

1.1分页查询

使用pageHelper插件，注意那个jar包是和springBoot整合的。

1.11controller层

@RequestMapping(value = "/list",method = RequestMethod.POST)
    public PageInfo<ProductVO>  listGoods(@RequestBody ProductVO productVO){
        System.out.println(productVO);
        PageInfo<ProductVO> 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<com.qfedu.fmmall.vo.ProductVO> list = productMapper.selectProductByPage(productVO);
        System.out.println(list.size());

        PageInfo<com.qfedu.fmmall.vo.ProductVO> 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
@Setter
public 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>

<font color=red>                            </font>

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,
      islock
from users
where 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,或者微信