fanstatic

< 2025年3月 >
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
jasperreports ireport使用sql语句中有in时动态赋值
 <parameter name="
a_id" class="java.util.List"/>
 <queryString language="SQL">
  <![CDATA[select * from Apoplexy where  $X{IN, apoplexy_id, 
a_id}]]>

 </queryString>

 

 

import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JRPrintPage;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.export.JRHtmlExporter;
import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;

import net.sf.jasperreports.engine.util.JRLoader; 

 

 

public void report() throws ServletException, IOException {
HttpServletRequest request = ServletActionContext.getRequest();
HttpServletResponse response = ServletActionContext.getResponse();
String jasper = "report/ApoplexyReport.jasper"; // 你的jasper文件地址
String filename = "中疯病患者详细信息报表"; // 
// 各种参数设置好
List<Integer> collection = new ArrayList<Integer>();
collection.add(14);
collection.add(15);
collection.add(16);
collection.add(17);
collection.add(18);
collection.add(19);
collection.add(20);
collection.add(21);
collection.add(22);
collection.add(23);
collection.add(24);
collection.add(25);
Map map = new HashMap();
map.put("a_id", collection);
try {
// 读取jasper
JasperReport jr = (JasperReport) JRLoader
.loadObjectFromLocation(jasper);
Connection conn = DBConnection.getConnection();
// 填充数据
JasperPrint jp = JasperFillManager.fillReport(jr, map, conn);
// 判断是否正常
List<JRPrintPage> pages = jp.getPages();
// ReportType.export(response, jp, ReportType.EXCEL, filename);
ReportType.export(response, jp, ReportType.HTML, filename);
} catch (Exception ex) {
System.out.println(ex.toString());
}
}

 

public void export(HttpServletResponse response, JasperPrint jp, int type,
String filename) throws Exception {
JRExporter exporter = null;
int HTML = 1;
int EXCEL = 2;
final int PDF = 3;
if (type == HTML) {
exporter = new JRHtmlExporter();
exporter.setParameter(
JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, false);
exporter.setParameter(JRHtmlExporterParameter.BETWEEN_PAGES_HTML,
"");
// exporter.setParameter(JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
// Boolean.TRUE);
} else if (type == EXCEL) {
exporter = new JRXlsExporter();
response.setContentType("application/vnd.ms-excel");
response.addHeader("Content-Disposition", new String(
("attachment; filename=" + filename + ".xls")
.getBytes("GBK"), "ISO-8859-1"));
exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,
Boolean.FALSE);
// exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
// Boolean.TRUE);
} else if (type == PDF) {
exporter = new JRPdfExporter();
response.setContentType("application/pdf");
response.addHeader("Content-Disposition", new String(
("attachment; filename=" + filename + ".pdf")
.getBytes("GBK"), "ISO-8859-1"));
} else {
return;
}
exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, "GBK");
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response
.getOutputStream());
exporter.exportReport();


posted on   fanstatic  阅读(1660)  评论(0编辑  收藏  举报

编辑推荐:
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
阅读排行:
· 百万级群聊的设计实践
· 永远不要相信用户的输入:从 SQL 注入攻防看输入验证的重要性
· 全网最简单!3分钟用满血DeepSeek R1开发一款AI智能客服,零代码轻松接入微信、公众号、小程
· .NET 10 首个预览版发布,跨平台开发与性能全面提升
· 《HelloGitHub》第 107 期
点击右上角即可分享
微信分享提示