A configuration report development method based on a Springboot+vue framework

Abstract

The present application relates to the field of information technology, and provides a configuration report development method based on a Springboot+vue framework.The present application aims to solve the various cumbersome data query and report statistics needs of front desk and back office personnel in credit and related businesses.In order to realize quick response to needs, realize lightweight report development, simplify the development mode, and reduce the implementation cost.The present application scheme includes a report development method based on a Springboot+vue framework, introduces a set of report development method, supports mapping the query content to a form one by one and displaying on the front desk interface by analyzing the report query script, and supports form configuration, which is independent of complex logic code development, and can quickly realize report implementation landing only by form template configuration and simple page configuration.

Description

TECHNICAL FIELD

[0001] The application relates to the field of information technology and provides a configuration report development method based on a Springboot+vue framework. BACKGROUND

[0002] For the massive report requirements of business data statistical query, the traditional data statistical method is complicated.

[0003] In credit and related businesses, front-end and back-end personnel have various data query and report statistical requirements, and data files are exported in the form of excel tables. In order to realize rapid response to requirements, realize lightweight report development, simplify the development method and reduce the implementation cost, the application scheme comprises the following steps: analyzing the form content according to the report form content style, configuring the report query script, mapping the query content to the form one by one and displaying the query content on the front-end interface, and supporting form configuration to quickly realize report implementation landing. SUMMARY

[0004] The application aims to solve the problem that front-end and back-end personnel have various data query and report statistical requirements in credit and related businesses, and data files are exported in the form of excel tables. In order to realize rapid response to requirements, realize lightweight report development, simplify the development method and reduce the implementation cost, the application scheme comprises the following steps: analyzing the form content according to the report form content style, configuring the report query script, mapping the query content to the form one by one and displaying the query content on the front-end interface, and supporting form configuration to quickly realize report implementation landing.

[0005] To solve the above technical problems, the application adopts the following technical scheme:

[0006] A configuration report development method based on a Springboot+vue framework comprises the following steps:

[0007] Step 1: defining a report display interface xxReport.html, establishing xxReport.js, supporting browser display of html, and using js to call a background processing method;

[0008] Step 2: configuring a form excel and defining a view object ReqVO of the configuration form <t>, define foreground display view object RespVO, through the parameter form object ReqVO, through a series of processing get foreground display report view object RespVO;

[0009] Step 3: define report service interface ReportService, define view method view, output view object RespVO;

[0010] Step 4: define report service implementation class ReportServiceImpl. java, implement the view method view described in step 3, output view object RespVO;

[0011] Step 5: define interface xxReport, parameter: method call path, redefine view method, output RespVO view object; define implementation class xxReportImpl. java, inject parameter ReqVO <t>excel form file stream, realizing the view method;

[0012] Step 6: The xxReport.js triggered by step 1 establishes a report implementation class xxReportImpl.java to realize the interface display of the report.

[0013] In the above technical solution, step 1 includes the following steps:

[0014] Step 1.1: Import the style library in xxReport.html, reference the vuejs component library, and import xxReport.js;

[0015] Step 1.2: Write the page module in xxReport.html, including report type, filtering condition, report view module, and report export module;

[0016] Step 1.3: The vue object in xxReport.js: attribute: module,

[0017] Attribute data:

[0018] Report type, report type is divided into fixed report and detailed report;

[0019] Filter condition: query according to time, flow, and report element field;

[0020] Report view implementation path.

[0021] In the above technical solution, step 2 includes the following steps:

[0022] Step 2.1: Configure the form excel, including configuring the sheet page and the detail sheet page,

[0023] The configuration page includes report name, header row range, data display row, data footer row, data total column number, and query sql script;

[0024] The detail page is to configure the specific report style required and the corresponding data display parameters;

[0025] Step 2.2: Define the view object ReqVO of the form <t>Data Transfer Object View, parameter T: filter condition, attribute: report type, display page number PageNo, page size PageSize;

