Java tutorial
/** * Copyright (C) 2015 digitalfondue (info@digitalfondue.ch) * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package ch.digitalfondue.npjt.mapper; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Timestamp; import java.sql.Types; import java.time.Instant; import org.springframework.jdbc.core.RowMapper; import org.springframework.jdbc.core.namedparam.MapSqlParameterSource; import ch.digitalfondue.npjt.mapper.ColumnMapperFactory; import ch.digitalfondue.npjt.mapper.ParameterConverter; public class InstantMapper extends ColumnMapper { private static final int ORDER = Integer.MAX_VALUE - 5; public InstantMapper(String name, Class<?> paramType) { super(name, paramType); } @Override public Object getObject(ResultSet rs) throws SQLException { return toInstant(rs.getTimestamp(name)); } private static Instant toInstant(Timestamp ts) { return ts != null ? ts.toInstant() : null; } public static class Converter implements ParameterConverter { @Override public boolean accept(Class<?> parameterType) { return Instant.class.equals(parameterType); } @Override public void processParameter(String parameterName, Object arg, Class<?> parameterType, MapSqlParameterSource ps) { ps.addValue(parameterName, arg != null ? Timestamp.from((Instant) arg) : null, Types.TIMESTAMP); } @Override public int order() { return ORDER; } } public static class Factory implements ColumnMapperFactory { @Override public ColumnMapper build(String name, Class<?> paramType) { return new InstantMapper(name, paramType); } @Override public int order() { return ORDER; } @Override public boolean accept(Class<?> paramType) { return Instant.class.equals(paramType); } @Override public RowMapper<Object> getSingleColumnRowMapper(Class<Object> clzz) { return new RowMapper<Object>() { @Override public Object mapRow(ResultSet rs, int rowNum) throws SQLException { return toInstant(rs.getTimestamp(1)); } }; } } }