2。xmybatisPlus使用LocalDateTime，LocalDate

　　可能发生的报错信息：
　　Cause: java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.time.LocalDate；解决方案：
　　mybatis-spring-boot-starter 升级至->2.1.1
　　com.alibaba.druid 升级至->1.2.1
　　mysql-connector-java 升级至->5.1.46，
　　升级之前的版本是：
　　mybatis-spring-boot-starter 1.3.0com.alibaba.druid 1.0.7mysql-connector-java 5.1.30升级之后如果如果还有问题
　　查询可能会有以下报错：org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column ＂orderTime＂ from result set. Cause: java.sql.SQLFeatureNotSupportedException: getObject with type  ; SQL []; getObject with type; nested exception is java.sql.SQLFeatureNotSupportedException: getObject with type  Caused by: java.sql.SQLFeatureNotSupportedException: getObject with type  at io.shardingjdbc.core.jdbc.unsupported.AbstractUnsupportedOperationResultSet.getObject(AbstractUnsupportedOperationResultSet.java:223)  at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:38)  at org.apache.ibatis.type.LocalDateTimeTypeHandler.getNullableResult(LocalDateTimeTypeHandler.java:28)
　　解决方案：
　　在自己项目下创建mybatis相同包路径org.apache.ibatis.type的LocalDateTimeTypeHandler类.package org.apache.ibatis.type;   import java.sql.*; import java.time.Instant; import java.time.LocalDateTime; import java.time.ZoneOffset; import java.time.format.DateTimeFormatter;   /** * @className: LocalDateTimeTypeHandler * @author: 112609 * @date: 2022-04-08 17:39 * @description: TODO */   public class LocalDateTimeTypeHandler implements TypeHandler {       private final DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern(＂yyyy-MM-dd HH:mm:ss＂);       @Override     public void setParameter(PreparedStatement preparedStatement, int i, LocalDateTime localDateTime, JdbcType jdbcType) throws SQLException {         if(localDateTime == null) {             preparedStatement.setTimestamp(i, null);         } else {             long epochMilli = localDateTime.toInstant(ZoneOffset.of(＂+8＂)).toEpochMilli();             Timestamp date = new Timestamp(epochMilli);             preparedStatement.setTimestamp(i, date);         }     }       @Override     public LocalDateTime getResult(ResultSet resultSet, String columnName) throws SQLException {         Timestamp timestamp = resultSet.getTimestamp(columnName);         if(timestamp == null){             return null;         }else {             final Instant instant = timestamp.toInstant();             return instant.atZone(ZoneOffset.of(＂+8＂)).toLocalDateTime();         }     }       @Override     public LocalDateTime getResult(ResultSet resultSet, int columnIndex) throws SQLException {         Date date = resultSet.getDate(columnIndex);         if (date == null) {             return null;         } else {             final Instant instant = date.toInstant();             return instant.atZone(ZoneOffset.of(＂+8＂)).toLocalDateTime();         }     }       @Override     public LocalDateTime getResult(CallableStatement callableStatement, int columnIndex) throws SQLException {         Date date = callableStatement.getDate(columnIndex);         if (date == null) {             return null;         } else {             final Instant instant = date.toInstant();             return instant.atZone(ZoneOffset.of(＂+8＂)).toLocalDateTime();         }     } }
　　如果这篇文章解决了你的问题，请不要白嫖我，来个一键三连哦