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

最新推荐文章于 2024-08-07 19:31:05 发布

最新推荐文章于 2024-08-07 19:31:05 发布 · 1.7k 阅读

文章标签：

#java #数据库 #前端 #ViewUI

JAVA 专栏收录该内容

100 篇文章

订阅专栏

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();
	}
}