Java tutorial
/* * Copyright 2014,2015 agwlvssainokuni * * 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 cherry.foundation.type.mybatis; import java.sql.CallableStatement; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import org.apache.ibatis.type.BaseTypeHandler; import org.apache.ibatis.type.JdbcType; import org.apache.ibatis.type.MappedTypes; import org.joda.time.LocalDate; @MappedTypes(LocalDate.class) public class JodaLocalDateTypeHandler extends BaseTypeHandler<LocalDate> { @Override public void setNonNullParameter(PreparedStatement ps, int i, LocalDate parameter, JdbcType jdbcType) throws SQLException { ps.setDate(i, new Date(parameter.toDate().getTime())); } @Override public LocalDate getNullableResult(ResultSet rs, String columnName) throws SQLException { Date date = rs.getDate(columnName); if (date == null) { return null; } return new LocalDate(date.getTime()); } @Override public LocalDate getNullableResult(ResultSet rs, int columnIndex) throws SQLException { Date date = rs.getDate(columnIndex); if (date == null) { return null; } return new LocalDate(date.getTime()); } @Override public LocalDate getNullableResult(CallableStatement cs, int columnIndex) throws SQLException { Date date = cs.getDate(columnIndex); if (date == null) { return null; } return new LocalDate(date.getTime()); } }