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

fffffffffffffffff

fffffffffffffffffffffffffdddfff");

String sql1="update test set content=? where id=2";

PreparedStatement pstmt=con.prepareStatement(sql1);

pstmt.setClob(1,clob);

pstmt.executeUpdate();

pstmt.close();

}

//con.commit();

rss.close();

rss2.close();

pstmt1.close();

rs.close();

stmt.close();

con.close();

System.out.println("-------------insert ok-------------");

}catch(Exception e){

System.out.println("insert:"+e);

}

System.out.println("-------------------query

-----------------");

try{

String content="";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection

con=DriverManager.getConnection("jdbc:oracle:thin:@fangm:1521:LICSFC","SFC","SFC");

Statement stmt=con.createStatement();

String sql="select content from test where id=1";

ResultSet rs=stmt.executeQuery(sql);

if(rs.next()){

CLOB clob = ((OracleResultSet)rs).getCLOB(1);

if(clob!=null){

Reader is=clob.getCharacterStream();

BufferedReader br=new BufferedReader(is);

String s=br.readLine();

while(s!=null){

content+=s+",";

s=br.readLine();

}

}

}

rs.close();

stmt.close();

con.close();

System.out.println("clob:"+content);

System.out.println("-------------query ok-------------");

}catch(Exception ee){

System.out.println("query:"+ee);

}

}

}