从数据库中读出文件类型为Blob文件:html
Connection conn=null; PrepatedStatement pstmt=null; ResultSet resultSet=null; try{ connection=JDBCTools.getConnection(); String sql="Select id,name customerName,email,birth from customers where id=13"; preparedStatement=connection.prepareStatement(sql); resultSet=preparedStatement.executeQuery(); if(resultSet.next()){ int id=resultSet.getInt(1); String name=resultSet.getString(2); System.out.println(id+" "+name); Blob picture=resultSet.getBlob(4); InputStream in=picture.getBinaryStream(); OutputStream out=new FileOutputStream("flower.jpg"); byte[] buffer=new byte[1024]; while((len=in.read(buffer))!=-1){ out.write(buffer,0,len); } out.close(); in.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ JDBCTools.releaseDB(resultSet,preparedStatement,connectuon); }