以Blob形式存取图片到Oracle

最新推荐文章于 2025-06-23 15:55:36 发布

JonyShan

最新推荐文章于 2025-06-23 15:55:36 发布

阅读量2.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： JDBC 数据库 java学习文章标签：二进制 oracle jdbc

本文链接：https://blog.youkuaiyun.com/qq_29631069/article/details/70236773

java学习同时被 3 个专栏收录

28 篇文章

订阅专栏

数据库

4 篇文章

订阅专栏

JDBC

0 篇文章

订阅专栏

本文介绍了如何使用Java程序实现图片文件在Oracle数据库中的存储与读取。包括创建Blob对象、写入图片到数据库以及从数据库读取图片并保存到指定路径。

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

将图片存入Oracle数据库

    public int writeBlob(String path,String id) throws SQLException, IOException{
        Connection conn = null;
        PreparedStatement ps =null;
        conn = getConnetion();
        int result = 0;
        String sql = "insert into man(id,picture) values(?,?)";
        conn = getConnetion();
        try {
            ps = conn.prepareStatement(sql);
            //1.����Blob
            Blob image = conn.createBlob();
            //2.��������blob
            OutputStream out = image.setBinaryStream(1);
            //3.��ȡͼƬ,��д�������
            FileInputStream fis = new FileInputStream(path);
            byte []buf = new byte[1024];
            int len = 0;
            while((len=fis.read(buf))!=-1){
                out.write(buf, 0, len);
            }
            ps.setObject(1,id);
            ps.setBlob(2,image);
            result = ps.executeUpdate();
            fis.close();
            out.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                if (ps != null) {
                    ps.close();
                }

                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                System.out.print("error close");
            }
        }

        return result;
    }

将图片从数据库中取出

    //从数据库中获取图片，path是保存路径
    //get picture from oracle
    public void downPicture(String id, String path){
        Connection conn = null;
        PreparedStatement ps =null;
        ResultSet rs = null;
        ResultSetMetaData rsmd = null;
        ArrayList<HashMap<String,Object>> result = new ArrayList<HashMap<String,Object>>();
        try {
            String sql = "Select * from man Where ID = ?";
            conn = getConnetion();
            ps =conn.prepareStatement(sql);
            ps.setObject(1, id);
            rs = ps.executeQuery();
            Blob blob =null;
            while(rs.next()) {
                blob = rs.getBlob("picture");
                break;
            }
            InputStream ins = blob.getBinaryStream();
            path = path + "jppicture" + id + ".jpg";
            File file = new File(path);
            if(!file.exists()){
                file.createNewFile();
            }
            OutputStream fos = new FileOutputStream(file);
            byte[] b = new byte[1024];
            int len = 0;
            while((len = ins.read(b))!=-1){
                fos.write(b,0,len);
            }
            fos.close();
            ins.close();
        }catch (Exception e){
            System.out.print("something error");
        }finally {
            try {

                if(rs != null){
                    rs.close();
                }

                if(ps != null){
                    ps.close();
                }

                if(conn != null){
                    conn.close();
                }
            } catch (SQLException e) {
                System.out.print("���ݿ�رճ���");
            }

        }

    }