<%@ page contentType="text/html; charset=gb2312"%>
<%@ include file="/DataIni/DataOpen.jsp"%>
<%@ include file="/ScriptLib/Init.jsp"%>
<%
String Id;
Id=request.getParameter("Id");
oracle.sql.BLOB m_Blob;
odbcQuery="select Body from Project_Design where ID="+Id;
odbcRs=odbcStmt.executeQuery(odbcQuery);
if(odbcRs.next())
{
System.out.println(odbcQuery);
OutputStream pOut=response.getOutputStream();
response.setContentType("application/msword"); m_Blob=(oracle.sql.BLOB)odbcRs.getBlob("Body");
byte[] Buffer=m_Blob.getBytes(1,(int)m_Blob.length());
pOut.write(Buffer);
pOut.close();
pOut.flush();
response.flushBuffer();
}
else
{
System.out.println(odbcQuery);
}
odbcRs.close();
%>
<%@ include file="/DataIni/DataClose.jsp"%>
<%@ include file="/DataIni/DataOpen.jsp"%>
<%@ include file="/ScriptLib/Init.jsp"%>
<%
String Id;
Id=request.getParameter("Id");
oracle.sql.BLOB m_Blob;
odbcQuery="select Body from Project_Design where ID="+Id;
odbcRs=odbcStmt.executeQuery(odbcQuery);
if(odbcRs.next())
{
System.out.println(odbcQuery);
OutputStream pOut=response.getOutputStream();
response.setContentType("application/msword"); m_Blob=(oracle.sql.BLOB)odbcRs.getBlob("Body");
byte[] Buffer=m_Blob.getBytes(1,(int)m_Blob.length());
pOut.write(Buffer);
pOut.close();
pOut.flush();
response.flushBuffer();
}
else
{
System.out.println(odbcQuery);
}
odbcRs.close();
%>
<%@ include file="/DataIni/DataClose.jsp"%>
解决方案 »
- 关于setCharacterEncoding()
- 关于hibernate一次去第几到第几条记录的问题
- jsp中split的使用问题!!!谢谢!!
- Struts连接sql server 2000的问题~~(加急30分钟结贴)
- 请问如何解决jsp中的中文问题
- 关于用户权限控制的问题
- quartz动态加载,并实现有状态的任务执行
- JSP如何取得所在城市名
- 我只有4分了,不过我这个问题真的很急!
- 为什么我在jsp中执行executequery后,数据库数据进去了,但报错SQLException: No ResultSet was produced
- 急,在等..
- 怎么都没有人看我的贴???嫌分儿少??还是没牛人呐??
{
var hwnd=window.open('Show.jsp?Id='+Id,'','');
}
如果要直接下载:
response.setContentType("application/octet-stream");