一、通过传递参数读取db2的blob数据放到服务器的硬盘目录
/**
* 从三项查询出来文件数据放到服务器的webapps的jj目录
* @param path,路径
* @param dateStr,时间戳
* @param fileName,文件名称
* @param itemId,项目id
*/
public void findByAttachment(String path,String dateStr,String fileName,String itemId){
String sql = "select fileInfo.file_obj from V_INSPECT_FILE_INFO AS fileInfo " +
"where to_char(fileInfo.ITEM_ID) = '"+itemId+"'";
Connection con = HibernateSessionFactory.makeConnection();
try {
con.setAutoCommit(false);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
java.sql.Blob blob = rs.getBlob(1);
InputStream ins = blob.getBinaryStream();
File pathFile = new File(path);
if(!pathFile.exists()){
pathFile.mkdirs();
}
//输出到文件
File file = new File(path+dateStr+fileName);