【JSP开源代码栏目提醒】:网学会员鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“fl.jsp”一文,供大家参考学习
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="net.sf.jasperreports.engine.data.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%
JasperReport fatherReport=JasperCompileManager.compileReport(application.getRealPath("/reports/fenlanReport.jrxml"));
File flReportFile = new File(application.getRealPath("/reports/fenlanReport.jasper"));
Map<String,Object> parameters=new HashMap<String,Object>();
//鍒涘缓鏁版嵁搴撹繛鎺?
Connection conn=null;
try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://192.168.1.199:1433;DatabaseName=db_database22","sa","111");
}catch(Exception e) {
e.printStackTrace();
}
int maxOrderId=10;
parameters.put("reportTitle", "宸ヨ祫鎶ヨ〃"); //鎸囧畾鎶ヨ〃鍚嶇О鍙傛暟鍊?
parameters.put("company","鍚夋灄鐪佹槑鏃ョ鎶鏈夐檺鍏徃"); //鎸囧畾鍏徃鍚嶇О鍙傛暟鍊?
parameters.put("MaxOrderID",maxOrderId); //鎸囧畾鏈澶ц褰曟暟鍙傛暟鍊?
//鐢熸垚
byte[] bytes = JasperRunManager.runReportToPdf(flReportFile.getPath(), parameters, conn);
response.setContentType("application/pdf"); //鎸囧畾鎶ヨ〃绫诲瀷涓篜DF
response.setContentLength(bytes.length); //璁剧疆鍐呭闀垮害
ServletOutputStream ouputStream = response.getOutputStream(); //鑾峰彇杈撳嚭娴佸璞?
ouputStream.write(bytes, 0, bytes.length); //灏嗚緭鍑烘祦涓啓鍏ュ唴瀹?
ouputStream.flush();
out.clear();
out=pageContext.pushBody();
ouputStream.close(); //鍏抽棴杈撳嚭娴佸璞?
%>
上一篇:
fix.jsp
下一篇:
“海德格尔学案”对中国学人的启示