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"));
}
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();
}