Pull request #68: REPORT-113769 修改WebService程序数据集帮助文档中的示例代码

Merge in PG/plugin-report-doc-demo from ~ROGER.CHEN/plugin-report-doc-demo:release/11.0 to release/11.0

* commit '19eb4d058c4c44f424ba73eb79dd57ec25151f04':
  修复代码问题
  修复代码问题
  REPORT-113769 修改WebService程序数据集帮助文档中的示例代码

plugin.xml

@@ -4,12 +4,13 @@
     <name><![CDATA[文档demo代码集成]]></name>
     <active>yes</active>
     <hidden>no</hidden>
-    <version>1.1.1</version>
+    <version>1.1.2</version>
     <env-version>10.0~</env-version>
     <jartime>2018-08-02</jartime>
     <vendor>finereport</vendor>
     <description><![CDATA[集成帮助文档中的demo代码]]></description>
     <change-notes><![CDATA[
+        [2023-11-28] 插件适配11<br>
         [2018-01-25] 发布。<br>
         [2018-08-02] 插件适配10
         ]]></change-notes>

pom.xml

@@ -3,10 +3,10 @@
     <modelVersion>4.0.0</modelVersion>
     <groupId>com.fr.plugin</groupId>
     <artifactId>starter</artifactId>
-    <version>10.0</version>
+    <version>11.0</version>
     <packaging>pom</packaging>
     <properties>
-        <common-version>10.0-RELEASE-SNAPSHOT</common-version>
+        <common-version>11.0-RELEASE-SNAPSHOT</common-version>
         <web-inf-bucket>${project.basedir}/webroot/WEB-INF</web-inf-bucket>
     </properties>
     <dependencies>
@@ -28,6 +28,12 @@
             <version>${common-version}</version>
             <scope>compile</scope>
         </dependency>
+        <dependency>
+            <groupId>com.fr.cbb</groupId>
+            <artifactId>fine-cbb</artifactId>
+            <version>${common-version}</version>
+            <scope>compile</scope>
+        </dependency>
         <dependency>
             <groupId>com.fr.webui</groupId>
             <artifactId>fine-webui</artifactId>

readme.md

@@ -19,8 +19,7 @@
 ## 修改依赖的jar版本
 只需要更改pom.xml中的common-version属性即可。
 
-|common-version|含义|
-|--------------|----|
-|10.0-RELEASE-SNAPSHOT|10.0的测试版本快照|
-|10.0-SNAPSHOT|10.0的正式版本快照|
-|10.0|10.0的正式版本|
+| common-version        | 含义          |
+|-----------------------|-------------|
+| 11.0-RELEASE-SNAPSHOT | 11.0的测试版本快照 |
+| 11.0-PERSIST-SNAPSHOT | 11.0的正式版本快照 |

src/main/java/com/fr/data/WebServiceTableData.java

@@ -1,38 +1,87 @@
 package com.fr.data;
 
-import javax.xml.namespace.QName;
+import com.fr.general.data.TableDataException;
+import com.fr.log.FineLoggerFactory;
+import com.fr.stable.ParameterProvider;
 import org.apache.axis.client.Call;
 import org.apache.axis.client.Service;
-import com.fr.data.AbstractTableData;
-import com.fr.general.data.TableDataException;
 
-public class WebServiceTableData extends AbstractTableData{
-    private String[][] data;
+import javax.xml.namespace.QName;
+import java.util.ArrayList;
+import java.util.List;
 
-    public WebServiceTableData() {
-        this.data = this.createData();
-    }
+/**
+ * WebService程序数据集
+ *
+ * @author Roger
+ * @since 11.0
+ * Created on 2024/1/8
+ */
+public class WebServiceTableData extends SimpleTableData {
 
-    //获取列数
-    public int getColumnCount() throws TableDataException {
-        return data[0].length;
-    }
+    private static final int COLUMN_COUNT = 10;
 
-    //获取列的名称为数组中第一行的值
-    public String getColumnName(int columnIndex) throws TableDataException {
-        return data[0][columnIndex];
+    /**
+     * 初始化列名数组
+     *
+     * @return {col1,col2,col3...}
+     * @throws TableDataException
+     */
+    @Override
+    public String[] initColumnNames() {
+        String[] columnNames = new String[COLUMN_COUNT];
+        for (int i = 0; i < COLUMN_COUNT; i++) {
+            columnNames[i] = "column#" + i;
+        }
+        return columnNames;
     }
 
-    //获取行数为数据的长度-1
-    public int getRowCount() throws TableDataException {
-        return data.length - 1;
-    }
+    /**
+     * 加载数据
+     *
+     * @return 行列数据
+     */
+    @Override
+    public List<Object[]> loadData() {
+        String tableName = ((ParameterProvider) (parameters.get().toArray())[0]).getValue().toString();
+        FineLoggerFactory.getLogger().info("Query SQL of ParamTableDataDemo: {}", tableName);
 
-    //获取值
-    public Object getValueAt(int rowIndex, int columnIndex) {
-        return data[rowIndex + 1][columnIndex];
+        // 保存得到的结果集
+        ArrayList<Object[]> valueList = new ArrayList();
+
+        try {
+            // 调用 Web 服务获取数据
+            String[][] data = createData();
+
+            // 如果数据为空，直接返回空列表
+            if (data == null || data.length == 0) {
+                return valueList;
+            }
+
+            // 获得总列数
+            int colNum = data[0].length;
+
+            // 用对象保存数据
+            Object[] objArray = null;
+            for (int rowIndex = 1; rowIndex < data.length; rowIndex++) {
+                objArray = new Object[colNum];
+                for (int i = 0; i < colNum; i++) {
+                    objArray[i] = data[rowIndex][i];
+                }
+                // 在valueList中加入这一行数据
+                valueList.add(objArray);
+            }
+        } catch (Exception e) {
+            FineLoggerFactory.getLogger().error(e.getMessage(), e);
+        }
+        return valueList;
     }
 
+    /**
+     * 调用 Web 服务获取数据
+     *
+     * @return
+     */
     public String[][] createData() {
         try {
             String endpoint = "http://localhost:8080/axis/TestWS2TDClient.jws";

src/main/java/com/fr/demo/SimpleReportletDemoFrm.java

@@ -1,16 +1,15 @@
 package com.fr.demo;
 
-import java.util.Map;
-import javax.servlet.http.HttpServletRequest;
 
+import com.fr.form.main.DashboardTemplate;
 import com.fr.form.main.Form;
 import com.fr.form.main.FormIO;
 import com.fr.log.FineLoggerFactory;
 import com.fr.web.weblet.Formlet;
-
+import java.util.Map;
+import javax.servlet.http.HttpServletRequest;
 
 public class SimpleReportletDemoFrm extends Formlet {
-
     @Override
     public void setParameterMap(Map arg0) {
         // TODO Auto-generated method stub
@@ -18,17 +17,20 @@ public class SimpleReportletDemoFrm extends Formlet {
     }
 
     @Override
-    protected Form createForm(HttpServletRequest request) throws Exception {
+    protected DashboardTemplate createDashboard(HttpServletRequest req) throws Exception {
         Form form = null;
         //模板的相对路径
         String tplPath = "//doc//frm//决策报表入门.frm";
         this.setTplPath(tplPath);
+
         try {
             form = FormIO.readForm(tplPath);
         } catch (Exception e) {
             FineLoggerFactory.getLogger().error(e.getMessage(), e);
         }
+
         return form;
     }
 
-}
+
+}