数据库datatime和java date类型不匹配

Question

数据库中字段是datetime类型的封装到一个data类型的类中，报这种类型不匹配怎样解决

Answer 1

要互转一下：

//Date转为LocalDateTime
        DateTimeFormatter sdf1 = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
        Date nowDate = new Date();
        LocalDateTime nowL = Instant.ofEpochMilli(nowDate.getTime()).atZone(ZoneId.systemDefault()).toLocalDateTime();
        //或LocalDateTime nowL = nowDate.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime()
        System.out.println(sdf1.format(nowL));


        //LocalDateTime转为Date
        SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        LocalDateTime nowLocalDateTime = LocalDateTime.now();
        Date nowD = Date.from(nowLocalDateTime.atZone(ZoneId.systemDefault()).toInstant());
        System.out.println(sdf2.format(nowD));

    }