Jdbc-mysql二进制blob类型读写

package org.util;import java.io.BufferedInputStream;import java.io.BufferedOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.InputStreamReader;import java.io.OutputStream;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class BlobTest {/** * @param args * @throws SQLException * @throws IOException */public static void main(String[] args) throws SQLException, IOException {// TODO Auto-generated method stub//create();read(2);}//将二进制流存储入数据库blob字段类型。public static void create() throws SQLException, IOException{String sql = "insert into blob_test values(id,?)";Connection conn = null;PreparedStatement ps = null;try{conn = JdbcUtil.getInstance().getConnection();ps = conn.prepareStatement(sql);File file = new File("input_text_right.gif");BufferedInputStream in = new BufferedInputStream(new FileInputStream(file));ps.setBlob(1, in);int id = ps.executeUpdate();System.out.println("id:"+id);in.close();}finally{JdbcUtil.free(null, ps, conn);}}//读取二进制流，并写入新的文件public static void read(int id) throws SQLException, IOException{String sql = "select big_bit from blob_test where id=? limit 1";Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try{conn = JdbcUtil.getInstance().getConnection();ps = conn.prepareStatement(sql);ps.setInt(1, id);rs = ps.executeQuery();byte[] b = new byte[1024];while(rs.next()){InputStream in = rs.getBinaryStream(1);//InputStream是字节输入流的所有类的超类File file = new File("left.gif");BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(file));//BufferedOutputStream是缓冲的输出流for(int i=0; (i=in.read(b))>0;){//read方法接收byte数组，并将数据存储在缓冲数组b中out.write(b);//将指定的字节写入此缓冲的输出流。}out.close();//关闭此输出流并释放与此流有关的所有系统资源。}}finally{JdbcUtil.free(rs, ps, conn);}}}