/*
 * Copyright 2013 Global Biodiversity Information Facility (GBIF)
 * 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 org.gbif.registry.persistence.mapper.handler;


import org.gbif.api.model.common.DOI;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import javax.annotation.Nullable;

import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;

/**
 * A converter for DOI objects to the database representation.
 * Nulls are passed through.
 */
public class DOITypeHandler implements TypeHandler<DOI> {

  @Override
  public void setParameter(PreparedStatement ps, int i, DOI parameter, JdbcType jdbcType) throws SQLException {
    ps.setObject(i, parameter == null ? null : parameter.toString(), Types.OTHER);
  }

  @Override
  public DOI getResult(ResultSet rs, int columnIndex) throws SQLException {
    return newDOIInstance(rs.getString(columnIndex));
  }

  @Override
  public DOI getResult(ResultSet rs, String columnName) throws SQLException {
    return newDOIInstance(rs.getString(columnName));
  }

  @Override
  public DOI getResult(CallableStatement cs, int columnIndex) throws SQLException {
    return newDOIInstance(cs.getString(columnIndex));
  }

  private DOI newDOIInstance(@Nullable String doi) {
    return doi == null ? null : new DOI(doi);
  }
}

/*
 * Copyright 2013 Global Biodiversity Information Facility (GBIF)
 * 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 org.gbif.registry.persistence.mapper.handler;


import org.gbif.api.model.common.DOI;

import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import javax.annotation.Nullable;

import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;

/**
 * A converter for DOI objects to the database representation using the DOI name.
 * Nulls are passed through.
 */
public class DOITypeHandler implements TypeHandler<DOI> {

  @Override
  public void setParameter(PreparedStatement ps, int i, DOI parameter, JdbcType jdbcType) throws SQLException {
    ps.setObject(i, parameter == null ? null : parameter.getDoiName(), Types.OTHER);
  }

  @Override
  public DOI getResult(ResultSet rs, int columnIndex) throws SQLException {
    return newDOIInstance(rs.getString(columnIndex));
  }

  @Override
  public DOI getResult(ResultSet rs, String columnName) throws SQLException {
    return newDOIInstance(rs.getString(columnName));
  }

  @Override
  public DOI getResult(CallableStatement cs, int columnIndex) throws SQLException {
    return newDOIInstance(cs.getString(columnIndex));
  }

  private DOI newDOIInstance(@Nullable String doi) {
    return doi == null ? null : new DOI(doi);
  }
}

Use DOI names for mybatis