Firebird

• public String convert(Blob blob) throws Exception {   
•   
•    BufferedInputStream bis = new BufferedInputStream(blob.getBinaryStream());   
•   
•    byte bindata[] = new byte[1024];   
•    int bytesread = 0;   
•   
•    ByteArrayOutputStream baos = new ByteArrayOutputStream(1024);   
•   
•    while ((bytesread = bis.read(bindata, 0, bindata.length)) != -1)   
•       baos.write(bindata, 0, bytesread);   
•   
•    bis.close();   
•   
•    return baos.toString();   
•   
• }  

•  

   

   

   

   

   

   

   

  1. <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"  
  2.          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">   
  3.     
  4.  <hibernate-mapping>   
  5.     <class name="auge.bean.Cor" table="CORES" >   
  6.           <id name="cor" column="cor" type="java.lang.String">   
  7.               <generator class="assigned"/>   
  8.           </id>   
  9.        <property name="nome" column="nome" type="java.lang.String" />            
  10.        <property name="descricao" column="descricao" type="binary" />            
  11.     </class>   
  12.  </hibernate-mapping>  

  <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping>     <class name="auge.bean.Cor" table="CORES" >           <id name="cor" column="cor" type="java.lang.String">               <generator class="assigned"/>           </id>        <property name="nome" column="nome" type="java.lang.String" />                 <property name="descricao" column="descricao" type="binary" />              </class> </hibernate-mapping>
  
  O campo "descricao" eh o blob, mapeado como binary.
  
  Meus métodos getters e setters estao assim:
  
  

  1. private byte[] descricao;   
  2.   
  3.    public void setDescricao(byte[] descricao) {   
  4.             this.descricao = descricao;   
  5.    }   
  6.     
  7.    public byte[] getDescricao() {   
  8.       return this.descricao;   
  9.    }  

   

   

   

  public static void main(String arg[]) throws Exception {

    ApplicationContext ctx = new FileSystemXmlApplicationContext(
      "E://work1//sshtest//src//applicationContext.xml");
    BlobTestService bt = (BlobTestService) ctx.getBean("blobservice");
    bt.out();

    // Blobtest bts=new Blobtest();
    // // Blob photo = null;
    // FileInputStream fis = new FileInputStream("e://a.jpg");
    // byte[] bs = new byte[fis.available()];
    // fis.read(bs);
    //
    // //转成Blob类型
    // //photo = Hibernate.createBlob(fis);
    // bts.setImg(bs);
    //  
    // bt.saveBlob(bts);

    Blobtest bb = bt.getBlobtest(2);
    byte[] is = bb.getImg();
    // 在把写到一个图片格式的文件里

     File file1 = new File("e://erer.jpg");  
           file1.createNewFile();  
           FileOutputStream out=new FileOutputStream(file1);  
           out.write(is);  
          
  //  FileOutputStream fos = new FileOutputStream("e://linweihan.jpg");
  //  byte[] buffer = new byte[1024];
  //  int len = 0;
  //  // 从数据库中读取到指定的字节数组中
  //  while ((len = is.read(buffer)) != -1) {
  //
  //   fos.write(buffer, 0, len);
  //  }
   }

  }