shardingjdbc

### 强制查询走主库

原文章：https://cloud.tencent.com/developer/article/2063098

---------------------

### 解析LocalTimeDate等jdk8时间类异常

原因是`LocalDateTimeTypeHandler`没有实现`getObject(String columnLabel, Class<T> type)`方法

解决方案，自己实现typeHandler
```
/**
 * @description: LocalDateTime是为了解决shardingResultSet转换LocalDateTime的问题
 * @author: xiao7
 * @date: 2021/5/27 10:59
 */
@Component
@MappedTypes(LocalDateTime.class)
@MappedJdbcTypes(value = JdbcType.DATE, includeNullJdbcType = true)
public class LocalDateTimeTypeHandler extends BaseTypeHandler<LocalDateTime> {

@Override
    public void setNonNullParameter(PreparedStatement ps, int i, LocalDateTime parameter, JdbcType jdbcType)
            throws SQLException {
        ps.setObject(i, parameter);
    }

@Override
    public LocalDateTime getNullableResult(ResultSet rs, String columnName) throws SQLException {
        return Convert.toLocalDateTime(rs.getObject(columnName));
    }

@Override
    public LocalDateTime getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        return Convert.toLocalDateTime(rs.getObject(columnIndex));
    }

@Override
    public LocalDateTime getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        return Convert.toLocalDateTime(cs.getObject(columnIndex));
    }
}
```
原文章：https://blog.csdn.net/weixin_38650898/article/details/117324283