注意前面有步操作,在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/