* @param insertSQL 插入sql语句 有clob字段时，值必须设置成empty_clob()函数 例:insert into ba valus(1,empty_clob())
// 定义预处理
pstmt = null;
try{
public static String getClobString(Clob c) {
rs = pstmt.executeQuery();
* @param c
out.close();
Reader reader=c.getCharacterStream();
// 插入数据库的sql
*
// 设置不自动提交
* @param con 数据库链接
return sb.toString();
pstmt.executeUpdate();
}

query = updateSQL;
}
os.write(data,0,readed);
{

复制代码 代码如下:

/**

}
con.commit();
StringBuffer sb = new StringBuffer();
rs.close();
* @return
}
}

import java.io.BufferedOutputStream;
while (readed != -1)
e.printStackTrace();
*/
if(rs.next())
if (reader == null) {
InputStream is = (InputStream)(new ByteArrayInputStream(bigString.getBytes()));
* @param updateSQL 带有修改的查询语句,并应增加条件判断.例：select * from BA where ba_id = '"+ba.getBA_id()+"' for update
char[] charbuf = new char[4096];
*/
// TODO Auto-generated catch block
}
public class ClobUtil {
// 得到指定的clob字段
{
java.sql.PreparedStatement pstmt = con.prepareStatement( query);
public static void copyStream( InputStream is, OutputStream os )
}
* @param updateColumn 要插入的表字段名

* @param is 输入流
* @throws SQLException
*/
/**
ResultSet rs = null;

// 采用流的方式处理结果集
oracle.sql.CLOB singnaturedateClob = (oracle.sql.CLOB)rs.getClob(updateColumn);
pstmt = con.prepareStatement(query);
BufferedOutputStream out = new BufferedOutputStream(singnaturedateClob.getAsciiOutputStream());
import java.sql.Clob;
* @param os 输出流
sb.append(charbuf, 0, i);
// 把clob字段放到输出流当中
return true;
// 执行更改
* @return

} catch (IOException e) {
return "";