java读取oracle中Clob和Blob
来源:互联网 发布:下载教育平台软件 编辑:程序博客网 时间:2024/04/30 00:03
//读取clob字段
public static String readCLOB() {
String sql = "select nr from table1 where id='1'";
String content = "";
try {
PreparedStatement ps1 = connection.prepareStatement(sql);
ResultSet rs1 = ps1.executeQuery();
while (rs1.next()) {
oracle.sql.CLOB clob = (oracle.sql.CLOB) rs1.getClob("1");
BufferedReader in = new BufferedReader(clob.getCharacterStream());
StringWriter out = new StringWriter();
int c;
while ((c = in.read()) != -1) {
out.write(c);
}
content = out.toString();// CLOB内容
}
} catch (Exception e) {
e.printStackTrace();
}
return content;
}
//读取blob字段
public static String readBLOB() {
String sql = "select nr from table1 where id='1'";
String content = "";
try {
PreparedStatement ps1 = connection.prepareStatement(sql);
ResultSet rs1 = ps1.executeQuery();
while (rs1.next()) {
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs1.getBlob("1");
OutputStream out = blob.getBinaryOutputStream();
byte[] b = new byte[(int)blob.length];
content = out.write(b);
out.flush();
out.close();
}
} catch (Exception e) {
e.printStackTrace();
}
return content;
}
- java读取oracle中Clob和Blob
- Oracle中Blob和Clob
- java 读取oracle的blob/clob
- Java中读取和写入Oracle(CLOB)
- JAVA操作Oracle中BLOB、CLOB
- oracle中blob和clob文件上传
- Oracle中Blob和Clob的作用
- Oracle中Blob和Clob的作用
- Oracle中Blob和Clob的作用?
- oracle中BLOB和CLOB的区别
- Oracle中 CLOB, BLOB和NLOB
- Oracle中JDBC对BLOB和CLOB读取的专用处理和通用处理
- Oracle中JDBC对BLOB和CLOB读取的专用处理和通用处理
- Oracle中Clob与Blob字段的读取
- Oracle中Clob与Blob字段的读取
- Oracle中Clob与Blob字段的读取
- java 读取Oracle的clob,blob转换为字符串
- dwr+oracle进行clob、blob字段插入、修改和读取
- UVa 706 Problem: LC-Display (PC 110104)
- 巧排扑克牌
- 直播系统使用说明
- VIM常用操作
- Leetcode: Triangle
- java读取oracle中Clob和Blob
- 教育类开源项目大汇集
- 要安排:3个A国人,3个B国人,3个C国人坐成一排,要求不能使连续的3个人是同一个国籍.求所有不同方案的总数?
- 手机刷机
- C#单纯的字母数字ASCII码转换
- 利用merge优化
- struts.xml异常配置
- Palindrome Partitioning II
- LeetCode Minimum Window Substring