Java 存储和读取 oracle CLOB 类型字段

packageoracle.clob;
importjava.io.BufferedReader;
importjava.io.File;
importjava.io.FileReader;
importjava.io.IOException;
importjava.io.Reader;
importjava.io.StringReader;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importoracle.jdbc.driver.OracleDriver;
importoracle.sql.CLOB;
publicclassClobTest{
Stringurl="jdbc:oracle:thin:@192.168.2.157:1521:orcl";
Stringuser="xj";
Stringpwd="xj";
Stringtext="这是要插入到CLOB里面的数据";
privatevoidclobImport()throwsClassNotFoundException,SQLException{
//TODOAuto-generatedmethodstub
DriverManager.registerDriver(newOracleDriver());
Connectionconn=DriverManager.getConnection(url,user,pwd);//得到连接对象
Stringsql="insertintoclob_test(id,str)values('1',?)";//要执行的SQL语句
PreparedStatementstmt=conn.prepareStatement(sql);//加载SQL语句
//PreparedStatement支持SQL带有问号？，可以动态替换？的内容。
ReaderclobReader=newStringReader(text);//将text转成流形式
stmt.setCharacterStream(1,clobReader,text.length());//替换sql语句中的？
intnum=stmt.executeUpdate();//执行SQL
if(num>0){
System.out.println("ok");
}else{
System.out.println("NO");
}
stmt.close();
conn.close();
}
privatevoidclobExport()throwsClassNotFoundException,SQLException,
IOException{
//TODOAuto-generatedmethodstub
CLOBclob=null;
Stringsql="select*fromclob_testwhereid=1";
DriverManager.registerDriver(newOracleDriver());
Connectionconn=DriverManager.getConnection(url,user,pwd);//得到连接对象
PreparedStatementstmt=conn.prepareStatement(sql);
ResultSetrs=stmt.executeQuery();
Stringid="";
Stringcontent="";
if(rs.next()){
id=rs.getString("id");//获得ID
clob=(oracle.sql.CLOB)rs.getClob("str");//获得CLOB字段str
//注释：用rs.getString("str")无法得到数据，返回的是NULL;
content=ClobToString(clob);
}
stmt.close();
conn.close();
//输出结果
System.out.println(id);
System.out.println(content);
}
//将字CLOB转成STRING类型
publicStringClobToString(CLOBclob)throwsSQLException,IOException{
StringreString="";
Readeris=clob.getCharacterStream();//得到流
BufferedReaderbr=newBufferedReader(is);
Strings=br.readLine();
StringBuffersb=newStringBuffer();
while(s!=null){//执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
sb.append(s);
s=br.readLine();
}
reString=sb.toString();
returnreString;
}
//TODOAuto-generatedmethodstub
publicstaticvoidmain(String[]args)throwsIOException,
ClassNotFoundException,SQLException{
//TODOAuto-generatedmethodstub
ClobTestclobtest=newClobTest();
//readfile
FileReader_frd=newFileReader(newFile("D://DOS.txt"));
BufferedReader_brd=newBufferedReader(_frd);
String_rs=_brd.readLine();
StringBuffer_input=newStringBuffer();
while(_rs!=null){
_input.append(_rs);
_rs=_brd.readLine();
}
//System.out.println(_input.toString());
//输入测试
clobtest.text=_input.toString();
clobtest.clobImport();
//输出测试
//clobtest.clobExport();
}
}

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.csdn.net/foamflower/article/details/4497764 优质内容筛选与推荐>>
1、MYSQL整理的语法
2、高速网络环境下的网络带宽测试
3、iframe自适应，跨域，JS的document.domain
4、创新的实现举例 [ 光影人像东海陈光剑的博客 ]
5、最长上升子序列(LIS)

0 │ 收藏 │ 举报

朋友将在看一看看到

分享想法到看一看