最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
weblogic下写clob的方法
时间:2022-07-02 18:17:21 编辑:袖梨 来源:一聚教程网
写CLOB的代码片段:
String SqlStr = "update TextInfo set Content=empty_clob() where TextInfoKey=" + Integer.toString(textinfokey);
myConn.setAutoCommit(false);
java.sql.PreparedStatement pstmt = myConn.prepareStatement(SqlStr);
pstmt.executeUpdate();
SqlStr = "select Content from TextInfo where TextInfoKey=" + Integer.toString(textinfokey) + " for update";
java.sql.Statement st = myConn.createStatement();
java.sql.ResultSet rs = st.executeQuery(SqlStr);
java.sql.Clob clob ;
if (rs.next()) {
clob = rs.getClob("Content");
weblogic.jdbc.rmi.SerialOracleClob cast1 =(weblogic.jdbc.rmi.SerialOracleClob)clob;
weblogic.jdbc.rmi.internal.OracleTClobImpl cast2 =(weblogic.jdbc.rmi.internal.OracleTClobImpl)cast1.getTheRealClob();
CLOB myClob = (oracle.sql.CLOB)cast2.getTheRealClob();
java.io.Writer out=myClob.getCharacterOutputStream();
out.write(content);
out.flush();
out.close();
}
String SqlStr = "update TextInfo set Content=empty_clob() where TextInfoKey=" + Integer.toString(textinfokey);
myConn.setAutoCommit(false);
java.sql.PreparedStatement pstmt = myConn.prepareStatement(SqlStr);
pstmt.executeUpdate();
SqlStr = "select Content from TextInfo where TextInfoKey=" + Integer.toString(textinfokey) + " for update";
java.sql.Statement st = myConn.createStatement();
java.sql.ResultSet rs = st.executeQuery(SqlStr);
java.sql.Clob clob ;
if (rs.next()) {
clob = rs.getClob("Content");
weblogic.jdbc.rmi.SerialOracleClob cast1 =(weblogic.jdbc.rmi.SerialOracleClob)clob;
weblogic.jdbc.rmi.internal.OracleTClobImpl cast2 =(weblogic.jdbc.rmi.internal.OracleTClobImpl)cast1.getTheRealClob();
CLOB myClob = (oracle.sql.CLOB)cast2.getTheRealClob();
java.io.Writer out=myClob.getCharacterOutputStream();
out.write(content);
out.flush();
out.close();
}
相关文章
- 网红张雪峰死亡为何霸榜热搜,全平台哀悼?这个人是谁?干嘛的? 03-25
- 张雪峰猝死了真的假的?网传张雪峰猝死了是怎么回事? 03-25
- 张雪峰是干嘛的?张雪峰因为什么走红?心源猝紧该怎么急救? 03-25
- 张雪峰死亡原因揭秘:急速运动心源猝死 03-25
- 张雪峰今年多大呀?怎么会突然猝死了? 03-25
- 张雪峰死了真的假的?张雪峰死亡原因揭秘 03-25