http://expert.csdn.net/Expert/topic/1197/1197476.xml?temp=.9296686
解决方案 »
- oracle如何设置定时任务(job)?比如每天凌晨0点执行。谢谢
- sqlplus控制台显示乱码
- QQ空间评论表结构设计
- oracle 8.1.7 个人版
- 运行SQLLDR工具是不是必须安装ORACLE?
- 在windows 2003系统下安装了ms sql还能装oracle吗?
- 网络正常,但是数据库连接不上,并提示日志文件。
- Oracle如何授权给用户到具体的字段?
- http://otn.oracle.com/documentation里面的文章怎样才能看啊?
- 小白跪求,老板急要,如何在个人的一台计算机上利用Oracle和PL/SQL developer 处理数据(安装步骤)
- ora-01033 ORACLE initialization or shutdown in process
- 怪问题,请高手指点!
插入CLOB:String content=从TXT中读内容;
try{
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String query = "";
String key =""; Statement stmt = dbConn.createStatement ();
rs=stmt.executeQuery("SELECT MAX(CNAME) FROM T_CLOB");
if(rs.next()){
key = rs.getString(1);
if( key==null )
key="001";
else{
int intKey=Integer.valueOf(key).intValue();
intKey+=1;
key=Integer.toString(intKey);
}
}
dbConn.setAutoCommit(false);
query = "INSERT INTO T_CLOB(CNAME,OBJ) VALUES(?,empty_clob())";
java.sql.PreparedStatement Pstmt = dbConn.prepareStatement(query);
Pstmt.setString(1,key);
Pstmt.executeUpdate();
Pstmt = null;
query = "SELECT OBJ FROM T_CLOB WHERE CNAME =? FOR UPDATE";
Pstmt = dbConn.prepareStatement(query);
Pstmt.setString(1,key);
rs= Pstmt.executeQuery();
oracle.sql.CLOB clobtt = null;
if(rs.next()){
clobtt = (oracle.sql.CLOB)rs.getClob(1);
}
Writer wr = clobtt.getCharacterOutputStream();
wr.write(content);
wr.flush();
wr.close();
rs.close();
dbConn.commit();
}
catch(Exception e){
!@#$%^&*())*&^%$$##@#$%%^^ 哇
}
读CLOB:
try{
PreparedStatement ps = dbConn.prepareStatement("SELECT OBJ FROM T_CLOB WHERE CNAME=?");
ps.setString(1,"5");
ResultSet result = ps.executeQuery();
if(result.next()){
oracle.jdbc.driver.OracleResultSet ors =(oracle.jdbc.driver.OracleResultSet)result;
oracle.sql.CLOB clobtmp = (oracle.sql.CLOB) ors.getClob(1);
ors.close(); if(clobtmp==null || clobtmp.length()==0){
errTmp="CLOB IS NULL";
}
else{
buffer=clobtmp.getSubString((long)1,(int)clobtmp.length());
}
}
else{
errTmp="NO DATA!";
}
ps.close();
用socket 送buffer吧}
catch(Exception e){
哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇
}
使用pro*c或oci实现