How do I read and insert BLOBs data from database?

本文提供了一个Java程序示例,展示了如何使用JDBC插入和查询数据库中的BLOB类型数据,包括图片文件的读取与写入。

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

Only for reference.

 

import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.*;

public class TestOperBlob {
    private static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    private static String username = "test";
    private static String password = "test";
    
    public void queryBlob(){
      try{
          conn = getConnection();
          conn.setAutoCommit(false);

          String sql = "INSERT INTO pictures (name, description, image) VALUES (?, ?, ?)";
          PreparedStatement stmt = conn.prepareStatement(sql);
          stmt.setString(1, "java.gif");
          stmt.setString(2, "Java Official Logo");

          File image = new File("D:\\Projects\\kodejava\\web\\images\\java.gif");
          fis = new FileInputStream(image);
          stmt.setBinaryStream(3, fis, (int) image.length());
          stmt.execute();

          conn.commit();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            closeConnection(conn);
        }
    }

    public void insertBlob(){
      Connection conn = null;
      try {
            conn = getConnection();

            String sql = "SELECT name, description, image FROM pictures ";
            PreparedStatement stmt = conn.prepareStatement(sql);
            ResultSet resultSet = stmt.executeQuery();
            while (resultSet.next()) {
                String name = resultSet.getString(1);
                System.out.println("Name        = " + name);
                String description = resultSet.getString(2);
                System.out.println("Description = " + description);

                File image = new File("D:\\java.gif");
                FileOutputStream fos = new FileOutputStream(image);

                byte[] buffer = new byte[256];
                // Get the binary stream of our BLOB data
                InputStream is = resultSet.getBinaryStream(3);
                while (is.read(buffer) > 0) {
                    fos.write(buffer);
                }

                fos.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (fis != null) {
                fis.close();
            }
            closeConnection(conn);
        }
    }
    
    private static Connection getConnection() throws Exception {    
        Connection connection = null;    
        Class.forName("com.mysql.jdbc.Driver");    
        connection = DriverManager.getConnection(url, username, password);
        return connection;    
    }    
        
    private static void closeConnection(Connection connection) throws SQLException {    
        if (connection != null && !connection.isClosed()) {             
            connection.close();    
        }    
    }
    
    public static void main(String[] args) throws Exception {
        queryBlob();
        insertBlob();
    }
}

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值