oracle blob转txt

  /**
     * 读取txt文件的内容
     * 
     * @param blob
     * @return
     * @see [类、类#方法、类#成员]
     */
    public static String txt2String(Blob blob)
    {
        String result = "";
        try
        {
            InputStream input = blob.getBinaryStream();
            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            int i = -1;
            while ((i = input.read()) != -1)
            {
                baos.write(i);
            }
            // 关闭流，不可少
            if (input != null)
                input.close();
            return baos.toString("GBK");
            /*
             * byte[] buffer = new byte[1024]; int n = -1; // 遍历，开始下载 while ((n = input.read(buffer, 0, 1024)) > -1) {
             * result = result + "\n" + new String(buffer, 0, n); }
             */
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        // System.out.println(result);
        return result;
    }