运用Java如何存取Oracle中的CLOB类型字段

运用Java如何存取Oracle中的CLOB类型字段2007年06月01日 星期五 10:47import java.sql.*; 
import java.io.*; 
import oracle.jdbc.driver.OracleResultSet; 
import oracle.sql.CLOB; 

public class TestOracleClob implements Serializable{ 
public static void main(String[] args) 
{ 
//create table test (id integer,content clob); 
System.out.println("-------------------insert -----------------"); 
try{ 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@fangm:1521:LICSFC","SFC","SFC"); 
//con.setAutoCommit(false); 
//Ok 1 
String sql="insert into test values(1,empty_clob())"; 
Statement stmt=con.createStatement(); 
ResultSet rs=stmt.executeQuery(sql); 
String sqll="select content from test where id=1 for update"; 
ResultSet rss=stmt.executeQuery(sqll); 
if(rss.next()){ 
CLOB clob = ((OracleResultSet)rss).getCLOB(1); 
clob.putString(1,"ddddddddddddddddddddddddddddddddddd"); 
sql="update test set content=? where id=1"; 
PreparedStatement pstmt=con.prepareStatement(sql); 
pstmt.setClob(1,clob); 
pstmt.executeUpdate(); 
pstmt.close(); 
} 
//Ok 2