将String转换为Blob Java [英] Convert String to blob java

问题描述

我有一个从中接受用户图像的对象.我将此表格发送到下一个jsp页面以在数据库中插入数据.我采用数据库字段格式blog.我确实写了get参数行，现在我想将其转换为blob类型.我该怎么办?

i have a from which accept image from user. i sent this form to the next jsp page to insert data in database. i take database field format blog. i do write get parameter line, now i want to convert it to blob type. how can i do this ?

String pic=request.getParameter("pic");

我不想使用prepare语句在数据库中插入数据

i did not want to use prepare statement to insert data in database

推荐答案

您可以通过从String获取byte []内容来实现

You can do it by getting byte[] content from String

byte[] byteData = yourString.getBytes("UTF-8");//Better to specify encoding
Blob blobData = dbConnection.createBlob();
blobData.setBytes(1, byteData);

此外，您可以将String直接存储到BLOB列中.

Moreover, you can directly store String to BLOB column.

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