hejianhuacn

		JRDataSource jrDataSource = getReportData(model);

		if (jrDataSource != null) {
			// Use the JasperReports JRDataSource.
			if (logger.isDebugEnabled()) {
				logger.debug("Filling report with JRDataSource [" + jrDataSource + "].");
			}
			return JasperFillManager.fillReport(this.report, model, jrDataSource);
		}

		else {
			if (this.jdbcDataSource == null) {
				this.jdbcDataSource = (DataSource) CollectionUtils.findValueOfType(model.values(), DataSource.class);
			}

			if (this.jdbcDataSource != null) {
				// Use the JDBC DataSource.
				if (logger.isDebugEnabled()) {
					logger.debug("Filling report with JDBC DataSource [" + this.jdbcDataSource + "].");
				}
				Connection con = this.jdbcDataSource.getConnection();
				try {
					return JasperFillManager.fillReport(this.report, model, con);
				}
				finally {
					try {
						con.close();
					}
					catch (SQLException ex) {
						logger.debug("Could not close JDBC Connection", ex);
					}
				}
			}

			else {
				// Assume that the model contains parameters that identify
				// the source for report data (e.g. Hibernate or JPA queries).
				return JasperFillManager.fillReport(this.report, model);
			}
		}

package net.aachina.jasperreport.render;

import java.io.ByteArrayOutputStream;
import java.util.Map;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.ui.jasperreports.JasperReportsUtils;
import org.springframework.util.CollectionUtils;
import org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsSingleFormatView;
import org.springframework.web.util.WebUtils;

import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.j2ee.servlets.ImageServlet;

public class JasperReportsHtmlViewExtend extends
		AbstractJasperReportsSingleFormatView {

	private static final int OUTPUT_BYTE_ARRAY_INITIAL_SIZE = 4096;

	public JasperReportsHtmlViewExtend() {
		setContentType("text/html; charset=UTF-8");
	}

	protected JRExporter createExporter() {
		JRHtmlExporter jrHtmlExporter = new JRHtmlExporter();
		jrHtmlExporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,
				"image?image=");
		return jrHtmlExporter;
	}

	protected boolean useWriter() {
		return true;
	}

	@Override
	protected void renderReport(JasperPrint populatedReport, Map model,
			HttpServletResponse response) throws Exception {
		// TODO 自动生成方法存根
		if (model.containsKey("requestObject")) {
			HttpServletRequest request = (HttpServletRequest) model
					.get("requestObject");
			request.getSession().setAttribute(
					ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE,
					populatedReport);

		}
		// Prepare report for rendering.
		JRExporter exporter = createExporter();

		// Set exporter parameters - overriding with values from the Model.
		Map mergedExporterParameters = mergeExporterParameters(model);
		if (!CollectionUtils.isEmpty(mergedExporterParameters)) {
			exporter.setParameters(mergedExporterParameters);
		}

		if (useWriter()) {
			// We need to write text to the response Writer.

			// Copy the encoding configured for the report into the response.
			String contentType = getContentType();
			String encoding = (String) exporter
					.getParameter(JRExporterParameter.CHARACTER_ENCODING);
			if (encoding != null) {
				// Only apply encoding if content type is specified but does not
				// contain charset clause already.
				if (contentType != null
						&& contentType.toLowerCase().indexOf(
								WebUtils.CONTENT_TYPE_CHARSET_PREFIX) == -1) {
					contentType = contentType
							+ WebUtils.CONTENT_TYPE_CHARSET_PREFIX + encoding;
				}
			}
			response.setContentType(contentType);

			// Render report into HttpServletResponse's Writer.
			JasperReportsUtils.render(exporter, populatedReport, response
					.getWriter());
		}

		else {
			// We need to write binary output to the response OutputStream.

			// Apply the content type as specified - we don't need an encoding
			// here.
			response.setContentType(getContentType());

			// Render report into local OutputStream.
			// IE workaround: write into byte array first.
			ByteArrayOutputStream baos = new ByteArrayOutputStream(
					OUTPUT_BYTE_ARRAY_INITIAL_SIZE);
			JasperReportsUtils.render(exporter, populatedReport, baos);

			// Write content length (determined via byte array).
			response.setContentLength(baos.size());

			// Flush byte array to servlet output stream.
			ServletOutputStream out = response.getOutputStream();
			baos.writeTo(out);
			out.flush();
		}
	}

}

