当前位置：首页 > news >正文

LocalDate 数据库不兼容问题，因为LocalDate 是 long 类型的

news 文章来源：https://blog.csdn.net/weixin_45958839/article/details/138540772 2024/5/19 21:32:39

我今天遇到一报错：

SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@316f9272] was not registered for synchronization because synchronization is not active JDBC Connection [HikariProxyConnection@2127597288 wrapping com.mysql.cj.jdbc.ConnectionImpl@7cc9b176] will not be managed by Spring ==> Preparing: SELECT cel FROM XXXX WHERE (time >= ? AND time <= ?) ==> Parameters: 1714406400000(Long), 1715011200000(Long) <== Total: 0 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@316f9272] 查不出数据来

但是数据库能正常查出数据来

原因就是 LocalDate 数据库不兼容问题也就是时间戳的问题

原来代码处理方式：

public List<MechanicalSystem> getElectricityForLastSevenDays() { LocalDate now = LocalDate.now(); LocalDate sevenDaysAgo = now.minusDays(7);LambdaQueryWrapper<MechanicalSystem> queryWrapper = Wrappers.lambdaQuery();queryWrapper.ge(MechanicalSystem::getTime, sevenDaysAgo.atStartOfDay(ZoneId.systemDefault()).toInstant().toEpochMilli());queryWrapper.le(MechanicalSystem::getTime, now.atStartOfDay(ZoneId.systemDefault()).toInstant().toEpochMilli());queryWrapper.select(MechanicalSystem::getCel); // 只查询cel字段，优化查询性能return energyAllEvaluateMapper.selectList(queryWrapper);
}   这段代码用LocalDate 的方式查不到数据库的数据

后来改用Hutool 的方式

public List<MechanicalSystem> getElectricityForLastSevenDays() {// 使用Hutool获取当前日期和七天前的日期Date nowDate = DateUtil.date();Date sevenDaysAgoDate = DateUtil.offsetDay(nowDate, -7);// 将日期转换为字符串格式，假设数据库字段期望的格式为"yyyy-MM-dd HH:mm:ss" (避免时间戳错误)String sevenDaysAgoStr = DateUtil.format(sevenDaysAgoDate, "yyyy-MM-dd HH:mm:ss");String nowStr = DateUtil.format(nowDate, "yyyy-MM-dd HH:mm:ss");LambdaQueryWrapper<MechanicalSystem> queryWrapper = Wrappers.lambdaQuery();// 将字符串作为查询条件queryWrapper.ge(MechanicalSystem::getTime, sevenDaysAgoStr);queryWrapper.le(MechanicalSystem::getTime, nowStr);queryWrapper.select(MechanicalSystem::getCel); // 只查询cel字段，优化查询性能return energyAllEvaluateMapper.selectList(queryWrapper);}

相关文章：