[0026] Step 2.3: define foreground data display view object RespVO, attribute: display page number PageNo, page size PageSize, total number total, page html.

[0027] In the above technical solution, step 3 only makes interface definition, describes the external service of the system, and does not specifically involve implementation details, so as to achieve loose coupling effect, and step 3 includes the following steps:

[0028] Step 3.1: define view method view, parameter: Req <t>The configuration form file stream input stream is an input stream in the form of an excel report form file stream.

[0029] Step 3.2: output view display object RespVO.

[0030] In the above technical solution, step 4 specifically implements the view method, including the following steps:

[0031] Step 4.1: write a read configuration file method readConfig, according to the excel file stream parameters, perform parsing to obtain each corresponding attribute of the form processing object ExcelBO and the specific query script;

[0032] The form processing object ExcelBO includes the following attributes:

[0033] Table name, table header row interval, data display row, data table tail row, data total column number, query sql script group querySqlMap, form page sheet, and work book;

[0034] Step 4.2: write the readConfig file configuration method readConfig according to step 4.1:

[0035] Step 4.2.1: according to the excel file stream parameters, obtain the workbook object, and obtain the configuration file form sheet page;

[0036] Step 4.2.2: the configuration parameters of the configuration sheet page of step 2.1 include:

[0037] Table name;

[0038] Table header row interval;

[0039] Data display row;

[0040] Data table tail row;

[0041] Data total column number;

[0042] Query script group, query script group includes script number, script sql,

[0043] Read each configuration from the configuration file form sheet page and assign it to each corresponding attribute of the form processing object ExcelBO;

[0044] Step 4.2.3: obtain the form display page sheet and the work book from the input form file stream input stream, and assign them to the form page sheet and the work book attributes of the ExcelBO;

[0045] Step 4.3: Define query data result set Map: dataSets <script number, <script Sql, result set>> to store the report required to display data result set;

[0046] Step 4.4: Define queryData method, input: form processing object ExcelBO, report type;

[0047] Report filter conditions, return query data result set Map: dataSets,

[0048] Traverse the query script of the form processing object ExcelBO configuration form, and the query script and the result set connected with the database query are stored in dataSets;

[0049] Step 4.5: Define abstract class write html method, initialize class, form object ExcelBO and result set dataSets obtained in step 4.4 are written into html;

[0050] Step 4.6: Write view method, parameter: Req <t>, form file stream input stream, output foreground view display object RespVO, file stream input stream indicates that the report form excel is converted into a file stream form:

[0051] Step 4.6.1: from the input parameter Req <t>Get the display page code and page number of step 2.2, and assign them to the corresponding attributes of the RespVO;

[0052] Step 4.6.2: Get the form processing object ExcelBO from the input file stream InputStream and the report type, call the queryData method described in step 4.4 to get the query data result set Map, and write the html;

[0053] Step 4.6.3: Assign the page html of step 4.6.2 to the html attribute of the RespVO view object, and at this point, all the attributes of the front-end view display object RespVO have been assigned.

[0054] In the above technical solution, step 5 includes the following steps:

[0055] Step 5.1: Define the interface xxReport to describe the view method provided externally.

[0056] Step 5.2: Redefine the view method according to steps 4.1-4.6, output the view object RespVO, and the parameter is the form object ReqVO <t>.

[0057] Step 5.3: define the implementation class xxReportImpl.java, implement the view display method, inject the configuration form excel to obtain the input stream InputStream, call the view implementation method view, and output the foreground view object RespVO.

[0058] In the above technical solution, step 6 includes the following steps:

[0059] Step 6.1: introduce xxReport.js in the html page established in step 1, html supports browser display, js is used to call the background processing class, the interface xxReport described in step 5 is called in js, the view method is called by step 5.3 after the parameter is passed to output the foreground view object, and is converted into html.

