JasperReport报表自定义DataSource

最新推荐文章于 2021-02-27 03:03:27 发布

goldbox

最新推荐文章于 2021-02-27 03:03:27 发布

阅读量1.6k

点赞数

分类专栏： Reports Make 文章标签：报表 hashmap import dataset class sqlserver

本文链接：https://blog.youkuaiyun.com/goldbox/article/details/1524859

版权

本文档展示了如何实现一个名为`PrintDataSource`的类，该类继承自`JRDataSource`，用于处理JasperReport报表的自定义数据源。通过连接SQLServer数据库，执行SQL查询获取数据，并将其存储在ArrayList中。内容包括建立数据库连接，预编译SQL语句，遍历结果集并转换为HashMap存储，最后返回数据集供报表使用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package it.businesslogic.ireport.connection;

import net.sf.jasperreports.engine.* ;

// import net.sf.jasperreports.engine.data.*;

//import java.sql.Statement;

import java.sql.ResultSet;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Map;

import java.util.HashMap;

import net.sf.jasperreports.view.JasperViewer;

import java.util.ArrayList;

import java.sql.ResultSetMetaData;

import java.sql.PreparedStatement;

public class PrintDataSource implements JRDataSource {

private int index = -1;

ArrayList dataSet = new ArrayList(); //存放从数据库里查询出来的数据集,里面存放HashMap

Connection con = null;

public static String sql = "select school_code,right(school_name,4) as school_name,one_grade_class+two_grade_class+three_grade_class+four_grade_class+five_grade_class+six_grade_class+(select count(*) from class_definition) as total1,one_grade_class as one, two_grade_class as two,three_grade_class as three, four_grade_class as four,five_grade_class as five, six_grade_class as six,(select count( * ) from class_definition) as fushi from school_info where student_total>=? and student_total<=?"; //传来的sql语句，填充数据集时用

int cellCount = 0; //记录数据集的列数