【Stimulsoft Reports Java教程】在运行时创建关系 表

此示例项目显示了使用关系和自定义对象数据库在运行时创建 表的可能性。

下载Stimulsoft Reports Java最新版本

此示例项目显示了使用关系和自定义对象数据库在运行时创建 表的可能性。

首先，创建一个将存储数据的对象类。

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;    }}

接下来，创建从StiDatabase类扩展的父数据库并填充connect事件上的数据。

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);    }}

接下来，创建相同的子数据库。

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);    }}

要显示 表，我们需要创建Java查看器。创建JFrame，设置必要的选项并添加查看器控件。

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);...

接下来，创建新的 表对象，然后将父数据库和子数据库添加到其中。

...    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());...

接下来，在对象表源中设置自定义列。

...    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);...

将带有文本框的标题区带和数据带添加到 表中。

...    // 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);    }...

创建 表的所有组件，我们现在可以配置数据关系。

...    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));}

示例代码的结果如下图所示：

下载示例

购买Stimulsoft正版授权，请点击“咨询在线客服”哟！

标签：HTML5 表JavaStimulsoft