[0060] Steps 3 and 4 are the specific implementation of the report function, and this part can be generated as a jar package. In the actual development process, only steps 1 and 2 are needed to establish html and report configuration file excel, and only the implementation of the business logic layer needs to be focused on.

[0061] Query interface configuration: only the related content of the excel table of the interface to be displayed needs to be configured, and the interface display can be quickly completed; in a typical scenario, configuring the interface means that the front end and the back end need to be configured (such as html writing, back-end interface writing, database sql writing, etc.). After the implementation of the configurable interface, the complex and tedious code development is freed, and only the development of the business logic layer needs to be focused on, and the desired result can be obtained after saving and deploying.

[0062] Because the application adopts the above technical solution, the following beneficial effects are achieved:

[0063] In order to realize the rapid response to the demand, realize the lightweight report development, simplify the development method and reduce the implementation cost. The application scheme includes a report development method based on Springboot+vue framework, introduces a set of report development method, supports mapping the query content one by one to the form and displaying on the front-end interface by parsing the report query script, and supports form configuration, which is independent of complex logic code development. Only through the form template configuration and simple page configuration, the report implementation can be quickly realized. BRIEF DESCRIPTION OF DRAWINGS

[0064] Figure 1 The flowchart for the report is shown in the figure;

[0065] Figure 2 The configuration form style is shown in the figure;

[0066] Figure 3 The detail form style is shown in the figure;

[0067] Figure 4 For example. DETAILED DESCRIPTION

[0068] The present application relates to the field of information technology, and provides an approval flow authorization rule solution based on parameterized rule set configuration, and the present application is characterized in that in the credit and related business, the front desk and back office personnel various data query and report statistical requirements are exported according to the excel table style data file. In order to realize the demand response quickly, the lightweight report development is realized, and the development mode is simplified, and the implementation cost is reduced.

[0069] A configuration report development method based on Springboot+vue framework, comprising the following steps:

[0070] Step 1: define the report display interface xxReport.html, establish xxReport.js, html supports browser display, and.js is used to call the background processing method;

[0071] Step 2: configure the form excel, define the view object ReqVO of the configuration form <t>, define foreground display view object RespVO, through the parameter form object ReqVO, through a series of processing get foreground display report view object RespVO;

[0072] Step 3: define report service interface ReportService, define view method view, output view object RespVO;

[0073] Step 4: define report service implementation class ReportServiceImpl.java, implement the view method view described in step 3, output view object RespVO;

[0074] Step 5: define interface xxReport, parameter: method call path, redefine view method, output RespVO view object; define implementation class xxReportImpl.java, inject parameter ReqVO <t>excel form file stream, realizing the view method;

[0075] Step 6: The xxReport.js triggered by step 1 establishes a report implementation class xxReportImpl.java to realize the interface display of the report.

[0076] In the above technical solution, step 1 includes the following steps:

[0077] Step 1.1: Import the style library in xxReport.html, reference the vuejs component library, and import xxReport.js;

[0078] Step 1.2: Write the page module in xxReport.html, including report type, filtering condition, report view module, and report export module;

[0079] Step 1.3: The vue object in xxReport.js: attribute: module,

[0080] Attribute data:

[0081] Report type, report type is divided into fixed report and detailed report;

[0082] Filter condition: query according to time, flow, and report element field;

[0083] Report view implementation path.

[0084] In the above technical solution, step 2 includes the following steps:

[0085] Step 2.1: Configure the form excel, including configuring the sheet page and the detail sheet page,

[0086] The configuration page includes report name, header row range, data display row, data footer row, data total column number, and query sql script;

[0087] The detail page is to configure the specific report style required and the corresponding data display parameters;

[0088] Step 2.2: Define the view object ReqVO of the form <t>Data Transfer Object View, parameter T: filter condition, attribute: report type, display page number PageNo, page size PageSize;

