CRM项目后台封装Query类实现将Activity的请求对象封装并以分页查询的方式查询具体信息------CRM项目

最新推荐文章于 2024-10-08 17:06:25 发布

旧约Alatus

最新推荐文章于 2024-10-08 17:06:25 发布

阅读量776

点赞数 23

分类专栏： CRM项目 # Spring-Boot框架 # Spring框架文章标签： java java-ee spring boot spring 后端 ajax mvc

本文链接：https://blog.csdn.net/2201_75960169/article/details/136120401

版权

Spring-Boot框架同时被 3 个专栏收录

227 篇文章 0 订阅

订阅专栏

CRM项目

142 篇文章 0 订阅

订阅专栏

Spring框架

131 篇文章 0 订阅

订阅专栏

package com.alatus.query;

import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class ActivityQuery extends BaseQuery{
    private Integer ownerId;

//    将字符串转换为符合这个pattern规范的日期
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date startTime;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date endTime;

    private String name;

    private BigDecimal cost;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;
}

package com.alatus.query;

import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.math.BigDecimal;
import java.util.Date;

@Data
public class ActivityQuery extends BaseQuery{
    private Integer ownerId;

//    将字符串转换为符合这个pattern规范的日期
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date startTime;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date endTime;

    private String name;

    private BigDecimal cost;

    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;
}

package com.alatus.web;

import com.alatus.model.TActivity;
import com.alatus.query.ActivityQuery;
import com.alatus.result.R;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.alatus.service.ActivityService;

@RestController
public class ActivityController {
    @Resource
    private ActivityService activityService;

    @GetMapping(value = "/api/activities")
    public R activityPage(@RequestParam(value = "current",required = false)Integer current,
                          ActivityQuery activityQuery){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TActivity> activityByPage = activityService.getActivityByPage(current);
        return R.OK(activityByPage);
    }
}

package com.alatus.web;

import com.alatus.model.TActivity;
import com.alatus.query.ActivityQuery;
import com.alatus.result.R;
import com.github.pagehelper.PageInfo;
import jakarta.annotation.Resource;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import com.alatus.service.ActivityService;

@RestController
public class ActivityController {
    @Resource
    private ActivityService activityService;

    @GetMapping(value = "/api/activities")
    public R activityPage(@RequestParam(value = "current",required = false)Integer current,
                          ActivityQuery activityQuery){
        if(current == null){
            current = 1;
        }
//        返回结果为PageInfo
        PageInfo<TActivity> activityByPage = activityService.getActivityByPage(current);
        return R.OK(activityByPage);
    }
}

package com.alatus.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

/**
 * 市场活动表
 * t_activity
 */
@Data
public class TActivity implements Serializable {
    /**
     * 主键，自动增长，活动ID
     */
    private Integer id;

    /**
     * 活动所属人ID
     */
    private Integer ownerId;

    /**
     * 活动名称
     */
    private String name;

    /**
     * 活动开始时间
     */
    private Date startTime;

    /**
     * 活动结束时间
     */
    private Date endTime;

    /**
     * 活动预算
     */
    private BigDecimal cost;

    /**
     * 活动描述
     */
    private String description;

    /**
     * 活动创建时间
     */
    private Date createTime;

    /**
     * 活动创建人
     */
    private Integer createBy;

    /**
     * 活动编辑时间
     */
    private Date editTime;

    /**
     * 活动编辑人
     */
    private Integer editBy;

    /**
     * 一对一关联
     */
    private TUser ownerDO;

    private static final long serialVersionUID = 1L;
}

package com.alatus.model;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

/**
 * 市场活动表
 * t_activity
 */
@Data
public class TActivity implements Serializable {
    /**
     * 主键，自动增长，活动ID
     */
    private Integer id;

    /**
     * 活动所属人ID
     */
    private Integer ownerId;

    /**
     * 活动名称
     */
    private String name;

    /**
     * 活动开始时间
     */
    private Date startTime;

    /**
     * 活动结束时间
     */
    private Date endTime;

    /**
     * 活动预算
     */
    private BigDecimal cost;

    /**
     * 活动描述
     */
    private String description;

    /**
     * 活动创建时间
     */
    private Date createTime;

    /**
     * 活动创建人
     */
    private Integer createBy;

    /**
     * 活动编辑时间
     */
    private Date editTime;

    /**
     * 活动编辑人
     */
    private Integer editBy;

    /**
     * 一对一关联
     */
    private TUser ownerDO;

    private static final long serialVersionUID = 1L;
}

---
spring:
  data:
    redis:
      lettuce:
        pool:
          max-idle: 8
          min-idle: 0
          max-wait: -1ms
          max-active: 8
        cluster:
          refresh:
            adaptive: true
            period: 2000
      cluster:
        max-redirects: 3
        nodes: 192.168.189.128:6381,192.168.189.128:6382,192.168.189.130:6383,192.168.189.130:6384,192.168.189.129:6385,192.168.189.129:6386
      password: abc123
      timeout: 5000
---
server:
  port: 8089
  servlet:
    context-path: /
    session:
      persistent: false
---
spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/dlyk?useUnicode=true&characterEncoding=utf-8&useSSL=false
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: abc123
    hikari:
      maximum-pool-size: 30
      minimum-idle: 30
      connection-timeout: 5000
      idle-timeout: 0
      max-lifetime: 18000000
#  设置jackson返回json数据时的时区格式
  jackson:
    time-zone: GMT+8
    date-format: yyyy-MM-dd HH:mm:ss
---
mybatis:
  mapper-locations: classpath:mapper/*.xml
#  configuration:
#    控制台打印SQL语句
#    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

---
spring:
  data:
    redis:
      lettuce:
        pool:
          max-idle: 8
          min-idle: 0
          max-wait: -1ms
          max-active: 8
        cluster:
          refresh:
            adaptive: true
            period: 2000
      cluster:
        max-redirects: 3
        nodes: 192.168.189.128:6381,192.168.189.128:6382,192.168.189.130:6383,192.168.189.130:6384,192.168.189.129:6385,192.168.189.129:6386
      password: abc123
      timeout: 5000
---
server:
  port: 8089
  servlet:
    context-path: /
    session:
      persistent: false
---
spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/dlyk?useUnicode=true&characterEncoding=utf-8&useSSL=false
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: abc123
    hikari:
      maximum-pool-size: 30
      minimum-idle: 30
      connection-timeout: 5000
      idle-timeout: 0
      max-lifetime: 18000000
#  设置jackson返回json数据时的时区格式
  jackson:
    time-zone: GMT+8
    date-format: yyyy-MM-dd HH:mm:ss
---
mybatis:
  mapper-locations: classpath:mapper/*.xml
#  configuration:
#    控制台打印SQL语句
#    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl