把图片从oracle数据库的blob字段中取出来，存在硬盘上

最新推荐文章于 2021-04-10 16:30:09 发布

limon758

最新推荐文章于 2021-04-10 16:30:09 发布

阅读量428

点赞数

分类专栏： java 文章标签： Oracle SQL Java JDBC Swing

本文链接：https://blog.csdn.net/heisetoufa/article/details/83265326

版权

java 专栏收录该内容

159 篇文章 0 订阅

订阅专栏

import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JFileChooser;

import oracle.jdbc.driver.OracleConnection;

public class Read 
{
 public static void main(String[] args)
 {
  try {
   Read rfdb = new Read ();
   rfdb.readFromDB();
  } catch (SQLException e) {
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
 }
 Connection conn;
 Statement stmt;
 
 ResultSet rs;
 int bufferSize;
 
 public Read ()throws SQLException, ClassNotFoundException 
 {
  String connectString;
  Class.forName("oracle.jdbc.driver.OracleDriver");
  connectString = "jdbc:oracle:thin:@192.168.1.134:1521:zhpt";
  conn = (OracleConnection)
  DriverManager.getConnection(connectString, "dzjc","dzjc");
  stmt = conn.createStatement();
 }
 
 public void readFromDB() 
 {
  String pathname, name;
  int amount = 0;
  InputStream in = null;
  BufferedOutputStream out = null;
 
  JFileChooser chooser = new JFileChooser();
  int returnVal = chooser.showOpenDialog(null);
  if (returnVal == JFileChooser.APPROVE_OPTION) 
  {
   pathname = chooser.getSelectedFile().getAbsolutePath();
   name = chooser.getSelectedFile().getName();
   chooser = null;
  }
  else 
  {
   System.out.println("没有找到文件！");
   System.out.println("程序非正常结束...");
   return;
  }
  try 
  {
   rs = stmt.executeQuery("select img from dzjc_img");
   if (rs.next()) 
   {
    Blob blob = rs.getBlob(1);
    in = blob.getBinaryStream();
    bufferSize = ( (oracle.sql.BLOB) blob).getBufferSize();
 
    out = new BufferedOutputStream(new FileOutputStream(pathname),(int) bufferSize);
    
    byte[] b = new byte[ (int) bufferSize];
    int count = in.read(b, 0, (int) bufferSize);
 
    while (count != -1) 
    {
     out.write(b, 0, count);
     amount += count;
     System.out.println("已经处理了" + amount + "字节.");
     count = in.read(b, 0, (int) bufferSize);
    }
    System.out.println("成功处理完毕字节数:" + amount);
    out.close();
    out = null;
    in.close();
    in = null;
   }
   else 
   {
    System.out.println("文档:" + name + "未找到.");
   }
  }
  catch (Exception e) 
  {
   e.printStackTrace();
  }
  finally 
  {
   if (out != null) 
   {
    try 
    {
     out.close();
    }
    catch (Exception ignored) {}
   }
   if (in != null) 
   {
    try 
    {
     in.close();
    }
    catch (Exception ignored) {}
   }
  }
 }
}

上篇文章是从硬盘上存到数据库里，这次来个存到数据库里再取出来的存到硬盘上的类，还有一个是，下篇文章再发一个从数据库里取出来再显示在浏览器上的

贴代码先

import java.io.BufferedOutputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JFileChooser;

import oracle.jdbc.driver.OracleConnection;

public class Read 
{
 public static void main(String[] args)
 {
  try {
   Read rfdb = new Read ();
   rfdb.readFromDB();
  } catch (SQLException e) {
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  }
 }
 Connection conn;
 Statement stmt;
 
 ResultSet rs;
 int bufferSize;
 
 public Read ()throws SQLException, ClassNotFoundException 
 {
  String connectString;
  Class.forName("oracle.jdbc.driver.OracleDriver");
  connectString = "jdbc:oracle:thin:@192.168.1.134:1521:zhpt";
  conn = (OracleConnection)
  DriverManager.getConnection(connectString, "dzjc","dzjc");
  stmt = conn.createStatement();
 }
 
 public void readFromDB() 
 {
  String pathname, name;
  int amount = 0;
  InputStream in = null;
  BufferedOutputStream out = null;
 
  JFileChooser chooser = new JFileChooser();
  int returnVal = chooser.showOpenDialog(null);
  if (returnVal == JFileChooser.APPROVE_OPTION) 
  {
   pathname = chooser.getSelectedFile().getAbsolutePath();
   name = chooser.getSelectedFile().getName();
   chooser = null;
  }
  else 
  {
   System.out.println("没有找到文件！");
   System.out.println("程序非正常结束...");
   return;
  }
  try 
  {
   rs = stmt.executeQuery("select img from dzjc_img");
   if (rs.next()) 
   {
    Blob blob = rs.getBlob(1);
    in = blob.getBinaryStream();
    bufferSize = ( (oracle.sql.BLOB) blob).getBufferSize();
 
    out = new BufferedOutputStream(new FileOutputStream(pathname),(int) bufferSize);
    
    byte[] b = new byte[ (int) bufferSize];
    int count = in.read(b, 0, (int) bufferSize);
 
    while (count != -1) 
    {
     out.write(b, 0, count);
     amount += count;
     System.out.println("已经处理了" + amount + "字节.");
     count = in.read(b, 0, (int) bufferSize);
    }
    System.out.println("成功处理完毕字节数:" + amount);
    out.close();
    out = null;
    in.close();
    in = null;
   }
   else 
   {
    System.out.println("文档:" + name + "未找到.");
   }
  }
  catch (Exception e) 
  {
   e.printStackTrace();
  }
  finally 
  {
   if (out != null) 
   {
    try 
    {
     out.close();
    }
    catch (Exception ignored) {}
   }
   if (in != null) 
   {
    try 
    {
     in.close();
    }
    catch (Exception ignored) {}
   }
  }
 }
}

要保证数据库里有图片，打开的对话框显示为打开而不是保存，没关系，自己找个地方，输个文件名，一点打开，图片就会被保存在那个位置了

黑色头发 http://heisetoufa.iteye.com