1

((com.mycompany.AAA)$F{param1})

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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.util.*" %>
<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%
      
      Connection conn = null;
    String dbName = "eduinfomanager";
    String dbuser = "leon";
    String dbpasswd = "123456";
    String dbserver = "192.168.12.166";
    String url = "jdbc:microsoft:sqlserver://" + dbserver + ":1433;DatabaseName=" +
      dbName;
      System.out.println("ssssssssssssssssss");
  File reportFile = new File(application.getRealPath("/reports/reply_report.jasper"));
    if (!reportFile.exists())
    throw new JRRuntimeException("File WebappReport.jasper not found. The report design must be compiled first.");
 
  Map parameters = new HashMap();
  
  parameters.put("id", "00001");
        System.out.println("fffffffffffffffffffff");
  
  try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").
          newInstance();
      conn = DriverManager.getConnection(url, dbuser, dbpasswd);
    }
    catch (SQLException sex) {
      sex.printStackTrace();
    }
    catch (ClassNotFoundException cex) {
      cex.printStackTrace();
    }
    catch (Exception se) {
      se.printStackTrace();
    }
            System.out.println("ccccccccccccccccccccc");
  
  byte[] bytes = 
    JasperRunManager.runReportToPdf(
      reportFile.getPath(), 
      parameters, 
      conn
      );
        System.out.println("eeeeeeeeeeeeeeeeeeeeeee");
 
  response.setContentType("application/pdf");
  System.out.println("gggggggggggggggggggggggggggggg");
  response.setContentLength(bytes.length);
  ServletOutputStream ouputStream = response.getOutputStream();
  ouputStream.write(bytes, 0, bytes.length);
  ouputStream.flush();
  ouputStream.close();
%>