如何读写Oracle数据库Blog字段(Java)
来源:互联网 发布:淘宝买家级别 编辑:程序博客网 时间:2024/05/02 17:19
数据库表结构
CREATE TABLE LM_DATA_KEY
(
KEY BLOB,
ID NUMBER
)
1. 如何写入KEY字段 :
//Remove old record with id=1
PreparedStatement pstmt = conn.prepareStatement("delete from lm_data_key where id=1");
pstmt.executeUpdate();
//Insert empty blob field
pstmt = conn.prepareStatement("insert into lm_data_key (key, id) values(empty_Blob(), 1)");
pstmt.executeUpdate();
//Update blob field
pstmt = conn.prepareStatement("select key from lm_data_key where id=1 for update");
rs = pstmt.executeQuery();
rs.next();
java.sql.Blob es_Blob = rs.getBlob(1);
if (null != es_Blob) ...{
OutputStream outstream = ( (oracle.sql.BLOB) es_Blob).getBinaryOutputStream();
ObjectOutputStream oos = new java.io.ObjectOutputStream(outstream);
ArrayList b = new ArrayList();
b.add(new String("11111111"));
Object parameter = b;
oos.writeObject(parameter);
oos.flush();
oos.close();
}
else ...{
System.out.println(" is null:");
}
pstmt.close();
conn.commit();
conn.setAutoCommit(false);
PreparedStatement pstmt = conn.prepareStatement("delete from lm_data_key where id=1");
pstmt.executeUpdate();
//Insert empty blob field
pstmt = conn.prepareStatement("insert into lm_data_key (key, id) values(empty_Blob(), 1)");
pstmt.executeUpdate();
//Update blob field
pstmt = conn.prepareStatement("select key from lm_data_key where id=1 for update");
rs = pstmt.executeQuery();
rs.next();
java.sql.Blob es_Blob = rs.getBlob(1);
if (null != es_Blob) ...{
OutputStream outstream = ( (oracle.sql.BLOB) es_Blob).getBinaryOutputStream();
ObjectOutputStream oos = new java.io.ObjectOutputStream(outstream);
ArrayList b = new ArrayList();
b.add(new String("11111111"));
Object parameter = b;
oos.writeObject(parameter);
oos.flush();
oos.close();
}
else ...{
System.out.println(" is null:");
}
pstmt.close();
conn.commit();
conn.setAutoCommit(false);
2. 如何读出KEY字段:
pstmt = conn.prepareStatement(sqlString);
rs = pstmt.executeQuery();
rs.next();
Blob blob = rs.getBlob(1);
InputStream instream = ( (Blob) blob).getBinaryStream();
java.io.ObjectInputStream ois = new java.io.ObjectInputStream(instream);
Object parameter = ois.readObject();
ois.close();
ArrayList tarray = (ArrayList)parameter;
System.out.println(tarray.get(0).toString());
conn.commit();
conn.setAutoCommit(false);
rs = pstmt.executeQuery();
rs.next();
Blob blob = rs.getBlob(1);
InputStream instream = ( (Blob) blob).getBinaryStream();
java.io.ObjectInputStream ois = new java.io.ObjectInputStream(instream);
Object parameter = ois.readObject();
ois.close();
ArrayList tarray = (ArrayList)parameter;
System.out.println(tarray.get(0).toString());
conn.commit();
conn.setAutoCommit(false);
注:以上用的是java.io.ObjectInputStream来读写ArrayList对象的.
- 如何读写Oracle数据库Blog字段(Java)
- java读写Oracle Blob字段
- Oracle数据库Date类型字段读写经验
- JAVA读写Oracle中blob字段
- 读写数据库图象字段
- JAVA处理Oracle数据库CLOB读写操作
- JAVA读取Oracle数据库BLOB字段
- java操作oracle数据库中的blob字段
- Java 操作Oracle数据库Clob字段
- JAVA读取Oracle数据库BLOB字段
- java读取oracle数据库中blob字段
- Java Oracle数据库BLOB字段的存取
- java 文件写入oracle数据库blob字段
- 读取oracle中blog字段
- 下载图片(数据库BLOG字段)
- 读写Oracle CLOB字段实例
- oracle lob clob字段读写
- 读写SQL数据库Image字段
- 虚拟函数、多继承、虚基类和RTTI需要的代价
- Schema 介绍
- C#.NET快速排序算法
- 打破陈规 用浏览器遥控Win2003
- Windows CE下如何调用控制面板中的对话框
- 如何读写Oracle数据库Blog字段(Java)
- WMLScript 介绍
- WMLScript How to
- WML Dialogs
- WML Float
- 软件许可协议
- WML Lang
- gsm基本概念
- WML String