本篇文章为大家展示了Spring Date jpa 实现获取最新一条数据的方法,内容简明扼要并且容易理解,绝对能使你眼前一亮,通过这篇文章的详细介绍希望你能有所收获。
#Repository
import test.demo.domain.entity.TestEntity;
import org.springframework.data.jpa.repository.support.JpaRepositoryImplementation;
import org.springframework.stereotype.Repository;
@Repository
public interface TestEntityRepository extends JpaRepositoryImplementation<TestEntity,Integer> {
}
#Service
import org.springframework.validation.annotation.Validated;
import javax.validation.constraints.NotBlank;
@Validated
public interface TestService {
/**
* 获取账号最新的一个数据(指单个字段,例如最新时间,最新年龄等)
* @param username
* @return
*/
String findLastage(@NotBlank String username);
}
#ServiceImpl
import test.demo.domain.entity.TestEntity;
import test.demo.repository.TestEntityRepository;
import test.demo.service.TestService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Sort;
import org.springframework.stereotype.Service;
import java.time.LocalDateTime;
import java.util.List;
@Service
public class TestServiceImpl implements TestService {
@Autowired
private TestEntityRepository testEntityRepository;
@Override
public String findLastAge(String username) {
Sort createTime = new Sort(Sort.Direction.DESC, "createTime");
PageRequest of = PageRequest.of(0, 1, createTime);
List<TestEntity> testEntities= testEntityRepository.findAll(((root, criteriaQuery, criteriaBuilder) -> criteriaBuilder.and(
criteriaBuilder.equal(root.get("age"), age),
criteriaBuilder.lessThan(root.get("expiredTime"), LocalDateTime.now())
)));
if (testEntities.isEmpty()){
return null;
}
String age = TestEntities.get(0).getCode();
return age;
}
}
Entity这里就不写了,很普通,只说重点!
看下官方文档的解释:
补充知识:【spring data jpa】根据一个时间字段 查询 时间段的处理方法
处理方法 包含结束时间00.00.00
Date createDate = boxCodeLog.getCreateDate();
if (createDate != null){
LocalDate localDate=createDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
localDate = localDate.plusDays(1);
Date endDate = java.sql.Date.valueOf(localDate);
predicates.add(cb.between(root.get("createDate"),createDate,endDate));
}
包含结束时间 23.59.59
Date createDate = receipt.getCreateDate();
if (createDate != null){
LocalDate localDate=createDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDate();
localDate = localDate.plusDays(1);
Date endDate = new Date(java.sql.Date.valueOf(localDate).getTime()-1L);
predicates.add(cb.between(root.get("createDate"),createDate,endDate));
}
上述内容就是Spring Date jpa 实现获取最新一条数据的方法,你们学到知识或技能了吗?如果还想学到更多技能或者丰富自己的知识储备,欢迎关注亿速云行业资讯频道。
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。