如何向DB2中存储和读取图片

最新推荐文章于 2021-02-06 17:00:26 发布

转载最新推荐文章于 2021-02-06 17:00:26 发布 · 1.8k 阅读

文章标签：

#db2 #存储 #string #exception #import #jdbc

数据库同时被 2 个专栏收录

7 篇文章

订阅专栏

JAVA

4 篇文章

订阅专栏

本文提供了一个使用Java进行DB2数据库操作的例子，包括创建表、插入图片到数据库及从数据库读取图片并保存为文件的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://hi.baidu.com/aguiro/blog/item/3aba991e2249c619413417b6.html

//Create.java文件,jdbc连接DB2

import java.sql.*;

public class Create
{
public static void main(String[] args)
{
    Connection con;
    Statement st;
    try
{
      Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
      String url = "jdbc:db2:sample;";
      con = DriverManager.getConnection(url, "mike", "luanxp");
      st = con.createStatement();

      st.execute("CREATE TABLE TEST.mytable(id integer, picname varchar(50), pic BLOB) in test;");
      st.close();
      con.close();
    }
catch(Exception e)
{
      e.printStackTrace();
    }
}
}

// SavePic.java 将图片保存至数据库
import java.sql.*;
import java.io.*;

public class SavePic
{
public static void main(String[] args)
{
    Connection con;
    PreparedStatement st;

    try
{
      Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
      String url = "jdbc:db2:sample;";
      con = DriverManager.getConnection(url, "mike", "luanxp");

      String sql = "INSERT INTO test.mytable(id,picname, pic) values(1,'Imissyou',?)";
      st = con.prepareStatement(sql);
      File f = new File("D:/temp/testpic/Imissyou.jpg");
      FileInputStream fis = new FileInputStream(f);
      st.setBinaryStream(1, fis, (int)f.length());
      st.executeUpdate();
      st.close();
      con.close();
    }
catch(Exception e)
{
      e.printStackTrace();
    }
}
}

//ReadPic.java 从数据库中读出图片存成文件
import java.sql.*;
import java.io.*;

public class ReadPic
{

public static void main(String[] args)
{
    Connection con;
    Statement st;

    try
    {
      Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
      String url = "jdbc:db2:sample;";
      con = DriverManager.getConnection(url, "mike", "luanxp");
      String sql = "SELECT pic FROM test.mytable WHERE picname='Imissyou'";
      st = con.createStatement();
      ResultSet rs = st.executeQuery(sql);
      rs.next();
//      File f = new File("D:/temp/testpic/bak.jpg");
   File f = new File("D:/temp/testpic/bak.txt");
      FileOutputStream fos = new FileOutputStream(f);
      InputStream is = rs.getBinaryStream("pic");
      int c;
      byte b[] = new byte[4*1024];
      while ((c=is.read(b))!=-1)
   {
        fos.write(b, 0, c);
      }
      fos.flush();
      is.close();
      st.close();
      con.close();
    }
catch(Exception e)
{
      e.printStackTrace();
    }
}
}