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 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();
}
浙公網安備 33010602011771號