MyBatis Microsoft OffsetDateTimeTypeHandlerJDBC42

OffsetDateTimeTypeHandlerJDBC42.java

public class OffsetDateTimeTypeHandlerJDBC42 extends BaseTypeHandler<OffsetDateTime> {

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

	@Override
	public OffsetDateTime getNullableResult(ResultSet rs, String columnName) throws SQLException {
		return toOffsetDateTime(rs.getObject(columnName, DateTimeOffset.class));
	}

	@Override
	public OffsetDateTime getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
		return toOffsetDateTime(rs.getObject(columnIndex, DateTimeOffset.class));
	}

	@Override
	public OffsetDateTime getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
		return toOffsetDateTime(cs.getObject(columnIndex, DateTimeOffset.class));
	}

	private OffsetDateTime toOffsetDateTime(DateTimeOffset dto) {
		if (dto != null) {
			return OffsetDateTime.ofInstant(dto.getTimestamp().toInstant(),
			        ZoneOffset.ofHours(dto.getMinutesOffset() / 60));
		}
		return null;
	}
}