[0089] Step 2.3: define foreground data display view object RespVO, attribute: display page number PageNo, page size PageSize, total number total, page html.

[0090] In the above technical solution, step 3 only makes interface definition, describes the external service of the system, and does not specifically involve implementation details, so as to achieve loose coupling effect, and step 3 includes the following steps:

[0091] Step 3.1: define view method view, parameter: Req <t>The file stream InputStream refers to the form of excel report table conversion into a file stream.

[0092] Step 3.2: output view display object RespVO.

[0093] In the above technical solution, step 4 specifically implements the view method, including the following steps:

[0094] Step 4.1: write a read configuration file method readConfig, according to the excel file stream parameters, perform parsing to obtain each corresponding attribute of the form processing object ExcelBO and the specific query script;

[0095] The form processing object ExcelBO includes the following attributes:

[0096] Table name, table header row interval, data display row, data table tail row, data total column number, query sql script group querySqlMap, form page sheet, and work book;

[0097] Step 4.2: write the readConfig file configuration method readConfig according to step 4.1:

[0098] Step 4.2.1: according to the excel file stream parameters, obtain the workbook object, and obtain the configuration file form sheet page;

[0099] Step 4.2.2: the configuration parameters of the configuration sheet page of step 2.1 include:

[0100] Table name;

[0101] Table header row interval;

[0102] Data display row;

[0103] Data table tail row;

[0104] Data total column number;

[0105] Query script group, query script group includes script number, script sql,

[0106] Read each configuration from the configuration file form sheet page and assign it to each corresponding attribute of the form processing object ExcelBO;

[0107] Step 4.2.3: obtain the form display page sheet and the work book from the input form file stream InputStream, and assign them to the form page sheet and the work book attributes of the ExcelBO;

[0108] Step 4.3: Define the query data result set Map: dataSets <script number, <script Sql, result set>> to store the report required to display data result set;

[0109] Step 4.4: Define the queryData method, input: form processing object ExcelBO, report type;

[0110] Report filter conditions, return query data result set Map: dataSets,

[0111] Traverse the query script of the form processing object ExcelBO configuration form, and the query script and the result set connected with the database query are stored in dataSets;

[0112] Step 4.5: Define the abstract class writeHtml method, initialize the class, and write the form object ExcelBO and the result set dataSets obtained in step 4.4 into html;

[0113] Step 4.6: Write the view method, parameter: Req <t>, form file stream input stream, output foreground view display object RespVO, file stream input stream indicates that the report form excel is converted into a file stream form:

[0114] Step 4.6.1: from the input parameter Req <t>Get the display page code and page number of step 2.2, and assign them to the corresponding attributes of the RespVO;

[0115] Step 4.6.2: Get the form processing object ExcelBO from the input file stream InputStream and the report type, call the queryData method described in step 4.4 to get the query data result set Map, and write the html;

[0116] Step 4.6.3: Assign the page html of step 4.6.2 to the html attribute of the RespVO view object, and at this point, all the attributes of the front-end view display object RespVO have been assigned.

[0117] In the above technical solution, step 5 includes the following steps:

[0118] Step 5.1: Define the interface xxReport to describe the view method provided externally.

[0119] Step 5.2: Redefine the view method according to steps 4.1-4.6, output the view object RespVO, and the parameter is the form object ReqVO <t>.

[0120] Step 5.3: Defining the implementation class xxReportImpl.java, implementing the view display method, injecting the configuration form excel to obtain the input stream InputStream, calling the view implementation method view, and outputting the foreground view object RespVO.

[0121] In the above technical solution, step 6 includes the following steps:

[0122] Step 6.1: Introducing xxReport.js in the html page established in step 1, html supporting browser display, js used to call the background processing class, calling the interface xxReport described in step 5 in js, passing parameters to call the view method output foreground view object in step 5.3, and converting to html.

