Using LocalDate fields with BeanMapper in JDBI

LocalDateColumnMapper.java

//
//  USAGE:
//
// 		jdbi.registerColumnMapper(new LocalDateColumnMapper());
//

import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.LocalDate;

import org.skife.jdbi.v2.StatementContext;
import org.skife.jdbi.v2.tweak.ResultColumnMapper;

public class LocalDateColumnMapper implements ResultColumnMapper<LocalDate> {

	@Override
	public LocalDate mapColumn(ResultSet r, int columnNumber, StatementContext ctx) throws SQLException {
		return toLocalDate(r.getDate(columnNumber));
	}

	@Override
	public LocalDate mapColumn(ResultSet r, String columnLabel, StatementContext ctx) throws SQLException {
		return toLocalDate(r.getDate(columnLabel));
	}

	private static LocalDate toLocalDate(Date date) {
		return (date == null) ? null : date.toLocalDate();
	}

}