数据库中使用image类型,Java实体类中要是有bytep[]字节数组的类型来进行封装
Bean层
public class Mark {
private String MARKID;
private String MARKTYPE;
private String DESCR;
private byte[] PIC;
接下来就可以对数据库进行查询,得到数据
DAO层
public Mark getImgByWonum(String wonum) {
try {
con = DBUtil.getConnection();
String sql = "select MARK.PIC from WOPARENT,MARK,WO2DTL,PRODUCT WHERE WO2DTL.PRONUM=PRODUCT.PRONUM and MARK.MARKID=WO2DTL.PRONUM and WOPARENT.WONUM=WO2DTL.WONUM and WOPARENT.WONUM=?";
ps = con.prepareStatement(sql);
ps.setString(1, wonum);
rs = ps.executeQuery();
try {
while(rs.next()){
byte[] pic = rs.getBytes("PIC");
Mark mark = new Mark();
mark.setPIC(pic); //保存数据
//System.out.println("图片是:"+pic);
return mark; //返回这个对象
}
} catch (Exception e) {
// TODO: handle