[0123] Steps 3 and 4 are the specific implementation of the report function, which can be completely generated as a jar package. In the actual development process, only steps 1 and 2 need to be focused on establishing html and report configuration file excel, and only the business logic implementation needs to be focused on.

[0124] Query interface configuration: only the relevant content of the excel table of the interface to be displayed needs to be configured, and the interface display can be quickly completed; in the usual scenario, configuring the interface means that the front-end and back-end need to be configured (such as html writing, back-end interface writing, database sql writing, etc.), after implementing the configurable interface, the complex and tedious code development is freed, only the business logic layer development needs to be focused on, and the desired result can be obtained after saving and deploying.

[0125] Embodiment

[0126] The present scheme is based on Springboot+vue framework, adopts form configuration method, and realizes the rapid development of report. The report html page and js calling the background processing method are established, the form excel is configured, the page and detail page are configured, the processing method class is established, and the report processing method is called.

[0127] The specific implementation is further described below in combination with the flowchart ( Figure 1 ):

[0128] Step 1: Defining the report display interface Report.html, establishing Report.js;

[0129] Step 1.1: Introducing the style library in Report.html, referencing the vuejs component library, and introducing Report.js;

[0130] Step 1.2: Vue object in Report.js: attribute: module,

[0131] Attribute data:

[0132] Report type: detailed report;

[0133] Filter condition: query according to time, serial number, report element field;

[0134] Report view implementation path: view background method path.

[0135] Step 2: Configure the form excel and define the view object ReqVO of the configuration form <t>T represents time, water, and other screening conditions, define foreground display view object RespVO, through the call view method to get the foreground display report view object RespVO;

[0136] Step 2.1: configure form excel configuration sheet page and detail sheet page, Figure 2 Configuration page, Figure 3 Detail page, configuration page contains

[0137] Report name: monitoring query

[0138] Table header row interval: 1, 3

[0139] Data display row: 4

[0140] Data table footer row: 5

[0141] Data total column number: 16

[0142] Query sql script group: script number: data1, sql1; data2, sql2;

[0143] The detail page is to configure the specific report style required, display data corresponding parameters: Figure 3 The table sample and the column name corresponding parameters under the table header.

[0144] Step 2.2: define the view object ReqVO of the form <t>i.e. data transfer object view, parameter T: filter condition (date, serial number), attribute: report type: detail report, page number PageNo = 1, page size PageSize = 50;

[0145] Step 2.3: define foreground data display view object RespVO, attribute: display page number PageNo, page size PageSize, total number total, page html.

[0146] Step 3: define report service interface ReportService, define view method view, output view object RespVO;

[0147] Step 3.1: define view method view, parameter: view object ReqVO defined in step 2.2 <t>, configuration form file stream InputStream, file stream InputStream refers to the report form excel into a file stream form;

[0148] Step 3.2: output view display object RespVO.

[0149] Step 4: define report service implementation class ReportServiceImpl.java, implement the view method view described in step 3, output view object RespVO;

[0150] Step 4.1: write read configuration file method readConfig, according to excel file stream parameters, parse, get each corresponding attribute of form processing object ExcelBO and specific query script;

[0151] Form processing object ExcelBO contains the following attributes:

[0152] Table name, table header row interval, data display row, data table tail row, data total column number, query sql script group querySqlMap, form page sheet, workbook;

[0153] Step 4.2: write readConfig file configuration method readConfig in step 4.1:

[0154] Step 4.2.1: according to the form excel file stream, get workbook object, get configuration file form sheet page;

[0155] Step 4.2.2: the configuration parameters of the configuration sheet page in step 2.1 include:

[0156] Table name, table header row interval, data display row, data table tail row, data total column number,

[0157] Query script group: query script group contains script number, script sql,

[0158] Read each configuration from the configuration file form sheet page and assign it to each corresponding attribute of the form processing object ExcelBO;

[0159] Step 4.2.3: get form display page sheet and workbook from input form file stream InputStream, assign it to form page sheet and workbook attribute of ExcelBO;

