readdoc.jsp

用jsp实现的文件上传的组件,适合jsp开发人员使用.

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
	String docid = request.getParameter("docid");
	String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	String ConnStr = "jdbc:odbc:files"; 
	Connection conn = null; 
	ResultSet rs = null; 
	try 
	{ 
		//加载数据库驱动程序 
		Class.forName(DBDriver); 
	} 
	catch(java.lang.ClassNotFoundException e)
	{ 
		System.err.println("DBconn (): " + e.getMessage()); 
	}

	//与DBMS建立连接 
	try
	{ 
		conn = DriverManager.getConnection(ConnStr); 
		Statement stmt = conn.createStatement();
		rs = stmt.executeQuery("select * from MyUploadTable where id="+docid); 
	} 
	catch(SQLException ex)
	{ 
		System.err.println("aq.executeQuery: " + ex.getMessage()); 
	}
	while(rs.next())
	{
	  try
	  {
	  	String filename = new String( rs.getBytes("filename"),"gb2312");
	  	//System.out.println(filename);
		response.reset();
		response.setContentType("application/octet-stream");
		response.setHeader("Content-Disposition", "attachment; filename="+filename);
		java.io.InputStream in = rs.getBinaryStream("filedata");
		//response.setContentLength(in.available());
		java.io.OutputStream outStream = response.getOutputStream();
		byte[] buf = new byte[512];
		int bytes = 0;
		while((bytes = in.read(buf)) != -1)
			outStream.write(buf, 0, bytes);
		in.close();	
	  }
	  catch(Throwable e)
	  {
	  	System.out.println(e.toString());
		throw new ServletException(e.toString());
	  }
	  break;
	}
	rs.close();
%>