Java图片/文件下载+Hibernate+Oracle数据库Blob字段类型


@RequestMapping(value = "files.action")
public void files(HttpServletRequest request, HttpServletResponse response) {
try {
String faId = request.getParameter("id");
GzryFjxx fjxx = gzryFjxxServ.getByFaId(faId);
Blob img = fjxx.getTp();
long size = img.length();
byte[] b = img.getBytes(1, (int) size);
if (b.length > 0) {
for (int i = 0; i < b.length; i++) {
if (b[i] < 0) {
b[i] += 256;
}
}
String filename = java.net.URLEncoder.encode(fjxx.getText(),"UTF-8");
response.addHeader("Content-Disposition","attachment;filename=" + filename);
response.addHeader("Content-Transfer-Encoding", "binary");
response.setContentType("image/jpg");//MIME类型
OutputStream outs = response.getOutputStream();
outs.write(b);
outs.flush();
outs.close();
}
} catch (Exception e) {
System.out.println(e);
}
}

//Hibernate实体类:
import java.sql.Blob;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;

@Entity
@Table(name = "T_GZRY_FJXX")
public class GzryFjxx {

private String id;
private Blob tp;
private String text;

@Id
@GeneratedValue(generator = "paymentableGenerator")
@GenericGenerator(name = "paymentableGenerator", strategy = "uuid")
public String getId() {
return this.id;
}

public void setId(String id) {
this.id = id;
}

@Column(name = "TP")
public Blob getTp() {
return tp;
}

public void setTp(Blob tp) {
this.tp = tp;
}

@Column(name = "TEXT", length = 200)
public String getText() {
return text;
}

public void setText(String text) {
this.text = text;
}

}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值