package net.aachina.jasperreport;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import net.sf.jasperreports.engine.JRResultSetDataSource;

import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

public class JasperSpringController implements Controller {

	private DataSource dataSource;

	public ModelAndView handleRequest(HttpServletRequest request,	HttpServletResponse response) throws ServletException,	IOException, ClassNotFoundException, SQLException
	{
		
		return new ModelAndView("report", getModel(request));
	}

	@SuppressWarnings("unchecked")
	private Map getModel(HttpServletRequest request) throws ClassNotFoundException, SQLException
	{
		Connection connection;
		Statement statement;
		ResultSet resultSet;
		HashMap model = new HashMap();
		String query = "SELECT"+
						    " Employees.[LastName] AS Employees_LastName,"+
						    " Employees.[FirstName] AS Employees_FirstName,"+
						    " Employees.[EmployeeID] AS Employees_EmployeeID,"+
						    " Orders.[OrderID] AS Orders_OrderID,"+
						    " Orders.[OrderDate] AS Orders_OrderDate "+
					   "  FROM "+
					     	" Employees INNER JOIN  Orders ON Employees.[EmployeeID] = Orders.[EmployeeID]";
		connection = dataSource.getConnection();
		statement = connection.createStatement();
		resultSet = statement.executeQuery(query);
		JRResultSetDataSource resultSetDataSource =new JRResultSetDataSource(resultSet);
		model.put("datasource", resultSetDataSource);
		model.put("requestObject",request);
		System.out.println("well done!");
		return model;
		}
	
	public void setDataSource(DataSource dataSource) 
	{
		this.dataSource = dataSource;
	}
}

package net.aachina.jasperreport;

import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.j2ee.servlets.ImageServlet;

public class HtmlReportServlet extends HttpServlet {
	public static final String REPORT_DIRECTORY = "/reports";

	protected void doGet(HttpServletRequest request,
	HttpServletResponse response) throws ServletException, IOException {
		Connection connection;
		ServletContext context = this.getServletConfig().getServletContext();
		String reportName = "ChartReportDemo";
		PrintWriter printWriter = response.getWriter();
		InputStream reportStream = getServletConfig().getServletContext()
				.getResourceAsStream(
						"/" + REPORT_DIRECTORY + "/" + reportName + ".jasper");
		JasperPrint jasperPrint;
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			connection = DriverManager
					.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind","sa","sa");
			
			
			jasperPrint = JasperFillManager.fillReport(reportStream,
					new HashMap(), connection);
			JRHtmlExporter htmlExporter = new JRHtmlExporter();
			response.setContentType("text/html");
			request.getSession().setAttribute(
					ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE,
					jasperPrint);
			
			htmlExporter.setParameter(JRExporterParameter.JASPER_PRINT,
					jasperPrint);
			htmlExporter.setParameter(JRExporterParameter.OUTPUT_WRITER,
					printWriter);
			htmlExporter.setParameter(JRHtmlExporterParameter.CHARACTER_ENCODING, "gb2312");
			htmlExporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,
					"image?image=");
			htmlExporter.exportReport();
			connection.close();
			System.out.println("done!");
		} catch (Throwable t) {
			// display stack trace in the browser
			t.printStackTrace(printWriter);
		}
	}
}

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>
	ReportWebApp</display-name>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
	<servlet>
		<servlet-name>jasperSpring</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet>
		<servlet-name>ImageServlet</servlet-name>
		<servlet-class>net.sf.jasperreports.j2ee.servlets.ImageServlet</servlet-class>
	</servlet>
	<servlet>
		<servlet-name>HtmlReportServlet</servlet-name>
		<servlet-class>
			net.aachina.jasperreport.HtmlReportServlet
		</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>jasperSpring</servlet-name>
		<url-pattern>/jasperSpring/*</url-pattern>
	</servlet-mapping>
	<servlet-mapping>
		<servlet-name>HtmlReportServlet</servlet-name>
		<url-pattern>/htmlReport</url-pattern>
	</servlet-mapping>
	<servlet-mapping>
		<servlet-name>ImageServlet</servlet-name>
		<url-pattern>/image</url-pattern>
	</servlet-mapping>
</web-app>