html tabel导出excel,png,pdf(pdf未解决中文问题)

package testjasperreport; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.util.HashMap; import java.util.Map; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JasperRunManager; import net.sf.jasperreports.engine.export.HtmlExporter; import net.sf.jasperreports.engine.export.JRXlsExporter; import net.sf.jasperreports.engine.util.JRLoader; import net.sf.jasperreports.export.SimpleExporterInput; import net.sf.jasperreports.export.SimpleHtmlExporterOutput; /** * Servlet implementation class HtmlResportServlet */ @WebServlet("/HtmlResportServlet") public class HtmlResportServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public HtmlResportServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { ServletContext context = this.getServletConfig().getServletContext(); File jasperFile = new File(context.getRealPath("/JasperFile/Blank_Letter_Landscape.jasper")); System.out.println(jasperFile.canExecute()); try{ //Map map = new HashMap(); Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://115.29.137.247:3306/mesclouds", "root", "asdfghjkl!@#"); System.out.println(conn); JasperReport jasperReport = (JasperReport) JRLoader.loadObject(jasperFile); ResultSet rs = conn.createStatement().executeQuery("select * from `user`"); JRResultSetDataSource jr = new JRResultSetDataSource(rs); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, jr); //JasperRunManager.runReportToHtmlFile(context.getRealPath("/JasperFile/Blank_Letter_Landscape.jasper"), "C:/Users/admin/Desktop/test.html", map, conn); HtmlExporter html = new HtmlExporter(); ByteArrayOutputStream out = new ByteArrayOutputStream(); html.setExporterOutput(new SimpleHtmlExporterOutput(response.getOutputStream())); html.setExporterInput(new SimpleExporterInput(jasperPrint)); html.exportReport(); //html.setParameter(parameter, value); //JRXlsExporter xls = new JRXlsExporter(); conn.close(); }catch(Exception e){ e.printStackTrace(); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub } }