处理步骤:
第一步:将数据库中的Excel文件放到InputStream流中
第二步:通过inputStream流初始化HSSFWorkbook的实例
String query = "select fsdata_data from mw_sys.mwt_om_fsdata where obj_id ='"+obj_id+"'";
Statement stmt =null;
ResultSet rs = null;
Blob blob = null;
InputStream inputStream = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
if( rs.next())
{
blob = rs.getBlob(1);
}
inputStream = blob.getBinaryStream();//第一步:将数据库中的Excel文件放到InputStream流中
} catch (SQLException e) {
e.printStackTrace();
}finally
{
if( rs!=null)
try {rs.close();} catch (SQLException e) {e.printStackTrace();}
if( stmt!=null)
try {stmt.close();} catch (SQLException e) {e.printStackTrace();}
}
HSSFWorkbook workBook = new HSSFWorkbook(stream);//第二步:通过inputStream流初始化HSSFWorkbook的实例