1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package examples.simple;
17
18 import java.sql.CallableStatement;
19 import java.sql.PreparedStatement;
20 import java.sql.ResultSet;
21 import java.sql.SQLException;
22
23 import org.apache.ibatis.type.JdbcType;
24 import org.apache.ibatis.type.TypeHandler;
25
26 public class YesNoTypeHandler implements TypeHandler<Boolean> {
27
28 @Override
29 public void setParameter(PreparedStatement ps, int i, Boolean parameter, JdbcType jdbcType) throws SQLException {
30 ps.setString(i, parameter ? "Yes" : "No");
31 }
32
33 @Override
34 public Boolean getResult(ResultSet rs, String columnName) throws SQLException {
35 return "Yes".equals(rs.getString(columnName));
36 }
37
38 @Override
39 public Boolean getResult(ResultSet rs, int columnIndex) throws SQLException {
40 return "Yes".equals(rs.getString(columnIndex));
41 }
42
43 @Override
44 public Boolean getResult(CallableStatement cs, int columnIndex) throws SQLException {
45 return "Yes".equals(cs.getString(columnIndex));
46 }
47 }