readimage.jsp

NTKO Office文档控件JSP示例安装指南

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*" %>
<%
	String id = request.getParameter("id");
	String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	String ConnStr = "jdbc:odbc:files23jsp"; 
	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 imagefiles where id="+id); 
	} 
	catch(SQLException ex)
	{ 
		System.err.println("aq.executeQuery: " + ex.getMessage()); 
	}
	while(rs.next())
	{
	  try
	  {
	    /*
	  	String filename = new String( rs.getBytes("filename"),"gb2312");
		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);
		in.close();	
		outStream.close();	
	  }
	  catch(Throwable e)
	  {
	  	System.out.println(e.toString());
		throw new ServletException(e.toString());
	  }
	  break;
	}
	rs.close();
	stmt.close();	
	conn.close();
%>