mybatis怎么读取oracle xmltype类型的数据

Question

如题所述

Answer 1

表结构
CREATE TABLE USERINFO(USERID VARCHAR2(5),
USERNAME VARCHAR2(20),
MEMO CLOB,
constraint PK_USERINFO primary key(USERID));
java代码：
public class OracleClobTypeHandlerCallback implements TypeHandlerCallback {
public void setParameter(ParameterSetter setter, Object obj)
throws SQLException {
CLOB clob = CLOB.empty_lob();
clob.setString(1, (String)obj);
setter.setClob(clob);
}
public Object getResult(ResultGetter getter) throws SQLException {
CLOB clob = (CLOB) getter.getClob();
return (clob == null || clob.length() == 0 )? null :clob.getSubString((long)1, (int)clob.length());
}
public Object valueOf(String param) {
return null;
}
}