Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of larry.meadors@gmail.com
 designates 66.249.82.206 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=P8hq0vqvRddxoV2gdDV3MMp/SuLsX7Sr/RPtm/xmGxIQA5fboSeX8zu16tHD9a/3XtdQLVY/FFkE989hrQ1tnbx4elKESbU3ovFDJfT6FjoJw5GWU5IRTPe1w5OGYrmjj9zmD1nQ0xK9XwZIfYF+5iW/fRn2Q7y/wiNiwAvYBFE=
Message-ID: <a10a823c0603060804h7fe7c70dt3e70476fd84ca30d@mail.gmail.com>
Date: Mon, 6 Mar 2006 09:04:43 -0700
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: CHAR to BOOLEAN - Custom Type Handler
In-Reply-To: <440C0726.30907@tid.es>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <440C0726.30907@tid.es>

I think this will work:

=3D=3D=3D

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 =3D "Y";
  protected String FALSE_STRING =3D "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 SQLExcept=
ion {
    return stringToBool(rs.getString(columnName));
  }

  public Object getResult(ResultSet rs, int columnIndex) throws SQLExceptio=
n {
    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 =3D=3D b) return null;
    return b.booleanValue()?TRUE_STRING:FALSE_STRING;
  }
  private Boolean stringToBool(String s){
    if (null =3D=3D s) return null;
    return Boolean.valueOf(s.equalsIgnoreCase(TRUE_STRING));
  }
}

=3D=3D=3D

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
=3D "T" and FALSE_STRING =3D "F".

Larry