这是ireport5.6+springboot框架整合的最终效果图(包含原生态的数据库交互)
---------猪皮楠
下面附上代码:
@GetMapping("/")
public HttpEntity<byte[]> getReportByParam(
@RequestParam(required = false) Map<String, Object> parameters,
HttpServletResponse response) throws SQLException, ClassNotFoundException, JRException, IOException {
// 读取文件流
/* ResourcePatternResolver loader = new PathMatchingResourcePatternResolver();
org.springframework.core.io.Resource resource = loader.getResource("ireport/report.jasper");
Map<String, Object> params = new HashMap<String, Object>();*/
List<CusBaseInfo> cusBaseInfoList = new ArrayList<>();
try {
conn = Util_1_JDBC.openConnection();
ps = conn.prepareStatement(queryStr);
rs = ps.executeQuery();
while (rs.next()) {
CusBaseInfo emp = new CusBaseInfo();
emp.setId(rs.getString("id"));
emp.setGlobalCustNumber(rs.getString("global_cust_number"));
emp.setCustName(rs.getString("cust_name"));
emp.setCertNo(rs.getString("cert_no"));
emp.setCreateTime(rs.getString("create_time")<