YearMonthTypeHandler.java

  1. /*
  2.  *    Copyright 2009-2021 the original author or authors.
  3.  *
  4.  *    Licensed under the Apache License, Version 2.0 (the "License");
  5.  *    you may not use this file except in compliance with the License.
  6.  *    You may obtain a copy of the License at
  7.  *
  8.  *       http://www.apache.org/licenses/LICENSE-2.0
  9.  *
  10.  *    Unless required by applicable law or agreed to in writing, software
  11.  *    distributed under the License is distributed on an "AS IS" BASIS,
  12.  *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13.  *    See the License for the specific language governing permissions and
  14.  *    limitations under the License.
  15.  */
  16. package org.apache.ibatis.type;

  17. import java.sql.CallableStatement;
  18. import java.sql.PreparedStatement;
  19. import java.sql.ResultSet;
  20. import java.sql.SQLException;
  21. import java.time.YearMonth;

  22. /**
  23.  * Type Handler for {@link java.time.YearMonth}.
  24.  * <p>
  25.  * YearMonthTypeHandler relies upon
  26.  * {@link java.time.YearMonth#parse YearMonth.parse}. Therefore column values
  27.  * are expected as strings. The format must be uuuu-MM. Example: "2016-08"
  28.  *
  29.  * @since 3.4.5
  30.  * @author Björn Raupach
  31.  */
  32. public class YearMonthTypeHandler extends BaseTypeHandler<YearMonth> {

  33.   @Override
  34.   public void setNonNullParameter(PreparedStatement ps, int i, YearMonth yearMonth, JdbcType jt) throws SQLException {
  35.     ps.setString(i, yearMonth.toString());
  36.   }

  37.   @Override
  38.   public YearMonth getNullableResult(ResultSet rs, String columnName) throws SQLException {
  39.     String value = rs.getString(columnName);
  40.     return value == null ? null : YearMonth.parse(value);
  41.   }

  42.   @Override
  43.   public YearMonth getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
  44.     String value = rs.getString(columnIndex);
  45.     return value == null ? null : YearMonth.parse(value);
  46.   }

  47.   @Override
  48.   public YearMonth getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
  49.     String value = cs.getString(columnIndex);
  50.     return value == null ? null : YearMonth.parse(value);
  51.   }

  52. }