java 枚举 sql,MyBatis Java布尔值转换为Sql枚举

I am using MyBatis with MySql in my project.

I have:

myField ENUM('yes','no')

and I want to map in to java boolean value:

I know I can modify all mybatis templates, e.g.:

UPDATE

myTable

...

myField =

'yes'

'no'

,

...

WHERE

...

But can I do this in more convenient way?

解决方案

It seems the best way to solve this is to implement my own boolean type handler:

public class YesNoBooleanTypeHandler extends BaseTypeHandler {

@Override

public void setNonNullParameter(PreparedStatement ps, int i, Boolean parameter, JdbcType jdbcType)

throws SQLException {

ps.setString(i, convert(parameter));

}

@Override

public Boolean getNullableResult(ResultSet rs, String columnName)

throws SQLException {

return convert(rs.getString(columnName));

}

@Override

public Boolean getNullableResult(ResultSet rs, int columnIndex)

throws SQLException {

return convert(rs.getString(columnIndex));

}

@Override

public Boolean getNullableResult(CallableStatement cs, int columnIndex)

throws SQLException {

return convert(cs.getString(columnIndex));

}

private String convert(Boolean b) {

return b ? "yes" : "no";

}

private Boolean convert(String s) {

return s.equals("yes");

}

}

and then to use it in the mapper template:

UPDATE

myTable

...

myField = #{myField ,typeHandler=YesNoBooleanTypeHandler}

...

WHERE

...