如何在java中将Blob转换为String和String转换为Blob [英] How to convert Blob to String and String to Blob in java

问题描述

我正在尝试通过使用

Blob blob = rs.getBlob(cloumnName[i]);
byte[] bdata = blob.getBytes(1, (int) blob.length());
String s = new String(bdata);

工作正常，但是当我要转换 String 到 Blob 并尝试插入数据库，然后没有插入数据库。我使用下面的代码将String转换为Blob：

It is working fine but when I'm going to convert String to Blob and trying to insert into database then nothing inserting into database. I've used below code for converting String to Blob:

String value = (s);
byte[] buff = value.getBytes();
Blob blob = new SerialBlob(buff);

任何人都可以帮我转换 Blob String 和 String 到 Blob ？ / p>

Can anyone help me about to converting of Blob to String and String to Blob in Java?

推荐答案

试试这个（a2是BLOB col）

try this (a2 is BLOB col)

PreparedStatement ps1 = conn.prepareStatement("update t1 set a2=? where id=1");
Blob blob = conn.createBlob();
blob.setBytes(1, str.getBytes());
ps1.setBlob(1, blob);
ps1.executeUpdate();

即使没有BLOB它也可以工作，驱动程序会自动转换类型：

it may work even without BLOB, driver will transform types automatically:

   ps1.setBytes(1, str.getBytes);
   ps1.setString(1, str);

此外，如果使用文本CLOB似乎是更自然的col类型

Besides if you work with text CLOB seems to be a more natural col type

这篇关于如何在java中将Blob转换为String和String转换为Blob的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！