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

最新推荐文章于 2024-09-12 14:35:27 发布

里奥酱

最新推荐文章于 2024-09-12 14:35:27 发布

阅读量348

点赞数 9

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/weixin_45958839/article/details/138540772

版权

我今天遇到一报错：

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);
    }