java blob字段_java 存取blob字段

import   java.sql.*;

import   java.io.*;

import   java.util.*;

import   java.text.*;

import   java.lang.*;

import   com.ibm.db2.jcc.*;

import   COM.ibm.db2.jdbc.app.*;

public   class TESTBLOB {

//DB2插入blob字段数据

public void insertBlobData()

{

String   sDBDriver       =   "com.ibm.db2.jcc.DB2Driver";

String   sConnDataBase   =   "jdbc:db2://192.168.12.24:50000/TAXEXDB";

// String   sDBDriver       =   "COM.ibm.db2.jdbc.app.DB2Driver";

// String   sConnDataBase   =   "jdbc:db2:TAXEXDB";

String   sConnUser   =   "db2inst1";

String   sConnPassd   =   "passw0rd";

Connection   con;

Statement   stmt;

ResultSet   rs;

System.out.println("ok0");

try   {

Class.forName(sDBDriver);

System.out.println("ok1");

con   =   DriverManager.getConnection(sConnDataBase,   sConnUser,   sConnPassd);

System.out.println("ok2");

PreparedStatement preparedStatement =

con.prepareStatement(

"INSERT INTO test2(f1)"

+ " VALUES(?)");

System.out.println("ok3");

File imgFile = new File("c:\\s1.jpg");

InputStream inputStream = new FileInputStream(imgFile);

preparedStatement.setBinaryStream(1, inputStream,

(int) (imgFile.length()));

System.out.println("ok4");

preparedStatement.executeUpdate();

System.out.println("ok5");

preparedStatement.close();

con.close();

}

catch(Exception   e)   {

e.printStackTrace();

}

}

//取blob字段数据

public void getBlobData()

{

String   sDBDriver      =   "com.ibm.db2.jcc.DB2Driver";

String   sConnDataBase =   "jdbc:db2://192.168.12.24:50000/TAXEXDB";

// String   sDBDriver      =   "COM.ibm.db2.jdbc.app.DB2Driver";

// String   sConnDataBase =   "jdbc:db2:TAXEXDB";

String   sConnUser      =   "db2inst1";

String   sConnPassd     =   "passw0rd";

Connection con;

Statement   stmt;

ResultSet   rs;

System.out.println("ok0");

try   {

Class.forName(sDBDriver);

System.out.println("ok1");

con   =   DriverManager.getConnection(sConnDataBase,   sConnUser,   sConnPassd);

System.out.println("ok2");

PreparedStatement preparedStatement =

con.prepareStatement(

"SELECT f1 FROM test2");

ResultSet resultSet = preparedStatement.executeQuery();

while (resultSet.next()) {

Blob blob = resultSet.getBlob("f1");

InputStream inputStream = blob.getBinaryStream();

File fileOutput =

new File("c:\\news1.jpg");

FileOutputStream fo =

new FileOutputStream(fileOutput);

int c;

while ((c = inputStream.read()) != -1) {

fo.write(c);

}

fo.close();

}

}

catch(Exception   e)   {

e.printStackTrace();

}

}

public   static void   main(String[] args)   {

TESTBLOB test = new TESTBLOB();

test.insertBlobData();

test.getBlobData();

}

}