CN107609109A - A kind of report form generation method, device and system - Google Patents
A kind of report form generation method, device and system Download PDFInfo
- Publication number
- CN107609109A CN107609109A CN201710820831.7A CN201710820831A CN107609109A CN 107609109 A CN107609109 A CN 107609109A CN 201710820831 A CN201710820831 A CN 201710820831A CN 107609109 A CN107609109 A CN 107609109A
- Authority
- CN
- China
- Prior art keywords
- report
- sql
- name
- parameter
- platform
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of report form generation method, device and system, wherein, this method includes：Standard Structured Query language SQL is pre-set, in addition to：The report generation request that form platform is sent is received, wherein, the report generation request includes：Report number, report name, parameter name and parameter type；According to the report number, the report name, the parameter name, the parameter type and the stsndard SQL, query SQL is determined；Inquired about using the query SQL in database, generate form；The form is sent to the form platform, so that the form platform receives and shows the form.Scheme provided by the invention can improve report generation efficiency.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of report form generation method, device and system.
Background technology
In recent years, with E-Government, ecommerce and enterprise ERP (Enterprise Resource Planning,
Enterprise Resources Plan) fast development, seem more and more important the problems such as the collections of data, transmission, displaying, interaction.Form is made
It is the important component of enterprise information system, form has in all trades and professions for a kind of information tissue and the mode of displaying
Very extensive purposes, it is to carry out information browse, analysis, the powerful of printing.
In the prior art, SQL (Structured Query Language, the structure write typically are utilized by technical staff
Change query language) fetched manually from database.
But for the data extraction demand with periodic law, the report generation of this method is less efficient.Such as
Monthly magazine, monthly will developer write SQL and manually perform, repetitive operation adds human cost on the contrary.
The content of the invention
The embodiments of the invention provide a kind of report form generation method, device and system, it is possible to increase report generation efficiency.
In a first aspect, the embodiments of the invention provide a kind of report form generation method, stsndard SQL is pre-set, in addition to：
The report generation request that form platform is sent is received, wherein, the report generation request includes：Report number,
Report name, parameter name and parameter type；
According to the report number, the report name, the parameter name, the parameter type and the stsndard SQL,
Determine query SQL；
Inquired about using the query SQL in database, generate form；
The form is sent to the form platform, so that the form platform receives and shows the form.
Second aspect, the embodiments of the invention provide a kind of report generation device, including：
Setting unit, for setting stsndard SQL；
Receiving unit, for receiving the report generation request of form platform transmission, wherein, wrapped in the report generation request
Include：Report number, report name, parameter name and parameter type；
Generation unit, for received according to the receiving unit the report number, the report name, the parameter
The stsndard SQL that title, the parameter type and the setting unit are set, determines query SQL；Utilize the query SQL
Inquired about in database, generate form；
Transmitting element, the form for the generation unit to be generated is sent to the form platform, so that described
Form platform receives and shows the form.
The third aspect, the embodiments of the invention provide a kind of report generating system, including：Form platform and report generation dress
Put；
The report generation device, for setting stsndard SQL；The report generation request that the form platform is sent is received,
Wherein, the report generation request includes：Report number, report name, parameter name and parameter type；According to the form
Numbering, the report name, the parameter name, the parameter type and the stsndard SQL, determine query SQL；Using described
Query SQL is inquired about in database, generates form；The form is sent to the form platform；
The form platform, for receiving and showing the form.
Preferably,
The form platform, it is further used for setting at least one file format；The user is received described at least one
The destination file format determined in kind file format；The form is downloaded according to the destination file format；
The file format, including：Excel or txt.
Fourth aspect, the embodiments of the invention provide a kind of computer-readable recording medium, including execute instruction, when the place of storage control
When managing the device execution execute instruction, the storage control performs the method described in above-described embodiment.
5th aspect, the embodiments of the invention provide a kind of storage control, including：Processor, memory and bus；
The memory is used to store execute instruction, and the processor is connected with the memory by the bus, when
During the storage control operation, the execute instruction of memory storage described in the computing device, so that the storage
Method described in controller perform claim requirement 1.
The embodiments of the invention provide a kind of report form generation method, device and system, wherein, this method pre-sets standard
SQL, report number, report name, parameter name and parameter type generation during the stsndard SQL can ask with report generation are looked into
SQL is ask, the query SQL can inquire about the form corresponding with report generation request in database.This method is without exploit person
Member repeats to write SQL, it is possible to increase report generation efficiency.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.
Fig. 1 is a kind of flow chart for report form generation method that one embodiment of the invention provides；
Fig. 2 is a kind of structural representation for report generation device that one embodiment of the invention provides；
Fig. 3 is a kind of structural representation for report generating system that one embodiment of the invention provides；
Fig. 4 is a kind of flow chart for report form generation method that one embodiment of the invention provides.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is
Part of the embodiment of the present invention, rather than whole embodiments, based on the embodiment in the present invention, those of ordinary skill in the art
The every other embodiment obtained on the premise of creative work is not made, belongs to the scope of protection of the invention.
As shown in figure 1, the embodiments of the invention provide a kind of report form generation method, this method may comprise steps of：
Step 101：Stsndard SQL is set；
Step 102：The report generation request that form platform is sent is received, wherein, report generation request includes：Form is compiled
Number, report name, parameter name and parameter type；
Step 103：According to report number, report name, parameter name, parameter type and stsndard SQL, query SQL is determined；
Step 104：Inquired about using query SQL in database, generate form；
Step 105：Form is sent to form platform, so that form platform receives and shows form.
In the embodiment of the present invention shown in Fig. 1, this method pre-sets stsndard SQL, and the stsndard SQL can give birth to form
Query SQL is generated into the report number in request, report name, parameter name and parameter type, the query SQL can be in data
The form corresponding with report generation request is inquired about in storehouse.This method repeats to write SQL without developer, it is possible to increase form
Formation efficiency.
As shown in Fig. 2 the embodiments of the invention provide a kind of report generation device, including：
Setting unit 201, for setting stsndard SQL；
Receiving unit 202, for receiving the report generation request of form platform transmission, wherein, wrapped in report generation request
Include：Report number, report name, parameter name and parameter type；
Generation unit 203, for received according to receiving unit 202 report number, report name, parameter name, parameter
The stsndard SQL that type and setting unit 201 are set, determines query SQL；Inquired about, generated in database using query SQL
Form；
Transmitting element 204, the form for generation unit 203 to be generated are sent to form platform, so that form platform connects
Receive and show form.
As shown in figure 3, the embodiments of the invention provide a kind of report generating system, including：Form platform 301 and form life
Into device 302；
Report generation device 302, for setting stsndard SQL；The report generation request that form platform 301 is sent is received, its
In, report generation request includes：Report number, report name, parameter name and parameter type；According to report number, form
Title, parameter name, parameter type and stsndard SQL, determine query SQL；Inquired about using query SQL in database, it is raw
Into form；Form is sent to form platform 301；
Form platform 301, for receiving and showing form.
In one embodiment of the invention, it is user-friendly in order to provide the user with form, form platform 301,
It is further used for setting at least one file format；Receive the file destination lattice that user determines at least one file format
Formula；Form is downloaded according to destination file format；
File format, including：Excel or txt.
User can check form by form platform, can also download form by form platform.
If the data volume of form is smaller, directly can be downloaded in form platform；
If the data volume of form is larger, directly downloading needs the time to grow, and reservation may be selected and download, and is allowed to perform on backstage
Download.
As shown in figure 4, the embodiment of the present invention is by taking the report generating system that form platform and report generation device form as an example,
Report form generation method is described in detail, this method includes：
Step 401：Report generation device sets stsndard SQL.
Step 402：Form platform sets at least one file format.
File format, including：Excel or txt.
Step 403：Report generation device receives the report generation request that form platform is sent, wherein, report generation request
Include：Report number, report name, parameter name and parameter type.
Form platform is provided with database parameter allocation list, the database parameter configuration literary name section include report number,
Report name, parameter name, parameter type etc., user can be selected in database parameter allocation list, form platform root
According to the selection generation report generation request of user.
Step 404：Report generation device according to report number, report name, parameter name, parameter type and stsndard SQL,
Determine query SQL.
Step 405：Report generation device is inquired about using query SQL in database, generates form, form is sent
Give form platform.
Report number, report name, parameter name and the parameter type of each form are stored with database.
Using query SQL, inquiry and the report number in report generation request, report name, parameter name in database
Claim the report data to match with parameter type.
Step 406：Form platform receives and shows form.
Step 407：Form platform receives the destination file format that user determines at least one file format, according to mesh
Mark file format and download form.
The embodiments of the invention provide a kind of computer-readable recording medium, including execute instruction, when the computing device of storage control
During execute instruction, method that storage control performs above-described embodiment.
The embodiments of the invention provide a kind of storage control, including：Processor, memory and bus；
Memory is used to store execute instruction, and processor is connected with memory by bus, when storage control is run,
The execute instruction of computing device memory storage, so that the method that storage control performs above-described embodiment.
The contents such as the information exchange between each unit, implementation procedure in said apparatus, due to implementing with the inventive method
Example is based on same design, and particular content can be found in the narration in the inventive method embodiment, and here is omitted.
To sum up, each embodiment of the present invention at least has the effect that：
1st, in embodiments of the present invention, this method pre-sets stsndard SQL, and the stsndard SQL can ask with report generation
In report number, report name, parameter name and parameter type generation query SQL, the query SQL can look into database
Ask the form corresponding with report generation request.This method is repeated to write SQL without developer, it is possible to increase report generation is imitated
Rate.
It should be noted that herein, such as first and second etc relational terms are used merely to an entity
Or operation makes a distinction with another entity or operation, and not necessarily require or imply and exist between these entities or operation
Any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant be intended to it is non-
It is exclusive to include, so that process, method, article or equipment including a series of elements not only include those key elements,
But also the other element including being not expressly set out, or also include solid by this process, method, article or equipment
Some key elements.In the absence of more restrictions, by sentence " including the key element that a 〃 〃 " is limited, it is not excluded that
Other identical factor in the process including the key element, method, article or equipment also be present.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing program can be stored in computer-readable storage medium, the program
Upon execution, the step of execution includes above method embodiment；And foregoing storage medium includes：ROM, RAM, magnetic disc or light
Disk etc. is various can be with the medium of store program codes.
It is last it should be noted that：Presently preferred embodiments of the present invention is the foregoing is only, is merely to illustrate the skill of the present invention
Art scheme, is not intended to limit the scope of the present invention.Any modification for being made within the spirit and principles of the invention,
Equivalent substitution, improvement etc., are all contained in protection scope of the present invention.
Claims (6)
- A kind of 1. report form generation method, it is characterised in that standard Structured Query language SQL is pre-set, in addition to：The report generation request that form platform is sent is received, wherein, the report generation request includes：Report number, form Title, parameter name and parameter type；According to the report number, the report name, the parameter name, the parameter type and the stsndard SQL, it is determined that Query SQL；Inquired about using the query SQL in database, generate form；The form is sent to the form platform, so that the form platform receives and shows the form.
- A kind of 2. report generation device, it is characterised in that including：Setting unit, for setting standard Structured Query language SQL；Receiving unit, for receiving the report generation request of form platform transmission, wherein, the report generation request includes： Report number, report name, parameter name and parameter type；Generation unit, for the report number, the report name, the parameter name received according to the receiving unit Claim, the stsndard SQL that the parameter type and the setting unit are set, determine query SQL；Existed using the query SQL Inquired about in database, generate form；Transmitting element, the form for the generation unit to be generated is sent to the form platform, so that the form Platform receives and shows the form.
- A kind of 3. report generating system, it is characterised in that including：Form platform and report generation device；The report generation device, for setting standard Structured Query language SQL；Receive the form that the form platform is sent Generation request, wherein, the report generation request includes：Report number, report name, parameter name and parameter type；Root According to the report number, the report name, the parameter name, the parameter type and the stsndard SQL, it is determined that inquiry SQL；Inquired about using the query SQL in database, generate form；The form is sent to the form platform；The form platform, for receiving and showing the form.
- 4. report generating system according to claim 3, it is characterised in thatThe form platform, it is further used for setting at least one file format；The user is received at least one text The destination file format determined in part form；The form is downloaded according to the destination file format；The file format, including：Excel or txt.
- 5. a kind of computer-readable recording medium, it is characterised in that including execute instruction, refer to when being performed described in the computing device of storage control When making, the method described in the storage control perform claim requirement 1.
- A kind of 6. storage control, it is characterised in that including：Processor, memory and bus；The memory is used to store execute instruction, and the processor is connected with the memory by the bus, when described When storage control is run, the execute instruction of memory storage described in the computing device, so that the storage control Method described in device perform claim requirement 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710820831.7A CN107609109A (en) | 2017-09-13 | 2017-09-13 | A kind of report form generation method, device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710820831.7A CN107609109A (en) | 2017-09-13 | 2017-09-13 | A kind of report form generation method, device and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107609109A true CN107609109A (en) | 2018-01-19 |
Family
ID=61063284
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710820831.7A Pending CN107609109A (en) | 2017-09-13 | 2017-09-13 | A kind of report form generation method, device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107609109A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664236A (en) * | 2018-05-08 | 2018-10-16 | 山东浪潮通软信息科技有限公司 | A kind of automatic conversion based on Excel executes the implementation method of parametrization SQL |
| CN109240242A (en) * | 2018-10-24 | 2019-01-18 | 合肥中科离子医学技术装备有限公司 | Distributed superconducting magnet coil control system and its method for generating data sheet |
| CN110795475A (en) * | 2019-09-24 | 2020-02-14 | 金蝶软件（中国）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN110851173A (en) * | 2019-11-18 | 2020-02-28 | 中国银行股份有限公司 | Report generation method and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030004930A1 (en) * | 2001-06-29 | 2003-01-02 | International Business Machines Corporation | Software and method for performing database operations |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
-
2017
- 2017-09-13 CN CN201710820831.7A patent/CN107609109A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030004930A1 (en) * | 2001-06-29 | 2003-01-02 | International Business Machines Corporation | Software and method for performing database operations |
| CN102368261A (en) * | 2011-10-14 | 2012-03-07 | 成都勤智数码科技有限公司 | Expandable running maintenance report generation method |
| CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
| CN103744891A (en) * | 2013-12-23 | 2014-04-23 | 大唐软件技术股份有限公司 | Method and system for data query |
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108664236A (en) * | 2018-05-08 | 2018-10-16 | 山东浪潮通软信息科技有限公司 | A kind of automatic conversion based on Excel executes the implementation method of parametrization SQL |
| CN109240242A (en) * | 2018-10-24 | 2019-01-18 | 合肥中科离子医学技术装备有限公司 | Distributed superconducting magnet coil control system and its method for generating data sheet |
| CN110795475A (en) * | 2019-09-24 | 2020-02-14 | 金蝶软件（中国）有限公司 | Report generation method and device, computer equipment and storage medium |
| CN110851173A (en) * | 2019-11-18 | 2020-02-28 | 中国银行股份有限公司 | Report generation method and device |
| CN110851173B (en) * | 2019-11-18 | 2023-11-14 | 中国银行股份有限公司 | Report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107609109A (en) | A kind of report form generation method, device and system | |
| CN102810057B (en) | A kind of method of log | |
| US8712965B2 (en) | Dynamic report mapping apparatus to physical data source when creating report definitions for information technology service management reporting for peruse of report definition transparency and reuse | |
| US7363315B2 (en) | Creating, editing, and displaying hierarchical data structures associated with data in a data source | |
| CN109446218A (en) | SQL statement generation method, device and computer readable storage medium | |
| US20110055807A1 (en) | Integration environment generator | |
| AU2015331025A1 (en) | Emulating manual system of filing using electronic document and electronic file | |
| JP2005500560A5 (en) | ||
| CN108228119A (en) | Method of printing, terminal device and storage medium based on HXML | |
| CN102576354A (en) | Extensible framework to support different deployment architectures | |
| CN110292775A (en) | Obtain the method and device of variance data | |
| JP2008536210A (en) | Module application for mobile data systems | |
| JP2007149096A (en) | Data element naming system and method | |
| US8108768B2 (en) | Improving efficiency of content rule checking in a content management system | |
| Roelofs | AIMMS 3. 10 Language Reference | |
| US8949785B2 (en) | Custom compound types in declarative programs | |
| CN102222278A (en) | Operation process customizing method and device | |
| US20170308378A1 (en) | Application server and computer readable storage medium for generating project specific configuration data | |
| CN108829395A (en) | A kind of signal-oriented driver code automatic generation method and device | |
| US8862637B2 (en) | Generating data access operations based on a data model using a data services model | |
| US20090192859A1 (en) | System for performing schedule management, schedule management method and program | |
| CN110162299A (en) | Web program and its Quick Development Framework, development approach and relevant device | |
| CN109408092A (en) | Method and device, storage medium and the electronic equipment of front end version publication | |
| CN106856441A (en) | VIM systems of selection and device in NFVO | |
| US11663199B1 (en) | Application development based on stored data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180119 |
|
| RJ01 | Rejection of invention patent application after publication |