`
JavaSam
  • 浏览: 933931 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

JAVA 操作blob数据然后生成word文件

    博客分类:
  • JAVA
 
阅读更多
import java.io.*;
import java.sql.*;

public class Test {
	Connection con = null;
	Statement stmt = null;
	ResultSet rs = null;

	private ResultSet getResultSet() {

		try {
			Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
			String url = "jdbc:oracle:thin:@10.23.117.110:1521:zgzhms";
			String user = "ibms";
			String password = "ibms";
			con = DriverManager.getConnection(url, user, password);
			stmt = con.createStatement();
			String sql = "SELECT  t.TXN_TRADE FROM  T_TXN_TRADE t	WHERE  t.txn_trade_id = 1";
			rs = stmt.executeQuery(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return rs;
	}

	public void InputDoc() {
		Test temp = new Test();
		ResultSet rset = temp.getResultSet();
		try {
			while (rset.next()) {
				oracle.sql.BLOB blob = (oracle.sql.BLOB) rset.getBlob("TXN_TRADE");
				File f = new File("C:\\temp.doc");
				FileOutputStream fos = new FileOutputStream(f);
				InputStream is = blob.getBinaryStream();// 读出数据后转换为二进制流
				byte[] data = new byte[1024];
				while (is.read(data) != -1) {
					fos.write(data);
				}
				fos.close();
				is.close();
			}
			con.commit(); // 正式提交
			rset.close();
		} catch (Exception e) {
		}
	}

	public static void main(String[] args) {
		Test temp = new Test();
		temp.InputDoc();
	}
}

 

0
3
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics