下載Stimulsoft Reports Java最新版本

此示例項目顯示了使用關(guān)系和自定義對象數(shù)據(jù)庫在運行時創(chuàng)建報表的可能性。

首先，創(chuàng)建一個將存儲數(shù)據(jù)的對象類。

public class ObjectCell {
    public String val;
 
    @Override
    public boolean equals(Object obj) {
        return val.equals(((ObjectCell) obj).val);
    }
 
    public String toString() {
        return val;
    }
 
    public ObjectCell(String val) {
        this.val = val;
    }
}

接下來，創(chuàng)建從StiDatabase類擴展的父數(shù)據(jù)庫并填充connect事件上的數(shù)據(jù)。

public class ParentDatabase extends StiDatabase {
 
    public ParentDatabase() {
        super("Demo.Parent");// Database name
    }
 
    public void connect(StiDataStoreSource stiDataStoreSource, Boolean fillTable) throws StiException {
        DataTable dataTable = stiDataStoreSource.createNewTable();
        for (int i = 0; i < 5; i++) {
            DataRow dataRow = dataTable.createNewRow();
            dataRow.addCell("cId", new ObjectCell("Object" + i));
            dataRow.addCell("cName", "Parent cId: " + i);
        }
        stiDataStoreSource.setDataTable(dataTable);
    }
 
    public void disconnect() {
    }
 
    public void connect(StiDataStoreSource stiDataStoreSource) throws StiException {
        connect(stiDataStoreSource, true);
    }
}

接下來，創(chuàng)建相同的子數(shù)據(jù)庫。

public class ChildDatabase extends StiDatabase {
 
    public ChildDatabase() {
        super("Demo.Child");// Database name
    }
 
    public void connect(StiDataStoreSource stiDataStoreSource, Boolean fillTable) throws StiException {
        DataTable dataTable = stiDataStoreSource.createNewTable();
        for (int i = 0; i < 5; i++) {
            for (int k = 0; k < 5; k++) {
                DataRow dataRow = dataTable.createNewRow();
                dataRow.addCell("cId", new ObjectCell("Object" + i));
                for (int j = 1; j < dataRow.getColumns().size(); j++) { // fill row wiht my data
                    dataRow.addCell(dataRow.getColumns().get(j).getColumnName(), "Child cId: " + i + " value: " + j);
                }
            }
        }
        stiDataStoreSource.setDataTable(dataTable);
    }
 
    public void disconnect() {
    }
 
    public void connect(StiDataStoreSource stiDataStoreSource) throws StiException {
        connect(stiDataStoreSource, true);
    }
}

要顯示報表，我們需要創(chuàng)建Java查看器。創(chuàng)建JFrame，設(shè)置必要的選項并添加查看器控件。

public class CreateRelationsReport extends JPanel {
 
    private static final long serialVersionUID = 330448692680237867L;
    private static final Dimension FRAME_SIZE = new Dimension(800, 800);
    public static void main(final String[] args) {
        SwingUtilities.invokeLater(new Runnable() {
            public void run() {
                try {
                    JFrame frame = new JFrame();
                    frame.add(new CreateRelationsReport(frame));
                    frame.setSize(FRAME_SIZE);
                    frame.setLocationRelativeTo(null);
                    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
                    frame.setVisible(true);
                } catch (Throwable e) {
                    StiExceptionProvider.show(e, null);
                }
            }
        });
    }
    public CreateRelationsReport(final JFrame parentFrame) throws IOException {
    setLayout(new BoxLayout(this, BoxLayout.Y_AXIS));
    setPreferredSize(FRAME_SIZE);
    StiViewerFx viewerPanel = new StiViewerFx(parentFrame);
    add(viewerPanel);
...

接下來，創(chuàng)建新的報表對象，然后將父數(shù)據(jù)庫和子數(shù)據(jù)庫添加到其中。

...
    StiReport report = new StiReport();
 
    StiPage page = new StiPage(report);
    report.getPages().add(page);
    page.setName(StiNameCreation.createName(report, StiNameCreation.generateName(page)));
    report.setDictionary(new StiDictionary(report));
    report.getDictionary().getDatabases().add(new ParentDatabase());
    report.getDictionary().getDatabases().add(new ChildDatabase());
...

接下來，在對象表源中設(shè)置自定義列。

...
    List<StiDataTableSource> tableSources = new ArrayList<StiDataTableSource>();
    // parent
    StiDataTableSource tSource = new StiDataTableSource("Demo.Parent", "Parent", "Parent");
    tSource.setColumns(new StiDataColumnsCollection());
    tSource.getColumns().add(
        new StiDataColumn("cId", "cId", StiSystemType.getSystemType("System.Object")));
    tSource.getColumns().add(
        new StiDataColumn("cName", "cName", StiSystemType.getSystemType("System.String")));
    tSource.setDictionary(report.getDictionary());
    report.getDictionary().getDataSources().add(tSource);
    tableSources.add(tSource);
    // child
    tSource = new StiDataTableSource("Demo.Child", "Child", "Child");
    tSource.setColumns(new StiDataColumnsCollection());
    tSource.getColumns().add(
        new StiDataColumn("cId", "cId", StiSystemType.getSystemType("System.Object")));
    for (int i = 0; i < 4; i++) {
        tSource.getColumns().add(
           new StiDataColumn("cData" + i, "cData" + i,
           StiSystemType.getSystemType("System.String")));
    }
    tSource.setDictionary(report.getDictionary());
    report.getDictionary().getDataSources().add(tSource);
    tableSources.add(tSource);
...

將帶有文本框的標(biāo)題區(qū)帶和數(shù)據(jù)帶添加到報表中。

...
    // Create TitleBand
    StiHeaderBand titleBand = new StiHeaderBand();
    titleBand.setHeight(0.85);
    titleBand.setName("TitleBand");
    page.getComponents().add(titleBand);
 
    // Create Title text on header
    StiText headerText = new StiText(new StiRectangle(0, 0, page.getWidth(), 0.85));
    headerText.setTextInternal("Tacticdescription");
    headerText.setHorAlignment(StiTextHorAlignment.Left);
    headerText.setName("TitleHeader");
    headerText.setFont(new StiFont("Arial", 12F, StiFontStyle.Bold));
    titleBand.getComponents().add(headerText);
    Integer nameIndex = 1;
    List<StiDataBand> dataBands = new ArrayList<StiDataBand>();
    for (StiDataTableSource tableSource : tableSources) {
 
        // Create Databand
        StiDataBand dataBand = new StiDataBand();
        dataBand.setDataSourceName(tableSource.getName());
        dataBand.setHeight(0.5);
        dataBand.setName("DataBand" + nameIndex);
        nameIndex++;
        page.getComponents().add(dataBand);
 
        double pos = 0;
        double columnWidth = page.getWidth() / tableSource.getColumns().size();
 
        for (StiDataColumn dataColumn : tableSource.getColumns()) {
 
            StiText dataText = new StiText(new StiRectangle(pos, 0, columnWidth, 0.5));
            dataText.setText("{" + tableSource.getName() + "." + dataColumn.getName() + "}");
            dataText.setName("DataText" + nameIndex.toString());
            dataText.getBorder().setSide(StiBorderSides.All);
            dataBand.getComponents().add(dataText);
 
            pos = pos + columnWidth;
            nameIndex++;
        }
        dataBands.add(dataBand);
    }
...

創(chuàng)建報表的所有組件，我們現(xiàn)在可以配置數(shù)據(jù)關(guān)系。

...
    dataBands.get(1).setDataRelationName("Relation");
    dataBands.get(1).setMasterComponent(dataBands.get(0));
 
    ArrayList<String> cols = new ArrayList<String>();
    cols.add("cId");
 
    StiDataRelation rel = new StiDataRelation("Relation", tableSources.get(0),
    tableSources.get(1), cols, cols);
 
    report.getDictionary().getRelations().add(rel);
...

最后，渲染報表并在Java查看器中顯示它。

...
    report.Render();
 
    viewerPanel.getStiViewModel()
        .getEventDispatcher()
        .dispatchStiEvent(
            new StiViewCommonEvent(StiViewCommonEvent.DOCUMENT_FILE_LOADED,
            new StiDocument(report), null));
}

示例代碼的結(jié)果如下圖所示：

購買Stimulsoft正版授權(quán)，請點擊“”喲！