readattach.jsp

电子签章编译文件

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
	String attachid = request.getParameter("attachid");
	String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	String ConnStr = "jdbc:odbc:files20"; 
	Connection conn = null; 
	Statement stmt = 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); 
		stmt = conn.createStatement();
		rs = stmt.executeQuery("select * from attachdata where id="+attachid); 
	} 
	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");		
		java.io.OutputStream outStream = response.getOutputStream();
		byte[] buf = new byte[1024];
		int bytes = 0;
		while((bytes = in.read(buf)) != -1)
		{
			outStream.write(buf, 0, bytes);
			System.out.println(bytes+" bytes writed!");
		}
		in.close();				
		outStream.close();
	  }
	  catch(Throwable e)
	  {
	  	System.out.println(e.toString());
		throw new ServletException(e.toString());
	  }	  
	  break;
	}
	rs.close();
	stmt.close();	
	conn.close();
%>