[0160] Step 4.3: Define query data result set Map: dataSets<Script number data, <Script Sql, result set>> to store the report required to display data result set;

[0161] Step 4.4: Define queryData method, input: form processing object ExcelBO, report type;

[0162] Report filter conditions, output query data result set Map: dataSets,

[0163] Iterate through the query script of the form processing object ExcelBO configuration form, and store the query script and the result set connected to the database query in dataSets;

[0164] Step 4.5: Define abstract class write html method, initialize class, form object ExcelBO and result set dataSets obtained in step 4.4 are written into html;

[0165] Step 4.6: Call view method, input: Req <t>, form file stream input stream, output foreground view display object RespVO, file stream input stream indicates that the report form excel is converted into a file stream form:

[0166] Step 4.6.1: from the input parameter Req <t>Get the display page code and page number of step 2.2, and assign them to the corresponding attributes of the RespVO;

[0167] Step 4.6.2: Get the form processing object ExcelBO from the input file stream InputStream and the report type, call the queryData method described in step 4.4 to get the query data result set Map, and write the html;

[0168] Step 4.6.3: Assign the page html of step 4.6.2 to the html attribute of the RespVO view object. At this point, all the attributes of the front-end view display object RespVO have been assigned.

[0169] Step 5: Define the interface Report with the parameter method call path, redefine the view method, and output the RespVO view object; define the implementation class ReportImpl.java, and inject the parameter ReqVO <t>, excel form file stream, implement view method;

[0170] Step 5.1: define interface Report, describe the view method of the service provided to the outside.

[0171] Step 5.2: redefine the view method according to steps 4.1-4.6, output view object RespVO, parameter: form object ReqVO <t>.

[0172] Step 5.3: Define the implementation class ReportImpl.java, implement the view display method, inject the configuration form excel to obtain the input stream InputStream, call the view implementation method view, and output the foreground view object RespVO.

[0173] Step 6: Report.js triggered by step 1 to call the report implementation class ReportImpl.java to realize the interface display of the report:

[0174] Step 6.1: Import Report.js in the html page established in step 1, html supports browser display, js is used to call the background processing class, js calls the interface Report described in step 5, and the foreground view object is output by calling the view method in step 5.3 after passing parameters, and is converted to html.< / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t> < / t>

Claims

