1   
2   
3   
4   
5   
6   
7   
8   
9   
10  
11  
12  
13  
14  
15  
16  package org.apache.ibatis.type;
17  
18  import java.sql.CallableStatement;
19  import java.sql.PreparedStatement;
20  import java.sql.ResultSet;
21  import java.sql.SQLException;
22  
23  
24  
25  
26  public class CharacterTypeHandler extends BaseTypeHandler<Character> {
27  
28    @Override
29    public void setNonNullParameter(PreparedStatement ps, int i, Character parameter, JdbcType jdbcType) throws SQLException {
30      ps.setString(i, parameter.toString());
31    }
32  
33    @Override
34    public Character getNullableResult(ResultSet rs, String columnName) throws SQLException {
35      String columnValue = rs.getString(columnName);
36      if (columnValue != null && !columnValue.isEmpty()) {
37        return columnValue.charAt(0);
38      } else {
39        return null;
40      }
41    }
42  
43    @Override
44    public Character getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
45      String columnValue = rs.getString(columnIndex);
46      if (columnValue != null && !columnValue.isEmpty()) {
47        return columnValue.charAt(0);
48      } else {
49        return null;
50      }
51    }
52  
53    @Override
54    public Character getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
55      String columnValue = cs.getString(columnIndex);
56      if (columnValue != null && !columnValue.isEmpty()) {
57        return columnValue.charAt(0);
58      } else {
59        return null;
60      }
61    }
62  }