ireport学习笔记

 将数据库的数据生成pdf,jar包以及ireport文件夹位置见相册图片

package com.ireport;

import java.io.File;
import java.io.IOException;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Map;

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

import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperRunManager;

public class Report extends HttpServlet {

 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  this.doPost(request, response);
 }

 @SuppressWarnings("deprecation")
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  response.setContentType("text/html;charset=utf-8");
  request.setCharacterEncoding("utf-8");
  Map<String, String> parameters = new HashMap<String, String>();

//设置参数,即select * from product where product_id = ?(下面的pro_id为这里的参数),这里你懂的。。。。
  String pro_id = "1";
  try {
   Connection con = DBCon.getCon();//连接数据库
   File exe_rpt = new File(request.getRealPath("/ireport/test.jasper"));
   parameters.put("pro_id", pro_id);

   JasperPrint jasperPrint = JasperFillManager.fillReport(exe_rpt.getPath(), parameters, con);
   // 生成pdf
   byte[] bytes = JasperRunManager.runReportToPdf(exe_rpt.getPath(), parameters, con);
   response.setHeader("Content-disposition", "attachment; filename="
     + java.net.URLEncoder.encode("报表", "UTF-8") + ".pdf");// 设定输出文件头,该方法有两个参数,分别表示应答头的名字和值。
   response.setContentType("application/pdf;charset=GBK");
   response.setContentLength(bytes.length);
   ServletOutputStream ouputStream = response.getOutputStream();
   ouputStream.write(bytes, 0, bytes.length);
   ouputStream.flush();
   ouputStream.close();
  } catch (Exception e) {
   e.printStackTrace();
  }

 }

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值