1. A configuration report development method based on a Springboot+vue framework, characterized in that, Step 1: defining a report display interface xxReport.html and establishing xxReport.js, with the html supporting browser display and the js used to call a background processing method; Step 2: Configure the form excel, define the view object of the configuration form ReqVO <t>defining a front-end display view object RespVO, obtaining the report view object RespVO to be displayed on the front end through a series of processes of the parameterized form object ReqVO;< / t> Step 3: defining a report service interface ReportService and a view method view to output the view object RespVO; Step 4: defining a report service implementation class ReportServiceImpl.java to implement the view method view of Step 3 to output the view object RespVO; Step 5: define interface xxReport, parameter: method call path, redefine view method, output RespVO view object; define implementation class xxReportImpl.java, inject parameter ReqVO <t>an excel form file stream to implement the view method;< / t> Step 6: the xxReport.js of Step 1 triggers the call of the report implementation class xxReportImpl.java to realize the interface display of the report; Step 4 specifically implements the view method, including the following steps: Step 4.1: writing a readConfig method to read a configuration file, parse the excel file stream parameters to obtain the respective corresponding attributes of the form processing object ExcelBO and the specific query script; the form processing object ExcelBO includes the following attributes: table name, table header row interval, data display row, data table tail row, data total column number, query sql script group querySqlMap, form sheet, and workbook; Step 4.2: Step 4.1 writes the readConfig method to read the file configuration: Step 4.2.1: according to the excel file stream parameters, obtains the workbook object and the configuration file form sheet page; Step 4.2.2: the configuration parameters of the configuration sheet page of Step 2.1 include: table name; table header row interval; data display row; data table tail row; data total column number; query script group, which includes script number and script sql, read each configuration from the configuration file form sheet page and assign it to the respective corresponding attributes of the form processing object ExcelBO; Step 4.2.3: obtain the form display page sheet and the workbook from the input form file stream InputStream and assign them to the form sheet and the workbook attributes of the ExcelBO; Step 4.3: defining a query data result set Map: dataSets<Script Number, <Script Sql, Result Set>> to store the report data result set required for display; Step 4.4: defining a queryData method with the form processing object ExcelBO and the report type as input parameters; report filtering conditions, and returning the query data result set Map: dataSets, Traverse the query script of the form processing object ExcelBO configuration form, and the query script and the result set of the database query are stored in dataSets; Step 4.5: Define the abstract class write html method, initialize the class, the form object ExcelBO and the result set dataSets obtained in step 4.4 are written into html; Step 4.6: Write the view method, parameter: Req <t>The file stream InputStream, the output front-end view display object RespVO, and the file stream InputStream refer to the report form excel converted into a file stream form:< / t> Step 4.6.1 : From input parameters Req <t>Get the display page number and page number of step 2.2, and assign them to the corresponding attributes of RespVO;< / t> Step 4.6.2: Get the form processing object ExcelBO from the input file stream InputStream and the report type, call the queryData method described in step 4.4 to get the query data result set Map, and write it into html; Step 4.6.3: Assign the page html of step 4.6.2 to the html attribute of the RespVO view object, and thus the attributes of the front-end view display object RespVO have been assigned.

2. The method of claim 1, wherein, Step 1 includes the following steps: Step 1.1: Import the style library in xxReport.html, reference the vuejs component library, and import xxReport.js; Step 1.2: Write the page module in xxReport.html, including report type, filtering condition, report view module, and report export module; Step 1.3: In xxReport.js, the vue object has the following attributes: Attribute data: Report type, report type is divided into fixed report and detailed report; Filtering conditions: query according to time, serial number, and report element field; Report view implementation path.

3. The method of claim 1, wherein, Step 2 includes the following steps: Step 2.1: Configure the form excel, including configuring the sheet page and the detail sheet page, The configuration page includes report name, header row range, data display row, data table footer row, data total column number, and query sql script; The detail page is to configure the specific report style and display data corresponding parameters needed; Step 2.2: Define the view object of the form, ReqVO <t>That is, the data transfer object view, parameter T: filtering condition, attribute: report type, display page number PageNo, page size PageSize;< / t> Step 2.3: Define the front-end data display view object RespVO, attributes: display page number PageNo, page size PageSize, total number total, and page html.

4. The method of claim 1, wherein, Step 3 only defines the interface, describes the system's external services, and does not specifically involve implementation details, achieving loose coupling. Step 3 includes the following steps: Step 3.1 : Define view method view, parameter: Req <t>Configure the form file stream InputStream, and the file stream InputStream refers to the report form excel converted into a file stream form;< / t> Step 3.2: Output the view display object RespVO.

5. The method of claim 1, wherein, Step 5 includes the following steps: Step 5.1: Define the interface xxReport, describe the view method provided to the outside world; Step 5.2: Redefine the view method according to step 4.1-4.6, output view object RespVO, parameter: form object ReqVO <t> ；< / t> Step 5.3: define the implementation class xxReportImpl.java, implement the view display method, inject the configuration form excel to get the input stream InputStream, call the view implementation method view, and output the foreground view object RespVO.

6. The method of claim 1, wherein, Step 6 includes the following steps: Step 6.1: introduce xxReport.js in the html page established in step 1, html supports browser display, js is used to call the background processing class, js calls the interface xxReport described in step 5, and after parameter transmission, the view method is called by step 5.3 to output the foreground view object, and is converted into html.

Images