/*
* ReadFilejava
*
* Created on 年月日 下午:
*/
package jgwlapp;
import javaio*;
import *;
import javaxservlet*;
import javaxservlethttp*;
import javasql*;
import jgwlbaseDataBaseConnection;
import javaio*;
import oraclesql*;
/**
*
* @author Roy Chen
* @version
*/
public class ReadFile extends HttpServlet {
/** Initializes the servlet
*/
public void init(ServletConfig config) throws ServletException {
superinit(config);
}
/** Destroys the servlet
*/
public void destroy() {
}
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
byte[] buf=new byte[];
try{
Statement stmt=new DataBaseConnection()getStatement();
ResultSet rs=stmtexecuteQuery(select * from demo where id=);
responsereset();
//responsesetHeader(ContentDisposition attachement;filename=ssdoc;);
//**如要浏览器直接另存为就不屏蔽上行filename 为文件名
responsesetContentType(application/msword;charset=GBK);
//**此处为文件的mime类型可以在网上搜到本例为word
//application/vndmsexcel;charset=GBK 表示excel文件类型
//application/vndpdf;charset=GBK 表示pdf文件类型
ServletOutputStream out=responsegetOutputStream();
InputStream in;
if(rsnext())
in = blobgetBinaryStream();
while(inread(buf)!=){
outwrite(buf);
}
outflush();
outclose();
//**以下为网上看到的写如文件的样例
//==================
// while(rsnext()) {
//ServletOutputStream sout = responsegetOutputStream();
//InputStream in = rsgetBinaryStream();
//byte b[] = new byte[xa];
//for(int i = inread(b); i != ;){
// soutwrite(b);
// inread(b);
// }
// soutflush();
// soutclose();
//}
//====================
//FileOutputStream file_out=new FileOutputStream(f:\filename);
//InputStream blob_in=blobgetBinaryStream();
//int temp;
// while((temp=blob_inread())!=){
// file_outwrite(temp);}
// blob_inclose();
// file_outclose();
//outwrite(blobgetBinaryStream());
//outflush();
stmtclose();
}catch (SQLException e){
eprintStackTrace();
}
//PrintWriter out = responsegetWriter();
/* TODO output your page here
outprintln(<html>);
outprintln(<head>);
outprintln(<title>Servlet</title>);
outprintln(</head>);
outprintln(<body>);
outprintln(</body>);
outprintln(</html>);
*/
//outclose();
}
/** Handles the HTTP <code>GET</code> method
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
processRequest(request response);
}
/** Handles the HTTP <code>POST</code> method
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request HttpServletResponse response)
throws ServletException IOException {
processRequest(request response);
}
/** Returns a short description of the servlet
*/
public String getServletInfo() {
return Short description;
}
}
