JAVA处理CLOB字段

以前在网上找了很多关于在ORACLE中吃萝卜的资料，可都不能用，花了两天时间研究，终于都执行成功了，以下是INSERT与UPDATE操作的代码，贴上来分享一下：

注意前面有步操作,在ORACLE中执行以下命令，用于关闭对特别符号的处理，我插入的CLOB字段有￥％符号等，有的是ORACLE里的专用的符号，会有些冲突：SET DEFINED OFF

插入操作：

package com.beyond.boeshop.app.floor.api;

import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.CLOB;

public class InsertTest implements Serializable{
public static void main(String[] args)
{
String id = "100221";
String sb="<div id="footWrap"></table>
</div>
<br />";
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.33:1521:cloudsea","cloudsea","cloudsea");
con.setAutoCommit(false);

Statement stmt=con.createStatement();

String sql="insert into test_ (id, content,value) values(" + id + ",empty_clob(),'12123')";
stmt.execute(sql);
String sqll="select content from test_ where id=" + id + " for update ";
ResultSet rss=stmt.executeQuery(sqll);
if(rss.next()){
CLOB clob = ((OracleResultSet)rss).getCLOB(1);
java.io.Writer ww = clob.getCharacterOutputStream();
ww.write(sb);
ww.close();
sql="update test_ set content=? where id=" + id;
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setClob(1,clob);
pstmt.executeUpdate();
pstmt.close();
}
con.commit();
if(true) return;

}catch(Exception e){
 e.printStackTrace();
 }
}
}
修改操作：

package com.beyond.boeshop.app.floor.api;

import java.sql.*;
import java.io.*;
import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.CLOB;

public class UpdateTest implements Serializable{
public static void main(String[] args)
{
String id = "100221";
String sb="121212&    </tr>
    </tbody>
</table>
</div>
<br />";
try{
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.33:1521:cloudsea","cloudsea","cloudsea");
con.setAutoCommit(false);

Statement stmt=con.createStatement();

String sql="update test_  set  content=empty_clob() ,value='12123' where id="+id;
stmt.execute(sql);
String sqll="select content from test_ where id=" + id + " for update ";
ResultSet rss=stmt.executeQuery(sqll);
if(rss.next()){
CLOB clob = ((OracleResultSet)rss).getCLOB(1);
java.io.Writer ww = clob.getCharacterOutputStream();
ww.write(sb);
ww.close();
sql="update test_ set content=? where id=" + id;
PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setClob(1,clob);
pstmt.executeUpdate();
pstmt.close();
}
con.commit();
if(true) return;

}catch(Exception e){
 e.printStackTrace();
 }
}
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21158541/viewspace-627015/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21158541/viewspace-627015/