sql server中text类型字段,用sql语句获取时,java要用Clob类型相对应。
1.将 获取的对象强转为Clob类型;
2.将Clob类型转换为String类型
/*
* 将Clob类型转化为String类型
*/
public static String ClobToString(Clob clob) {
String str = "";
try {
Reader is = clob.getCharacterStream();
BufferedReader br = new BufferedReader(is);
String s = br.readLine();
StringBuffer sb = new StringBuffer();
while (s != null) {
sb.append(s);
s = br.readLine();
}
str = sb.toString();
} catch (Exception e) {
e.printStackTrace();
}
return str;
}