实现图片转换成二进制存入数据库的简单方法
public boolean insertDataImage(HttpServletRequest request,
PageContext pageContext) throws Exception {
String Bno = request.getParameter("Bno");
log.debug("Bno=" + Bno);
if (Bno == null || Bno.length() == 0) {
throw new AppException("错误提示:请选择要操作的编号!");
}
String sql0 = "update XXXX set XXXX=? where XXXX='" + Bno + "'";
SmartUpload mySmartUpload = null;
byte[] b1 = null;
try {
/**
* 文件上传 目前只能取JPG
*/
mySmartUpload = new SmartUpload();
mySmartUpload.initialize(pageContext);// 初始化
mySmartUpload.setMaxFileSize(ConfigServices.getUpLoadFileMaxSize());// 设置上传文件的最大长度byte
mySmartUpload.upload();// 上传
mySmartUpload.setAllowedFilesList("jpg,jpeg");
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
// 循环取得文件上传表单中的文件
log.debug(mySmartUpload.getFiles().getFile(i).getFileName());
com.jspsmart.upload.File myFile = mySmartUpload.getFiles()
.getFile(i);
String path = myFile.getFilePathName();
b1 = new byte[myFile.getSize()];
for (int j = 0; j < myFile.getSize(); j++) {
b1[j] = myFile.getBinaryData(j);
}
}
/**
* 写入输出流
*/
Object resObj = null;
if (b1 != null) {
final int contentLength = b1.length;
final InputStream fin = new ByteArrayInputStream(b1);
resObj = DaoTemplateFactory.getJdbcTemplate().execute(
sql0,
new AbstractLobCreatingPreparedStatementCallback(
SpringLobHandlerGetter.get()) {
protected void setValues(PreparedStatement ps,
LobCreator lobCreator) throws SQLException,
DataAccessException {
lobCreator.setBlobAsBinaryStream(ps, 1, fin,
contentLength);
}
});
if (fin != null) {
fin.close();
}
}
if (resObj != null) {
int count = ((Integer) resObj).intValue();
if (count > 0) {
return true;
} else {
return false;
}
} else {
return false;
}
} catch (Exception e) {
throw new AppException("错误提示:上传文件格式不正确或太大,请重新上传!");
}
}