各位大虾指点下小弟,有关clob字段的存储问题 小弟最近做项目遇到了需要存取clob类型的字段,希望各位大虾能给一些这方面的资料或者代码例子,小弟是新手,所以最好详细点,谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public void saveA(A a) {Session session = getSession();session.beginTransaction();SerializableClob clob = (SerializableClob) a.getDescriptionClob();java.sql.Clob wrapClob = clob.getWrappedClob();oracle.sql.CLOB tmpClob = (oracle.sql.CLOB) wrapClob;tmpClob.putString(1, a.getDescription());session.saveOrUpdate(a);session.evict(a);}public class A{ private Clob descriptionClob; private String description; ....setter ...getter...} Clob clob = ResultSet.getClob("Clob"); // 读取Clob字段 public static String getClobString(Clob clob) { try { Reader reader = clob.getCharacterStream(); if (reader == null) { return ""; } StringBuffer sb = new StringBuffer(); char[] charbuf = new char[4096]; for (int i = reader.read(charbuf); i > 0; i = reader.read(charbuf)) { sb.append(charbuf, 0, i); } return sb.toString(); } catch (Exception e) { return ""; } } 整合SSH2时,遇到莫名其妙xwork2util.ValueStack.findValue问题笔记 struts2中,如何让标签不显示历史记录 用户权限控制问题 JSF无法将输入内容写入数据库 散分:struts连接oracle出错,不知道是何故?牛人指点. 页面显示该页无法显示,后台程序仍在进行!在线等,散分!!! SOS: tomcat下文件的读取 关于div的问题,大家来看看 关于流的问题! hql与延迟加载 求助:jfreechart生成图片显示两个? spring+hibernate在不同的环境下方言找不到的问题?HELP!!!
Session session = getSession();
session.beginTransaction();
SerializableClob clob = (SerializableClob) a.getDescriptionClob();
java.sql.Clob wrapClob = clob.getWrappedClob();
oracle.sql.CLOB tmpClob = (oracle.sql.CLOB) wrapClob;
tmpClob.putString(1, a.getDescription());
session.saveOrUpdate(a);
session.evict(a);
}
public class A{
private Clob descriptionClob;
private String description;
....setter ...getter...}
public static String getClobString(Clob clob) {
try {
Reader reader = clob.getCharacterStream();
if (reader == null) {
return "";
}
StringBuffer sb = new StringBuffer();
char[] charbuf = new char[4096];
for (int i = reader.read(charbuf); i > 0; i = reader.read(charbuf)) {
sb.append(charbuf, 0, i);
}
return sb.toString();
} catch (Exception e) {
return "";
}
}