JDBCHelper.java

import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.sql.Types;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Optional;

public class JdbcHelper {

    public static Integer getInteger(ResultSet rs, String label) throws SQLException {
        return rs.getObject(label, Integer.class);
    }

    public static LocalDateTime getLocalDateTime(ResultSet rs, String label) throws SQLException {
        return Optional.ofNullable(rs.getTimestamp(label))
            .map(Timestamp::toLocalDateTime)
            .orElse(null);
    }

    public static LocalDate getLocalDate(ResultSet rs, String label) throws SQLException {
        return Optional.ofNullable(rs.getDate(label))
            .map(Date::toLocalDate)
            .orElse(null);
    }

    public static void setInteger(PreparedStatement ps, int offset, Integer value) throws SQLException {
        ps.setObject(offset, value, Types.INTEGER);
    }

    public static void setLong(PreparedStatement ps, int offset, Long value) throws SQLException {
        ps.setObject(offset, value, Types.BIGINT);
    }

}