qq_42981579的博客

if(1? != ‘’) @Query(value = "select id from tbl where if(?1!='', cust_code = ?1, 1=1) " + "and if(?2!='', name LIKE CONCAT('%',?2,'%'), 1=1) and if(?3 is not null, is_delete = ?3, 1=1) ", nativeQuery = true) List<Entity> findEntit

实体类TaskWorkEntity@Entity@Data@Accessors(chain = true)@Table(name = "task_work")public class TaskWorkEntity extends BaseEntity { private Long id; // EcTaskEntity 关联关系 唯一字段 private String ecTaskSerial; private String taskWorkName;

import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; Page<Entity> page; // 倒序排序 Sort sort =..