写入数据
1. 向oracle clob字段创建一个空的 empty_clob()对象。insert into PTR_AssetXml(cChr_AssetPlanId,cChr_AssetData,Create_Date,Submitter,Last_Modified_By,Modified_Date,Status,Short_Description,Request_ID) "
+ "values(?,empty_clob(),?,?,?,?,?,?,(select nextid from arschema where schemaid=3555));
2.查询此条记录并且锁定该记录其它会话不可操作此记录select cChr_AssetData from PTR_AssetXml where cChr_AssetPlanId=? for update
3.得到该clob字段 的对象并建立输出流 向该对象写入数据conn.setAutoCommit(false);
rs = pre4.executeQuery();
rs.next();
clob = (CLOB) rs.getClob(1);
bw = new BufferedWriter(clob.getCharacterOutputStream());
bw.write(str.toString());
if (bw != null) {
bw.close();
}
conn.commit();
读取数据
1 .查询出此字段并获得此clob字段的对象并建立输入流
try {
pre1 = daodb.pre(ConstantTool.sqlsearch_3555_blob);
pre1.setString(1, "PD20140924154");
rs = pre1.executeQuery();
CLOB c;
String str;
while (rs.next()) {
c = (oracle.sql.CLOB) rs.getClob(1);
bf = new BufferedReader(c.getCharacterStream());
while ((str = bf.readLine()) != null) {
System.out.println(str);<