oracle保存blob图片
1、新建的表结构为
2、hbm.xml文件为AuthSfzDO.hbm.xml
<?xml version="1.0" encoding="UTF-8"?> <!-- Hibernate XML Mapping File --> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="com.wisoft.tysfrz.entity" auto-import="true"> <class name="AuthSfzDO" table="Auth_sfz"> <id name="id"> <column name="id" not-null="true" length="32"/> <generator class="uuid.hex"> </generator> </id> <property name="zmsfzname" lazy="false"> <column name="zmsfzname" length="100"/> </property> <property name="zmsfzdata" lazy="false"> <column name="zmsfzdata"/> </property> <property name="fmsfzname" lazy="false"> <column name="fmsfzname" length="100"/> </property> <property name="fmsfzdata" lazy="false"> <column name="fmsfzdata"/> </property> <property name="scsfzname" lazy="false"> <column name="scsfzname" length="100"/> </property> <property name="scsfzdata" lazy="false"> <column name="scsfzdata"/> </property> <property name="grinfoid" lazy="false"> <column name="grinfoid" length="32"/> </property> <property name="uptime" lazy="false"> <column name="uptime" length="20"/> </property> </class> </hibernate-mapping>
3、Java类为AuthSfzDO.java
package com.wisoft.tysfrz.entity; import java.io.Serializable; /** * 身份证信息表 * */ public class AuthSfzDO implements Serializable{ /** * */ private static final long serialVersionUID = -6153078643179583844L; /** * 主键ID */ private String id; /** * 正面身份证照片 */ private String zmsfzname; /** * 反面身份证照片 */ private String fmsfzname; /** * 手持身份证照片 */ private String scsfzname; /** * 个人信息ID */ private String grinfoid; /** * 更新时间 */ private String uptime; /** * 正面身份证照片 */ private byte[] zmsfzdata; /** * 反面身份证照片 */ private byte[] fmsfzdata; /** * 手持身份证照片 */ private byte[] scsfzdata; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getZmsfzname() { return zmsfzname; } public void setZmsfzname(String zmsfzname) { this.zmsfzname = zmsfzname; } public String getFmsfzname() { return fmsfzname; } public void setFmsfzname(String fmsfzname) { this.fmsfzname = fmsfzname; } public String getScsfzname() { return scsfzname; } public void setScsfzname(String scsfzname) { this.scsfzname = scsfzname; } public String getGrinfoid() { return grinfoid; } public void setGrinfoid(String grinfoid) { this.grinfoid = grinfoid; } public String getUptime() { return uptime; } public void setUptime(String uptime) { this.uptime = uptime; } public byte[] getZmsfzdata() { return zmsfzdata; } public void setZmsfzdata(byte[] zmsfzdata) { this.zmsfzdata = zmsfzdata; } public byte[] getFmsfzdata() { return fmsfzdata; } public void setFmsfzdata(byte[] fmsfzdata) { this.fmsfzdata = fmsfzdata; } public byte[] getScsfzdata() { return scsfzdata; } public void setScsfzdata(byte[] scsfzdata) { this.scsfzdata = scsfzdata; } }
4、controller层
@RequestMapping("/uploadZmsfzImg")
@ResponseBody
public AjaxResult uploadZmsfzImg(HttpServletRequest request, MultipartFile file, String id) throws Exception{
AjaxResult result = new AjaxResult(false);
//保存
try {
// file.transferTo(targetFile);
result.setMsg("上传成功!");
result.setSuccess(true);
// result.setData(fileName);
AuthSfzDO authSfzDO = new AuthSfzDO();
// authSfzDO.setZmsfzname(fileName);
authSfzDO.setGrinfoid(id);
authSfzDO.setZmsfzdata(zmsfzData);
tysfrzUserBO.uploadSfzInfo(authSfzDO);
} catch (Exception e) {
e.printStackTrace();
result.setMsg("上传图片失败！");
log.error(this, e);
}
return result;
}
5、dao层
public void saveOrUpdateSfzInfo(AuthSfzDO authSfzDO){ List<AuthSfzDO> list = findAuthSfzInfoBygrid(authSfzDO.getGrinfoid()); String uptime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date(System.currentTimeMillis())); authSfzDO.setUptime(uptime); if (list !=null && list.size() > 0) { StringBuffer hql = new StringBuffer() ; List<Object> params = new ArrayList<>(); if (authSfzDO.getZmsfzdata() != null) { hql.append("update AuthSfzDO set zmsfzdata = ?") ; params.add(authSfzDO.getZmsfzdata()); } if (authSfzDO.getFmsfzdata() != null) { hql.append("update AuthSfzDO set fmsfzdata = ? ") ; params.add(authSfzDO.getFmsfzdata()); } if (authSfzDO.getScsfzdata() != null) { hql.append("update AuthSfzDO set scsfzdata = ?") ; params.add(authSfzDO.getScsfzdata()); } hql.append(" ,uptime = ? "); params.add(uptime); hql.append(" where grinfoid = ? "); params.add(authSfzDO.getGrinfoid()); this.updateByHql(hql.toString(), params.toArray()); }else{ this.save(authSfzDO); } }
6、前台页面
<script type="text/javascript" src="${basePath}r/project/nfm/plupload/plupload.full.min.js" ></script>
<button class="btn" id="uploadSfz_zm" data-type="uploadIms" style="width:130px;">上传正面身份证</button>
uploadZmsfzImg(); function uploadZmsfzImg() { var uploaderImg = new plupload.Uploader({ browse_button: 'uploadSfz_zm', url: GLOBAL.basePath + 'usercenter/uploadZmsfzImg.json?id='+$('#queryflag').val(), flash_swf_url: GLOBAL.basePath + 'r/project/nfm/plupload/Moxie.swf', silverlight_xap_url: GLOBAL.basePath + 'r/project/nfm/plupload/Moxie.xap', multi_selection: false, filters : { max_file_size : '20mb', mime_types: [ {title : "图片文件(jpg,jpeg,gif,png)",extensions : "jpg,jpeg,gif,png"} ] }, init: { PostInit: function() {}, BeforeUpload:function(up,file){ //uploader.setOption("headers",{"CSRFToken":$("meta[name='_csrf']").attr("content")}); }, FilesAdded: function(up, files) { uploaderImg.start(); //开始上传 }, UploadProgress: function(up, file) {}, FileUploaded: function(up, file, data) { data = JSON.parse(data.response); if (data.success) { $.showMsg("上传成功", function() { sfzflag1 = true; var name = data.data; var html = '<img alt="" src="../../usercenter/getZmSfzImages.do?grinfoid='+$('#queryflag').val()+'" style="cursor: pointer;width: 160px;height: 90px;">'; $("#sfz-zm").html(html); }); } else { $.showMsg("上传失败"); } $.hideLoading(); }, Error: function(up, err) { err = JSON.parse(err.response); alert(err.msg); card1Falg=false; } } }); uploaderImg.init(); }
