ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gareth Moorst <gazj...@yahoo.co.uk>
Subject RE: boolean JavaType and mapping
Date Fri, 20 Jan 2006 08:41:37 GMT
Here's one I wrote to do just that. Feel free to use it (just don't tell my boss)

package com.phones4u.datamanagement.datamodel.ibatis.typehandler;

import java.sql.SQLException;
import java.sql.Types;

import com.ibatis.sqlmap.client.extensions.ParameterSetter;
import com.ibatis.sqlmap.client.extensions.ResultGetter;
import com.ibatis.sqlmap.client.extensions.TypeHandlerCallback;

 * Custom type handler for ibatis to convert between boolean and smallint values 
 * @author gareth.moorst
public class SmallIntBooleanTypeHandler implements TypeHandlerCallback

    public void setParameter(ParameterSetter setter, Object parameter) throws SQLException
        if (parameter == null) {
        } else {
            Boolean bool = (Boolean) parameter;
            short boolVal = 0;
            if (bool.booleanValue())
                boolVal = 1;

    public Object getResult(ResultGetter getter) throws SQLException
        if (getter.wasNull())
            return Boolean.FALSE;
        short dbVal = getter.getShort();
        if (dbVal == 1)
            return Boolean.TRUE;
        return Boolean.FALSE;

    public Object valueOf(String s)
        return s;


Niels Beekman <n.beekman@wis.nl> wrote: You could use a typehandler to do that:


-----Original Message-----
From: Olivier Antoine [mailto:oli.antoine@gmail.com] 
Sent: donderdag 19 januari 2006 23:20
To: user-java@ibatis.apache.org
Subject: boolean JavaType and mapping

Hello everyone,
I have to re-write a website with an existant MySQL database with an 
important number of data ...so i could not change database structure 
(column type and so on)

I m'a sking if it's possible and so ...How to?

make a mapping between
a boolean from my java bean class and an integer in my database column 

for example when in my database I have 1 it return true in my boolean 
and inverse.

thanks a lot,

Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo.
View raw message