java 写oracle clob_Java将数据写入Oracle的Clob字段中

---------------------将大量数据写入Clob字段中-------------

一。得到连接

def dbDriver = "oracle.jdbc.driver.OracleDriver";

def url =  "jdbc:oracle:thin@xxx

def username = "foi";

def password = "foi";

Connection conn = null;

Class.forName(dbDriver);

DriverManager.setLoginTimeout(30);

conn = DriverManager.getConnection(url, username, password);

二。写sql语句

def sql=""" update notice set title=?,publish_time=?,info_body=? where id=1""";

三。预编译

def title=params.title;

def infoBody=params.infoBody;

def publishTime="2012-12-12"

def pstm=conn.prepareStatement(sql);

Reader clobReader = new StringReader(infoBody);    pstm.setString(1,title);

pstm.setString(2, publishTime);

pstm.setCharacterStream(3, clobReader,infoBody.length());    pstm.executeUpdate();