一,示例需求
如下图所示,需要通过多条件模糊查询、需要分页、需要排序
二,实体对象
package com.xxxxxx;
import lombok.Data;
import lombok.ToString;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Table;
@Data
@ToString
@Entity
@Table(name = "server_basic_info")
public class ServerBasicInfo {
@javax.persistence.Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
// ip地址
private String ipAddress;
//服务器用户名
private String serverUserName;
//服务器密码
private String serverPass;
//业务分组
private String businessGroup;
//status
private Integer status;
private String creator;
//系统类型
private String sysType;
//更新时间