转化方法如下
// Clob类型 转String
public String ClobToString(Clob clob) throws SQLException, IOException {
String reString = "";
Reader is = clob.getCharacterStream();// 得到流
BufferedReader br = new BufferedReader(is);
String s = br.readLine();
StringBuffer sb = new StringBuffer();
while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
sb.append(s);
s = br.readLine();
}
reString = sb.toString();
if(br!=null){
br.close();
}
if(is!=null){
is.close();
}
return reString;
}
// String类型转换成Clob类型
public Clob StringToClob(final String string) {
if(null == string || string.trim().length() == 0){
return null;
}
return new org.hibernate.lob.ClobImpl(string);
}
方法调用示例
@Override
public Map<String, Object> seletProjectInfoToNew(String pid) {
Map<String,Object> resultMap = new HashMap<String,Object>();
Map<String,Object> result = new HashMap<String,Object>();
try {
Map plan = informationMapper.seletProjectInfoToNew(pid);
List<Map<String, Object>> map = informationMapper.seletProjectScrollToNew(pid);
String belong_emphasis = ClobToString((Clob) plan.get("belong_emphasis_area_val"));
String belong_area = ClobToString((Clob) plan.get("belong_area_val"));
plan.put("belong_emphasis_area_val",belong_emphasis);
plan.put("belong_area_val",belong_area);
result.put("projectInfo",plan);
result.put("projectAffiliated",map);
ReturnUtil.createSuccess(resultMap,result,CommonRest.QUERY_SUCCESS);
} catch (Exception e) {
e.printStackTrace();
ReturnUtil.createError(resultMap, CommonRest.QUERY_FAILD);
}
return resultMap;
}
亲测有效!!!