hibernate保存文件到Oracle

最新推荐文章于 2021-04-06 18:47:07 发布

原创最新推荐文章于 2021-04-06 18:47:07 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hibernate #Oracle #upload

java 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了一个关于更新用户车队信息的过程，并演示了如何通过Java进行文件的读写操作，包括设置Blob类型的数据和修改文件名。

CepUserFleet fleet=cepUserFleetMng.findByUserIdOrUserName(vo.getUserFleet().getUserId(), null);

                if(fleet!=null){

                    fleet.setCardNumber(vo.getUserFleet().getCardNumber());

                    fleet.setLegalName(vo.getUserFleet().getLegalName());

                    fleet.setLegalCardNum(vo.getUserFleet().getLegalCardNum());

                    fleet.setBusinessLicenseNum(vo.getUserFleet().getBusinessLicenseNum());

                    fleet.setCompanyName(vo.getUserFleet().getCompanyName());

                    fleet.setCompanyPhone(vo.getUserFleet().getCompanyPhone());

                    fleet.setCompanyZipCode(vo.getUserFleet().getCompanyZipCode());

                    fleet.setCompanyFax(vo.getUserFleet().getCompanyFax());

                    fleet.setCompanyAddress(vo.getUserFleet().getCompanyAddress());

                    fleet.setPerson(vo.getUserFleet().getPerson());

                    fleet.setMobile(vo.getUserFleet().getMobile());

                    fleet.setPhone(vo.getUserFleet().getPhone());

                    fleet.setEmail(vo.getUserFleet().getEmail());

                    fleet.setUpdateTime(vo.getUserFleet().getUpdateTime());

                    fleet.setCarNum(vo.getUserFleet().getCarNum());

                    /*

                    //upload

                    if(vo.getUserFleet().getCardNumberScann()!=null){

                        fleet.setCardNumberScann(vo.getUserFleet().getCardNumberScann());

                    }

                    if(vo.getUserFleet().getLegalCardCopy()!=null){

                        fleet.setLegalCardCopy(vo.getUserFleet().getLegalCardCopy());

                    }

                    if(vo.getUserFleet().getBusinessLicenseScann()!=null){

                        fleet.setBusinessLicenseScann(vo.getUserFleet().getBusinessLicenseScann());

                    }*/

                    //test

                    try {

 fleet.setCardNumberScann(Hibernate.createBlob(new FileInputStream("F:/test3/08103204ugzb.jpg")));

 fleet.setLegalCardCopy(Hibernate.createBlob(new FileInputStream("F:/test3/08103157nxg0.jpg")));

fleet.setBusinessLicenseScann(Hibernate.createBlob(new FileInputStream("F:/test3/08103202iido.jpg")));

                    } catch (Exception e) {

                        // TODO: handle exception

                        e.printStackTrace();

                    }

                }else{

                    fleet=vo.getUserFleet();

                }

                cepUserFleetMng.saveOrUpdate(fleet);

/**

*上传成功 修改文件名称

*

*/
 File file=new File("D:\\abc.java");  

if(file.exists())

{

file.renameTo(new File("d:\\123.txt"));

} 

/**

*读取文件

*和上面存储文件不是一个方式

*/

UserZP uzp = new UserZP();

String hqlClause = "select t.zpcontent  from app_gy_zp t "; 
List list=new ArrayList();

try {
 list=jdao.getRsBySql(hqlClause); 
 if(list!=null && !list.isEmpty()){
Object[] obj = (Object[]) list.get(0);
uzp.setZpcontent((java.sql.Blob)obj[2]); 
  InputStream is = uzp.getZpcontent().getBinaryStream(); 
  FileOutputStream fos = new FileOutputStream(“c://userpic.jpg”); 
  byte[] buffer = new byte[1024]; 
  int len = 0; 
  while((len = is.read(buffer) )!= -1){  
fos.write(buffer,0,len); 
 } 
  System.out.println("成功处理完毕"); 
  fos.close(); 
 fos = null; 
  is.close(); 
  is = null; 
}
}catch (Exception e) { 
  System.out.println(hqlClause); 
  e.printStackTrace(); 
 }