java 保存读取图片到oracle

最新推荐文章于 2024-07-01 07:31:37 发布

lmyuanhang

最新推荐文章于 2024-07-01 07:31:37 发布

阅读量7.1k

点赞数 1

分类专栏：数据库 Java web

本文链接：https://blog.csdn.net/lmyuanhang/article/details/38021161

版权

Java web 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

数据库

1 篇文章 0 订阅

订阅专栏

存入数据库

Connection conn = null;
  ResultSet rs = null;
  Statement stmt = null;
  DBConnectionManager connMgr = null;
  try
  {
   String insertsql = "insert into image (id,pic) values(18,empty_blob())";//首先插入一个空的Blob类型
   String updateSql="select fujiannr from T_ZT_MYZJ_MYCJ where id=18 for update";
   connMgr = DBConnectionManager.getInstance();
   conn = connMgr.getConnection();
   conn.setAutoCommit(false);
   OutputStream os = null;
   stmt=conn.createStatement();
   stmt.executeUpdate(insertsql);
   rs=stmt.executeQuery(updateSql);
   if (rs.next())
   {
    oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("fujiannr");
     os = blob.getBinaryOutputStream();
     InputStream is1= new FileInputStream("c:\\1.png");
     int i = 0;
     while ((i = is1.read()) != -1) {
      os.write(i);
     }
   }
    os.flush();
       os.close();

  }
  catch (Exception e)
  {
   e.printStackTrace();
  }
  finally {
   closeAll(rs, stmt,conn);
  }

//失放资源
  ClassLoader cl = this.getClass().getClassLoader();
  InputStream pro = cl.getResourceAsStream("\\config.properties");
  Properties dbProps = new Properties();
  try {
   dbProps.load(pro);
  } catch (Exception e) {
  }

String driverClasses = dbProps.getProperty("dbDriver");
connMgr.freeConnection(driverClasses, conn);

从数据库中读取图片

  Connection conn = null;
  ResultSet rs = null;
  Statement stmt = null;
  InputStream issgg = null;
  DBConnectionManager connMgr = null;
  byte bs[] = null;

  try
  {
   connMgr = DBConnectionManager.getInstance();
   conn = connMgr.getConnection();
   conn.setAutoCommit(false);

   stmt=conn.createStatement();
   String str = "select pic from image where id=18";
   rs=stmt.executeQuery(str);
   rs.next();
   Blob ob = null;
   ob=rs.getBlob(1);
   long size = ob.length();
   bs = ob.getBytes(1, (int)size);

   File file = new File("c:\\" + "image.png");
         if (!file.exists())
         {
             file.createNewFile(); // 如果文件不存在，则创建
         }
         FileOutputStream fos = new FileOutputStream(file);

         if (data.length > 0)
         {
             fos.write(bs, 0, bs.length);
         }
         else
         {
             //while ((size = in.read(bs)) != -1)
            // {
               /// fos.write(bs, 0, size);
            // }
            // in.close();
         }
         fos.close();
  }
  catch (Exception e)
  {
   e.printStackTrace();
  }
  finally {
   closeAll(rs, stmt,conn);
  }