blob字段java如何处理_Java对Oracle里Blob字段的处理

比较简单，直接贴代码吧，有问题留言

/**

* Usage:Oracle Blob Field

*

* FileName   : Blob.java

* PackageName: org.ahpo.db

* Author     : Ahpo Yang

* CreateDate : 2006-4-24 14:54:04

*/

package org.ahpo.db;

import java.io.ByteArrayInputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.IOException;

import java.io.ObjectInputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class JBlob {

String tableName = null; // 表名

String primaryKey = null; // 表的主键名

String primaryValue = null; // 表的主键值

String fieldName = null; // 表的CLOB字段名

String clobValue = null; // 表的CLOB字段值

Connection conn = null; // 与oracle的连接

/**

*

* 用于测试用

*

*/

public static void main(String[] args) {

try {

JBlob jb = new JBlob(getConnection(), "aa", "a", "aaaa", "c", "ccc");

jb.writeBlob();

jb.readBlob();

} catch (Exception e) {

System.out.println(e);

e.printStackTrace();

}

}

/**

*

* 构造方法

*

*/

public JBlob(Connection connection, String tableName, String primaryKey,

String primaryValue, String fieldName, String clobValue) {

this.conn = connection;

this.tableName = tableName;

this.primaryKey = primaryKey;

this.primaryValue = primaryValue;

this.fieldName = fieldName;

this.clobValue = clobValue;

}

/**

*

* 构造方法，但不必传clobValue值 一般构造出的实例用来读Clob字段

*

*/

public JBlob(Connection connection, String tableName, String primaryKey,

String primaryValue, String fieldName) {

this.conn = connection;

this.tableName = tableName;

this.primaryKey = primaryKey;

this.primaryValue = primaryValue;

this.fieldName = fieldName;

}

/**

* 读取Blob字段

*

* @return

* @throws SQLException

* @throws IOException

*/

public String readBlob() throws SQLException, IOException {

String strRet = "";

Statement stmt = null;

ResultSet rs = null;

try {

String strSql = "select " + fieldName + " from " + tableName

+ " where " + primaryKey + "=" + primaryValue;

conn = getConnection();

stmt = conn.createStatement();

rs = stmt.executeQuery(strSql);

byte b[] = null; // 保存从BLOB读出的字节

if (rs.next()) {

// System.out.println("ahpo = == 数据存在");

java.sql.Blob blob = (java.sql.Blob) rs.getBlob(1);

int filesize = (int) blob.length();

b = blob.getBytes(1, filesize); // 从BLOB取出字节流数据

ByteArrayInputStream bi = new ByteArrayInputStream(b);

ObjectInputStream q = new ObjectInputStream(bi);

try {

strRet = (String) q.readObject();

} catch (ClassNotFoundException ex) {

} catch (IOException ex) {

}

bi.close();

q.close();

}

} catch (SQLException e) {

throw e;

} catch (Exception e) {

// System.out.println("ahpo===异常出现");

// 异常处理

try {

conn.rollback();

} catch (Exception ex) {

ex.printStackTrace();

}

e.printStackTrace();

} finally {

// 释放连接

if (rs != null) {

try {

rs.close();

} catch (Exception ex) {

}

}

if (stmt != null) {

try {

stmt.close();

} catch (Exception ex) {

}

}

if (conn != null) {

try {

conn.close();

} catch (Exception ex) {

}

}

}

return strRet;

}

public void writeBlob() throws SQLException, IOException {

// open a file, put the content of file into a bytes array

try {

File files = new File("d://rssxml//sample.xml");

FileInputStream fis = new FileInputStream(files);

byte[] fl = new byte[(int) files.length()];

fis.read(fl);

// use this bytes array to construct a InputStream

ByteArrayInputStream kk = new ByteArrayInputStream(fl);

// connect the oracle database

if (conn == null) {

conn = getConnection();

}

PreparedStatement ps = conn.prepareStatement("INSERT INTO "

+ tableName + "(" + fieldName + ") values (?) where "

+ primaryKey + "=" + primaryValue);

// set parameters

ps.setBinaryStream(1, kk, (int) files.length());

// execute

ps.executeUpdate();

fis.close();

ps.close();

} catch (IOException e) {

throw e;

} catch (SQLException e) {

throw e;

} catch (Exception e) {

e.printStackTrace();

}

}

/**  * 取得数据库连接  *   * @return  * @throws SQLException  * @throws ClassNotFoundException  */ public static Connection getConnection() throws SQLException,   ClassNotFoundException {  Class.forName("oracle.jdbc.OracleDriver");  Connection conn = DriverManager.getConnection(    "jdbc:oracle:thin:@192.168.1.18:1521:portal", "portal",    "portal");  return conn; }}