http://www.csdn.net/Expert/TopicView1.asp?id=582553
解决方案 »
- 急求答案!!
- 为什么List.toArray()之后不能转换类型?
- 请问怎么用JAVA在aix环境中创建一个文本文件?( 急!!!)
- 给个对线程过多的处理例子,在线等!
- 请教高手:有没有java类支持直接解析.tar.gz文件的类,(就像java里的zip和jar类那样不用解压直接解析的)
- 哪里下载 lowagie 包?
- 工厂模式 哪儿有误?
- 急!急!急!急!急!急!急!关于ant一个属性怎么也解决不了,关于java编译的属性,在线等待!!
- 我用JBulider6的DataBase和QueryDataSet连接SQL数据库,测试连接都能成功,但在执行添加、修改等操作是便提示错误!
- 关于cloudscape数据库的问题
- 高手推荐一下java开发web services和soap,uddi的书籍或者资料!
- 招聘启事
<%@page import="java.sql.*"%>
<%@page import="oracle.sql.CLOB"%>
<%@page import="oracle.jdbc.OracleStatement"%>
<%@page import="oracle.jdbc.OracleResultSet"%>
<%@page import="java.io.*"%>
<%@page import="oracle.jdbc.OraclePreparedStatement"%><%@ page contentType="text/html; charset=GB2312" %>
Clob updata<br>
*********************************************************<br>
<%
String url = "jdbc:oracle:thin:@133.166.200.235:1521:orajp";
String username = "asset";
String password = "asset"; try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection(url, username, password);
con.setAutoCommit(false); DatabaseMetaData dma = con.getMetaData(); OraclePreparedStatement stmt = null;
String sql = null; sql = "select ccc from testclob where id = 1 for update";
stmt = (OraclePreparedStatement)con.prepareStatement(sql);
ResultSet rs = stmt.executeQuery(sql);
rs.next();
oracle.sql.CLOB clob = (oracle.sql.CLOB)((oracle.jdbc.OracleResultSet)rs).getCLOB("ccc");
clob = clob.empty_lob();
stmt.setCLOB(1,clob);
stmt.executeUpdate(); sql = "select ccc from testclob where id = 1 for update";
stmt = (OraclePreparedStatement)con.prepareStatement(sql);
rs = stmt.executeQuery(sql);
rs.next();
clob = (oracle.sql.CLOB)((oracle.jdbc.OracleResultSet)rs).getCLOB("ccc");
java.io.Writer clobWriter = clob.getCharacterOutputStream(); Reader reader = new FileReader(new File("c:\\aa.txt"));
Writer rr = new FileWriter(new File("c:\\cc.txt"));
char[] temp = new char[1];
while (reader.read(temp) != -1) {
clobWriter.write(temp);
rr.write(temp);
} rr.flush();
rr.close(); clobWriter.flush();
clobWriter.close();
rs.close();
stmt.setCLOB(1,clob);
stmt.close();
con.commit();
con.close();
}
catch (SQLException ex)
{
while (ex != null)
{
System.out.println ("SQLState: " + ex.getSQLState());
System.out.println ("Message: " + ex.getMessage());
System.out.println ("Vendor: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch (java.lang.Exception ex)
{
ex.printStackTrace();
}
%>