Re: CHAR to BOOLEAN - Custom Type Handler

[Larry Meadors]

I think this will work:

===

package com.ibatis.sqlmap.engine.type;

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

public class BooleanYNTypeHandler implements TypeHandler {
  protected String TRUE_STRING = "Y";
  protected String FALSE_STRING = "N";
  public void setParameter(PreparedStatement ps, int i, Object
parameter, String jdbcType) throws SQLException {
    ps.setString(i, boolToString((Boolean) parameter));
  }

  public Object getResult(ResultSet rs, String columnName) throws SQLException {
    return stringToBool(rs.getString(columnName));
  }

  public Object getResult(ResultSet rs, int columnIndex) throws SQLException {
    return stringToBool(rs.getString(columnIndex));
  }

  public Object getResult(CallableStatement cs, int columnIndex)
throws SQLException {
    return stringToBool(cs.getString(columnIndex));
  }

  public Object valueOf(String s) {
    return stringToBool(s);
  }

  public boolean equals(Object object, String string) {
    return  string.equalsIgnoreCase(boolToString((Boolean) object));
  }
  private String boolToString(Boolean b){
    if(null == b) return null;
    return b.booleanValue()?TRUE_STRING:FALSE_STRING;
  }
  private Boolean stringToBool(String s){
    if (null == s) return null;
    return Boolean.valueOf(s.equalsIgnoreCase(TRUE_STRING));
  }
}

===

Let me know if it does, and we'll try to add it to the default type
handlers in the next release.

It would be a real simple exercise to add a BooleanTFTypeHandler, too
- just subclass this and make the default constructor set TRUE_STRING
= "T" and FALSE_STRING = "F".

Larry