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: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: CHAR to BOOLEAN - Custom Type Handler
Date: Mon, 6 Mar 2006 18:32:56 +0100
Message-ID: <50CA25BD6EEA954FA592C097399942E30E4636DB@CM1.wis.local>
Thread-Topic: CHAR to BOOLEAN - Custom Type Handler
Thread-Index: AcZBPXHfupQFXByURyC5J014nZIaHQABhodw
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>

It is a lot easier to implement interface TypeHandlerCallback, this =
implementation will then be wrapped in a class that hides =
PreparedStatement and other artifacts.

For a good example which you can modify:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg02792.html

Hope this helps,

Niels

-----Original Message-----
From: ggb275@tid.es [mailto:ggb275@tid.es]=20
Sent: maandag 6 maart 2006 17:48
To: user-java@ibatis.apache.org
Subject: Re: CHAR to BOOLEAN - Custom Type Handler

Thank you Larry, it worked.

I think it could be simpler to use the same strings used by the Boolean=20
class ("true" and "false", ignoring case).  At least to define them as=20
the default values for TRUE_STRING/FALSE_STRING.

package com.ibatis.sqlmap.engine.type;

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

import com.ibatis.sqlmap.engine.type.TypeHandler;

public class TrueFalseTypeHandler implements TypeHandler {

    public void setParameter(PreparedStatement ps, int i, Object=20
parameter, String jdbcType) throws SQLException {
        ps.setString( i, ((Boolean) parameter).toString() );
    }

    public Object getResult(ResultSet rs, String columnName) throws=20
SQLException {
        return Boolean.valueOf( rs.getString( columnName ) );
    }

    public Object getResult(ResultSet rs, int columnIndex) throws=20
SQLException {
        return Boolean.valueOf( rs.getString( columnIndex ) );
    }

    public Object getResult(CallableStatement cs, int columnIndex)=20
throws SQLException {
        return Boolean.valueOf( cs.getString( columnIndex ) );
    }

    public Object valueOf(String string) {      =20
        return Boolean.valueOf( string );      =20
    }

    public boolean equals(Object object, String string) {
        return  Boolean.valueOf( string ).equals( object );
    }
}

Best regards,
Guido Garc=EDa Bernardo.

Larry Meadors escribi=F3:
> 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 =
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 =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
>
>  =20