对于保存与数据库中的图片,一般采用blob字段类型进行存储,获取该数据类型并输出的写法如下:
/**
*
* @return
*/
@Action
public String testfile() {
try {
String filePath = "D:\\workspace_my\\workspace-wjbrs-nw\\WJBRS\\5SRC\\01源码\\release\\photo\\1111.jpg";
List<Map<String, Object>> list = this.bdsoftMybatisUtils.selectList("filemanage.fileUpload.getSystemAttachment");
Blob blob = (Blob) list.get(0).get("ATTACHMENT_CONTENT");
// Blob blob = (Blob) imgStr;
byte[] msgContent = null;
msgContent = blob.getBytes(1, (int) blob.length());
// 字节数组转换为输入流
InputStream is = new ByteArrayInputStream(msgContent);
// 上传文件到服务器
String absoluetPath =filePath;
File file = new File(filePath);
if (!file.exists()) {
file.createNewFile();
}
// 上传文件到服务器
BufferedOutputStream bos = null;
try {
bos = new BufferedOutputStream(new FileOutputStream(absoluetPath));
byte[] b = new byte[1024];
int len = 0;
while ((len = is.read(b)) != -1) {
bos.write(b, 0, len);
}
is.close();
bos.close();
if (is != null) {
is.close();
}
} finally {
if (bos != null) {
bos.close();
}
}
} catch (Exception e) {
// TODO: handle exception
}
return "";
}