如何显示blob类型的字段?
<%@ page contentType="text/html;charset=gb2312"%>
<%@ codepage="937" >
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.*" %>
<%
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBLocation = "jdbc:oracle:thin:@143.1.1.2:1521:orcl";
String DBUser = "system";
String DBPwd = "manager";
Class.forName( DBDriver ) ;
Connection sqlCon = DriverManager.getConnection( DBLocation, DBUser,DBPwd);
java.sql.Statement sqlStmt = sqlCon.createStatement();
ResultSet sqlRst = null;
String strSql = "select b.title ,c.contents from article b,articlecontents c"+
" where b.columnid='75436436219756544' and b.id=c.articleid";
int i=0;
sqlRst = sqlStmt.executeQuery( strSql );
String title="";
String contents="";
%>
<table background="dt.gif">
<%
while(sqlRst.next() )
{
i=i+1;
title = sqlRst.getString(1);
oracle.sql.Blob contents=(oracle.sql.BLOB)sqlRst.getBlob(2);
%>
<tr><td align="center"><%=title%></td></tr>
<tr><td><%=contents%></td></tr>
<%
}
%>
</table>
<%
//关闭结果集
sqlRst.close();
//关闭SQL语句对象
sqlStmt.close();
//关闭数据库
sqlCon.close();
if (i==0)
{
%>
<script language="javascript">
window.opener =null;
window.close();
</script>
<%
}
%>
其中contents 字段为blob类型,我这样写对不对???