读书人

怎的把存入数据库中的*doc或*html文件

发布时间: 2011-12-02 23:47:57 作者: rapoo

怎样把存入数据库中的*.doc或*.html文件读出到指定的窗口中
如题。请各位大侠多给点意见。
从数据库中往外读:
String messid= " ";
String strExt= " ";
String sql = " ";
String title = " ";
messid=request.getParameter( "messid ");
String content=request.getParameter( "id ")==null? " ":request.getParameter( "id ");
if(! " ".equals(content))
content= " and id= "+content;
DB = new cscec.database.sysdbcon();
sql = "select AFFIXNAME,AFFIX_EXTEND,AFFIX from of_messAffix where mess_id= " + messid ;
System.out.println(sql);
//System.out.println(title+ "----- ");
rs = DB.executeQuery(sql);

sos = response.getOutputStream();

while(rs.next())
{//1

strExt=rs.getString( "affix_extend ");

response.reset();
if(strExt.equalsIgnoreCase( "doc "))
{
response.setContentType( "application/msword ");
}
else if(strExt.equalsIgnoreCase( "xls "))
{
response.setContentType( "application/vnd.ms-excel ");
}
else if(strExt.equalsIgnoreCase( "jpg "))
{
response.setContentType( "image/jpeg ");
}
else if(strExt.equalsIgnoreCase( "txt ")) //txt文件的显示
{
response.setContentType( "text/plain ");
}
else if(strExt.equalsIgnoreCase( "jpeg "))
{
response.setContentType( "image/jpeg ");
}
else if(strExt.equalsIgnoreCase( "gif "))
{
response.setContentType( "image/gif ");
}
else if(strExt.equalsIgnoreCase( "bmp "))
{
response.setContentType( "image/bmp ");
}
else
{
response.setContentType( "application/octet-stream ");

response.setHeader( "Content-Disposition ", "filename= " + new String(title.getBytes(), "ISO-8859-1 "));



}
in = rs.getBinaryStream( "affix ");
int len = 0;
byte[] b = new byte[1024];

while((len = in.read(b)) > 0)
{
sos.write(b,0,len);
sos.flush();
}
}//1


调用这个后,读出的文档输出到了一个新的窗口,不知道有什么方法可以把文档输出到指定的窗口中(比如view.jsp中的一个frame中)


谢谢各位。解决就给分。


[解决办法]
UP!
[解决办法]
解决了是不是觉得问题原来是这么简单?
哈哈,接分
[解决办法]
学习一下...
[解决办法]
现在的项目里甚至javascript也是这样生成的

读书人网 >Java Web开发

热点推荐