如何在jsp页面中播放从oracle数据库中获取的视频

Question

​

 <p>   I am able to fetch the video from database in jsp page but it is showing like address. So how to play it in jsp page.
thanks in advance
In jsp page 
--------------------
Serial Number	Description	Videos
3	hbjghvfg	"oracle.jdbc.driver.OracleBlobInputStream@25e6fd4d"
4	hghhcs	oracle.jdbc.driver.OracleBlobInputStream@6fac1d5e
5	inserted video for testing	oracle.jdbc.driver.OracleBlobInputStream@1f6b4371
6	fddfdf	oracle.jdbc.driver.OracleBlobInputStream@2211ef76
7	vbvbv	oracle.jdbc.driver.OracleBlobInputStream@442a0e49
8	hhbvb	oracle.jdbc.driver.OracleBlobInputStream@6514448
9	dfdgg	oracle.jdbc.driver.OracleBlobInputStream@6e50c12b
21	grhrh	oracle.jdbc.driver.OracleBlobInputStream@7a01ff1d
22	bnbhbn	oracle.jdbc.driver.OracleBlobInputStream@eb35ba0
26	ghfjh	oracle.jdbc.driver.OracleBlobInputStream@79f7991b
</p>

​

Answer 1

看起来您已经在Oracle数据库中存储了Java对象。您必须选择blobs并将其反序列化到本地对象中，然后将其嵌入到结果页面中。

(此外，您可能希望将Oracle标记添加到问题中以展开它)

类似于：

<%
ResultSet rs = stmt.executeQuery("select videos from your_table")
rs.next();
InputStream istr = rs.getBlob("videos").getBinaryStream();
Object obj = new ObjectInputStream(istr).readObject();
String strObjClass = obj.getClass().getName();
out.println("Retrieved object " + obj + " of the class " + strObjClass);
%>