/** * Blob写文件 * @param filePath * @param blob */ static void getBlobToFile(String filePath,java.sql.Blob blob){ InputStream ins = null; OutputStream fout = null; try{ ins = blob.getBinaryStream(); //输出到文件 File file = new File(filePath); fout = new FileOutputStream(file); //将BLOB数据写入文件 byte[] b = new byte[1024]; int len = 0; while ( (len = ins.read(b)) != -1) { fout.write(b, 0, len); } fout.close(); ins.close(); }catch(Exception e){ e.printStackTrace(); } } /** * 读取clob字段 * @param rs * @param colName * @return */ public static void getClobToFile(String filePath,java.sql.Clob clob) { try { String content = ""; java.io.Reader reader=clob.getCharacterStream(); BufferedReader br = new BufferedReader(reader); String s = br.readLine(); while(s!=null){ content += s; s=br.readLine(); } //将从数据库中读出的内容写到文件中 FileOutputStream fo = new FileOutputStream(filePath); PrintStream so = new PrintStream(fo); so.println(content); so.close(); } catch (Exception e) { e.printStackTrace(); } } /** * 字符串写文件 * @param filePath * @param content * @return Boolean */ static Boolean createFile(String filePath,String content){ Writer writer = null; File file = new File(filePath); File temp = new File(file.getParent()); if(!temp.exists()){ temp.mkdirs() } try{ writer = new OutputStreamWriter(new FileOutputStream(file)); writer.write( content ); }catch(Exception e){ e.printStackTrace(); return false; }finally{ try{ if(writer!=null){ writer.close(); } }catch(Exception e1){ e1.printStackTrace(); } } return true; }