从oracle中读取blob图片资源

1.对应图片资源这张表创建对应的实体类

Ibatisblob.java

private byte[] picresult;public byte[] getPicresult() {        return picresult;    }public void setPicresult(byte[] picresult) {        this.picresult = picresult;    }

2.Dao层中的Dao.java和对应的映射文件sqlmap.xml

Dao.java

public List pic(Map map) {        return this.getSqlMapClientTemplate().queryForList("pic",map);    }

sqlmap.xml

<sqlMap namespace="**" >    <typeAlias alias="ibatisblob" type="cn.**.dao.IbatisBlob" /><select id="pic" parameterClass="java.util.HashMap" resultClass="ibatisblob">        select             pic        from             PICRESULT t         where             t.ispic = 1         and t.id = #id#         and t.name= #name#    </select>

3.service层处理

//获取查询        lllDao llis = (Dao) SpringBeansUtil.getBean("lllDao");        Map<String,String> map1 = new HashMap<String,String>();        //填写参数        map1.put("id", id);        map1.put("name", name);        //1.接收二进制的图片        List<IbatisBlob> imgResource = llis.pic(map1);        String str1 = null;        if(imgResource != null && imgResource.size()>0) {            byte[] picresult = imgResource.get(0).getPicresult();            //加密运算之后 将byte[]转化为base64            byte[] encodeBase64 = Base64.encodeBase64(picresult);            str1 = new String(encodeBase64);        }        //按照base64进行解密        byte[] decodeBase64 = Base64.decodeBase64(encodeBase64);        byte2image(decodeBase64, "G:\\1\\2.jpeg");

图片与字节数组相互转换

//图片到byte数组  public byte[] image2byte(String path){    byte[] data = null;    FileImageInputStream input = null;    try {      input = new FileImageInputStream(new File(path));      ByteArrayOutputStream output = new ByteArrayOutputStream();      byte[] buf = new byte[1024];      int numBytesRead = 0;      while ((numBytesRead = input.read(buf)) != -1) {      output.write(buf, 0, numBytesRead);      }      data = output.toByteArray();      output.close();      input.close();    }    catch (FileNotFoundException ex1) {      ex1.printStackTrace();    }    catch (IOException ex1) {      ex1.printStackTrace();    }    return data;  }/////////////////////////////////////byte数组到图片  public void byte2image(byte[] data,String path){    if(data.length<3||path.equals("")) return;    try{    FileImageOutputStream imageOutput = new FileImageOutputStream(new File(path));    imageOutput.write(data, 0, data.length);    imageOutput.close();    System.out.println("Make Picture success,Please find image in " + path);    } catch(Exception ex) {      System.out.println("Exception: " + ex);      ex.printStackTrace();    }  }  //byte数组到16进制字符串  public String byte2string(byte[] data){    if(data==null||data.length<=1) return "0x";    if(data.length>200000) return "0x";    StringBuffer sb = new StringBuffer();    int buf[] = new int[data.length];    //byte数组转化成十进制    for(int k=0;k<data.length;k++){      buf[k] = data[k]<0?(data[k]+256):(data[k]);    }    //十进制转化成十六进制    for(int k=0;k<buf.length;k++){      if(buf[k]<16) sb.append("0"+Integer.toHexString(buf[k]));      else sb.append(Integer.toHexString(buf[k]));    }    return "0x"+sb.toString().toUpperCase();  }