CN110018815A - Application development system and method based on database and spreadsheet software - Google Patents
Application development system and method based on database and spreadsheet software Download PDFInfo
- Publication number
- CN110018815A CN110018815A CN201910261697.0A CN201910261697A CN110018815A CN 110018815 A CN110018815 A CN 110018815A CN 201910261697 A CN201910261697 A CN 201910261697A CN 110018815 A CN110018815 A CN 110018815A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- designer
- user
- logic
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a kind of application development system and method based on database and spreadsheet software, the system includes: using designer, processor and database, it is used to construct the logical relation of data using designer, obtains the form document with logical relation；Processor, for managing and the logic of executive table file；Database, for storing the operating parameter applied in designer and processor, and storage user data.The present invention applies designer, processor and database by installation, it is authenticated to processor and using designer, logical design is carried out in application designer according to user demand and generates form document, and publication form document generates application and handled to obtain processing result to the data of database.The present invention can separate interface and logic, keep software design specialized, and good compatibility, convenient for the secondary development of application；Can cross-server operation, distributed computing, construct complicated applications, meet the different use demands of user.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of application based on database and spreadsheet software to open
Send out system and method.
Background technique
Currently, Excel office software has been rooted in the hearts of the people, automatic office function performance abundant is done to the daily of user
Public affairs life brings great convenience.But Excel file is a static file, cannot automatically to other Excel files into
Row association intercommunication will reach this functional purpose to constitute logic loops structure and branched structure, need carry out people repeatedly
For operation；The data in other computers are called, artificial repeatedly call is needed to transmit, the data of transmitting need artificial statistics toward contact
Adjustment is made a report on again, is not avoided that human error, is also increased workload.
In addition, the big data processing capacity of Excel office software is limited.And with big data storage and processing ability
The database software such as SQL, although can remotely access, its data processing is convenient not as good as Excel.
The application with database preparation function is developed using existing program means, generally requires structuring
Programming language, English and logical level to developer require relatively high；In the process of development, it is also necessary to edit very much
Variable is stored, developer is remembered and requires also very high, application and development threshold height；In addition, the data developed in the prior art
It automatically processes using closing is compared, is called by other application and generally require complicated interface language, do not have good compatibility.
The information system of engineering project is partial to data acquisition at present, and the data acquired need artificial multiple transmitting
It arranges, data utilization efficiency is low, and mistake is difficult to avoid that.Poor compatibility between each system cannot be effectively associated in intercommunication, and data are not only
It is heavy burden instead that wealth, which cannot be formed,.Meanwhile the life cycle of engineering project is short, each model of project management is also different
Sample, prior art means can not construct the comprehensive information system for extending to construction various aspects.
Therefore, it is necessary to design the application and development and data processing work of a kind of combination Excel office software and SQL database
Tool simplifies design logic, improves compatibility, realizes the association conducting between data.
Summary of the invention
The embodiment provides a kind of application development system and method based on database and spreadsheet software,
To solve the problems in above-mentioned background technique.
To achieve the goals above, this invention takes following technical solutions:
According to an aspect of the invention, there is provided a kind of application and development system based on database and spreadsheet software
System, which includes: using designer, processor and database；
Described applies designer, for constructing the logical relation of data, obtains the form document with logical relation；
The processor, for managing and executing the logic of the form document；
The database, for storing the operating parameter using in designer and the processor, and storage
User data.
Preferably, the system also includes form-oriented processor and data drivers；
The form-oriented processor carries out data cells to the tables of data for things to be described as tables of data
Change and mathematical logic is handled；
The data driver, it is interrelated for will be carried out between data.
Preferably, described to apply designer, comprising: logic is closed between circulation and branching logic relationship submodule and data
It is submodule；
The circulation and branching logic relationship submodule, for by setting data to the reference of database rule,
Data construct the logical relation of circulation and branch to the output rule of the database and the triggering rule of data；
Logical relation submodule between the data, for passing through function in spreadsheet software, order, macro or general patrol
The process of collecting, constructs the logical relation between data.
Preferably, the processor, comprising: management module and execution module；
The management module, for issuing and unloading the form document；
The execution module, comprising: logic implementation sub-module and logical operation submodule, the logic implementation sub-module are held
The row reference rule, output rule and triggering rule carry out the calling of data and execute the loop branches of data
Logical relation, the logical operation submodule execute the logical operation between data according to logical relation between the data.
Preferably, system further include: Web designer and Web server；
The Web designer, comprising: Web browser interface, interaction submodule one and interaction submodule two, the interaction
Submodule one is used to be arranged the interaction mode of the database Yu the Web browser interface, and the interaction submodule two is used for
The interaction mode at the Web browser interface and user is set；
The Web server, for the Web designer and the database to be carried out data interchange.
According to another aspect of the present invention, a kind of application and development side based on database and spreadsheet software is provided
Method, applied to the system, this method comprises:
Logic setting is carried out according to user demand, constructs the logical relation of data, generates form document；
The form document is issued as applying, according to the logical relation in the form document, to the use in database
User data carries out data processing and obtains processing result；
By processing result storage to database.
Preferably, described that logic setting is carried out according to user demand, the logical relation of data is constructed, table text is generated
Part, comprising:
Electrical form is established according to user demand, validated user data in electrical form are named and setup unit lattice
Type；
To have the user data delivery of name in the electrical form to database, the cell of no name as logic at
The temporary variable of reason；
The reference rule, output rule and triggering rule of data are set in the electrical form, and the reference is set
Priority between regular, the described output rule and the triggering rule；
Based on the logic rules of control field in database, the logical relation between data is set in the electrical form.
Preferably, described to be issued as applying by the form document, it is right according to the logical relation in the form document
User data in database carries out data processing and obtains processing result, comprising:
The form document is issued, corresponding application is generated, and synchronizes establish a number of results in the database
According to table；
The reference rule in the application is called, the user data in the database is inquired, is obtained to be processed
Tables of data；
According to the triggering rule, the data in the pending data table are increased, are deleted, changed handling；
According to the logical relation between the data, the data in the pending data table are handled to obtain processing knot
Fruit；
The output rule is added to the pending data table, the processing result in the pending data table is exported
To the result data table.
Preferably, this method further include: setting Web browser interface, setting database and the member in web browser interface
The interaction mode two of element and user in the interaction mode one of element, and setting web browser interface, forms webpage；
According to the interaction mode one, the data in the database are increased, are deleted, changed and looked into；
According to the interaction mode two, the page jump mode at the web browser interface and the operation of user are determined.
Preferably, this method further include: the application is authenticated, is obtained for being configured, issuing or unload
Corresponding authority.
As can be seen from the technical scheme provided by the above-mentioned embodiment of the present invention, the embodiment of the invention provides one kind to be based on
The application and development and data processing system of database and Excel, the system include: to answer using designer, processor and database
It is used to construct the logical relation of data with designer, obtains the form document with logical relation；Processor is for managing and holding
The logic of row form document；Database is used to store the operating parameter using in designer and processor, and storage number of users
According to.The present invention applies designer, processor and database by installation, authenticates to processor and using designer, according to
User demand carries out logical design in application designer and generates form document, and publication form document generates application to the number of database
According to being handled to obtain processing result.The present invention can separate interface and logic, keep software design specialized, and compatibility
It is good, convenient for the secondary development of application；Can cross-server operation, distributed computing, construct complicated applications, meet the difference of user
Use demand.
The additional aspect of the present invention and advantage will be set forth in part in the description, these will become from the following description
Obviously, or practice through the invention is recognized.
Detailed description of the invention
In order to illustrate the technical solution of the embodiments of the present invention more clearly, required use in being described below to embodiment
Attached drawing be briefly described, it should be apparent that, drawings in the following description are only some embodiments of the invention, for this
For the those of ordinary skill of field, without any creative labor, it can also be obtained according to these attached drawings other
Attached drawing.
Fig. 1 is a kind of showing for application development system based on database and spreadsheet software provided in an embodiment of the present invention
It is intended to；
Fig. 2 is a kind of reference rule schematic diagram of the data provided in an embodiment of the present invention from database；
Fig. 3 is a kind of triggering rule schematic diagram of data provided in an embodiment of the present invention；
Fig. 4 is a kind of application and development and data processing method based on database and Excel provided in an embodiment of the present invention
Process flow diagram；
Fig. 5 is a kind of application and development informatization platform system based on database and Excel provided in an embodiment of the present invention
Structural schematic diagram；
Fig. 6 is reference pattern schematic diagram used by a kind of addition reference rule that the embodiment of the present invention three provides；
Fig. 7 is to trigger pattern diagram used by a kind of addition triggering rule that the embodiment of the present invention three provides；
Fig. 8 is that the embodiment of the present invention four provides a kind of application and development based on database and Excel and data processing system
System structure chart；
Fig. 9 is reference pattern schematic diagram used by a kind of addition reference rule that the embodiment of the present invention four provides；
Figure 10 is to trigger pattern diagram used by a kind of addition triggering rule that the embodiment of the present invention four provides.
Specific embodiment
Embodiments of the present invention are described below in detail, the example of the embodiment is shown in the accompanying drawings, wherein from beginning
Same or similar element or element with the same or similar functions are indicated to same or similar label eventually.Below by ginseng
The embodiment for examining attached drawing description is exemplary, and for explaining only the invention, and is not construed as limiting the claims.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singular " one " used herein, " one
It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention
Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition
Other one or more features, integer, step, operation, element, component and/or their group.It should be understood that when we claim member
Part is " connected " or when " coupled " to another element, it can be directly connected or coupled to other elements, or there may also be
Intermediary element.In addition, " connection " used herein or " coupling " may include being wirelessly connected or coupling.Wording used herein
"and/or" includes one or more associated any cells for listing item and all combinations.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art
Language and scientific term) there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also
Understand, those terms such as defined in the general dictionary, which should be understood that, to be had and the meaning in the context of the prior art
The consistent meaning of justice, and unless defined as here, it will not be explained in an idealized or overly formal meaning.
In order to facilitate understanding of embodiments of the present invention, it is done by taking several specific embodiments as an example below in conjunction with attached drawing further
Explanation, and each embodiment does not constitute the restriction to the embodiment of the present invention.
Embodiment one
The application and development method based on database and spreadsheet software that the embodiment of the invention provides a kind of, by Excel
Table carries out data call in database software and is associated with intercommunication, realizes the comprehensive extension of information system.
The one side of the embodiment of the present invention provides a kind of application and development system based on database and spreadsheet software
System.
Spreadsheet software in the embodiment of the present invention can be the spreadsheet component in Microsoft OFFICE software
Electrical form etc. in Excel, domestic CCED (middle literal table software for editing), Kingsoft WPS, below by taking Excel as an example for
The bright embodiment of the present invention.
A kind of signal of application and development and data processing system based on database and Excel provided in an embodiment of the present invention
Figure is as shown in Figure 1, the system specifically includes that, using designer, processor and database, which, which is extended, to be arranged
Form-oriented processor, data driver, Web designer and Web server, the particular content of the system components is such as
Under:
(1) designer is applied
Using designer, comprising: logical relation submodule between circulation and branching logic relationship submodule and data；With
In the logical relation of construction data, the form document with logical relation is obtained.
A, circulation and branching logic relationship submodule
Circulation and branching logic relationship submodule, for reference rule, the data by setting data to the database
To the output rule of the database and the triggering rule of data, the logical relation of circulation and branch is constructed.
A kind of data provided in an embodiment of the present invention are from the reference rule schematic diagram of database as shown in Fig. 2, reference rule
In to the way of reference of data can using directly reference, directly be referred in small application and be used by the data of table a；It can also adopt
With indirect referencing, table b function is associated with table a, then table a is imported into small application, wherein the reference of table b relies on table a,
Table a quotes priority and is higher than table b.
A kind of triggering rule schematic diagram of data provided in an embodiment of the present invention is as shown in figure 3, to data in triggering rule
Triggering mode can be using synchronous triggering, asynchronous triggering or mixing triggering.Wherein, in mixing triggering, synchronization representation additions and deletions
Change is made all cause to trigger, and causes synchronous triggering when table a change；And cause asynchronous triggering when table a is newly-increased or deletes.
B, logical relation submodule between data
Logical relation submodule between data, for passing through the function in Excel spreadsheet, order, macro or generic logic
Process constructs the logical relation between data.
(2) processor
Processor, comprising: management module and execution module；For managing and executing the logic of the form document.
A, management module
Management module, for issuing and unloading the form document.The file formed after form document is issued can
It referred to as " applies " or " small application ".
B, execution module
Being logically divided into two layers for processor executive table file, it is corresponding with the submodule in form document.
Execution module, comprising: logic implementation sub-module and logical operation submodule, the logic implementation sub-module execute institute
Reference rule, output rule and triggering rule are stated, the calling of data is carried out and executes the loop branches logic of data
Relationship, the logical operation submodule execute the logical operation between data according to logical relation between the data.
(3) database
Database, for storing the operating parameter using in designer and the processor, and storage number of users
According to.
(4) form-oriented processor
Form-oriented processor, for things to be described as tables of data, to the tables of data carry out data cell format with
And mathematical logic processing.
(5) data driver
Data driver, it is interrelated for will be carried out between data.
(6) Web designer
Web designer, comprising: Web browser interface, interaction submodule one and interaction submodule two.
Submodule one is interacted, for the interaction mode of the database Yu the Web browser interface to be arranged.
Submodule two is interacted, for the interaction mode at the Web browser interface and user to be arranged.
(7) Web server
Web server, for the Web designer and the database to be carried out data interchange.
The another aspect of the embodiment of the present invention additionally provides a kind of application and development and data based on database and Excel
Processing method.
A kind of processing of application and development and data processing method based on database and Excel provided in an embodiment of the present invention
Flow chart as shown in figure 4, this method comprises:
S410: logic setting is carried out according to user demand, constructs the logical relation of data, generates form document.
Excel table is established according to user demand, validated user data in Excel table are named and setup unit lattice class
Type.
To have the user data delivery of name in the Excel table to database, the cell of no name as logic at
The temporary variable of reason.
The reference rule, output rule and triggering rule of data are set in the Excel table, and the reference rule are set
Then, the priority between the output rule and the triggering rule.
Based on the logic rules of control field in database, the logical relation between data is set in the Excel table.
S420: form document is issued as applying, according to the logical relation in form document, to the number of users in database
Processing result is obtained according to data processing is carried out.
The form document is issued, corresponding application is generated, and synchronizes establish a number of results in the database
According to table；
The reference rule in the application is called, the user data in the database is inquired, is obtained to be processed
Tables of data.
According to the triggering rule, the data in the pending data table are increased, are deleted, changed handling.
According to the logical relation between the data, the data in the pending data table are handled to obtain processing knot
Fruit.
The output rule is added to the pending data table, the processing result in the pending data table is exported
To the result data table.
S430: by processing result storage to database.
This method further include: setting Web browser interface, setting database are mutual with the element in web browser interface
The interaction mode two of element and user in flowing mode one, and setting web browser interface, forms webpage.According to described mutual
Flowing mode one is increased, is deleted, changed and is looked into the data in the database.According to the interaction mode two, the web is determined
The page jump mode of browser interface and the operation of user.
This method can also include: to authenticate to the application, obtain the correspondence for being configured, issuing or unload
Permission.
Embodiment two
The application and development informatization platform system and method based on database and Excel that this embodiment offers a kind of.
This embodiment offers a kind of structural representations of application and development informatization platform system based on database and Excel
Figure is as shown in figure 5, system includes: database, processor, using designer, web designer and web server.Wherein, data
Library, processor, using the function of designer as described in embodiment one, and by database root according to user need to be placed in local area network or
Wide area network accesses convenient for user.
Web designer is then used for the interaction mode of webpage in design database and user's web browser, and (data additions and deletions change
Look into), the interaction mode (page jump, user's operation permission etc.) of webpage and user in designing user web browser designs web
The web interface of browser, and by designed file distribution to web server, form webpage.
Web server completes the number of user's web browser and database for handling the design of web designer
According to intercommunication, operation of the user to webpage in web browser is completed.Web server need according to user need to be placed in local area network or
Wide area network accesses convenient for user.
The application and development informatization platform method based on database and Excel that this embodiment offers a kind of, including it is as follows
Step:
(1) it installs.Installation database, processor, using designer, web designer and web server.
(2) it authenticates.It is authenticated to processor, using designer, web designer and web server, obtains corresponding power
Limit.
(3) form document designs.Logical design is carried out according to user demand using designer (when design, to draw if necessary
With or be output to the databases of other data processing systems, need to carry out long-range certification), debug errorless, generate form document.
(4) publication of form document.Above table file is issued in the completion of processor designer, generates small application.
(5) webpage design.Web designer according in user demand design database and user's web browser webpage it is mutual
Flowing mode (data additions and deletions, which change, looks into), interaction mode (page jump, Yong Hucao of webpage and user in designing user web browser
Make permission etc.), the web interface of web browser is designed, and by designed file distribution to web server, form webpage.
(6) it uses.User operates above-mentioned webpage, if having caused the data movement of database, processor can be adjusted
With small application, data processing is carried out according to the design of step (3), while processing result is fed back into database.Above-mentioned webpage root
According to the interaction mode that step (5) are designed, by the data back handled well to user.
Embodiment three
This embodiment offers a kind of application and development and data processing method based on database and Excel, this method can
Wage is counted for payroll department, this method comprises:
Step 1: installation.Installation database, processor, using designer, web designer and web server；Wherein, number
It is installed together, is placed on public network according to library and web server, it is easily accessible, as data center.Processor, using designer
With web designer installation web designer on a PC, dedicated for data processing, as data processing centre.Payroll department
Designer is applied in one PC installation.
Step 2: certification.It authenticates, obtains corresponding to processor, using designer, web designer and web server
Permission.Wherein, the permission using designer of data processing centre can be used for designing, issue, unload.The application of payroll department
Designer is served only for designing, in this way can be convenient for all small applications of management.
Step 3: form document one designs.Payroll department establishes form document " ask for and terminate leave .xls ", and table domestic demand wants employee to fill out
The data of report name (such as: " [/ name /], [/ department /], [/ asking for leave the date /], [/ report back after leave of absence the date /] " etc.) and set should
The cell types of data (do not have in picture type excel, need to set " [/ field name //image/] " or " [/ field in this way
Name // picture /] "), wherein there are the data of name that can be transmitted to data center, nameless cell faces as logical process
Variations per hour.
Step 4: the publication of form document.The data processing centre " please sell above table file using designer
False .xls " is issued, and generates small application " asking for and terminating leave ", and database can establish a tables of data " ask for and terminate leave table ", word when publication
Section name is exactly the above-mentioned data name for having and naming.
Step 5: form document two designs.Payroll department establishes form document " wage .xls ".It is needed in table to employee's exhibition
The data shown name (such as: " [/ name /], [/ department /], [/ number of days/of turning out for work], [/ wage /] " etc.) and set the data
Place cell types (do not have in picture type excel, need to set in this way " [/ field name //image/] " or " [/ field name //
Picture /] "), wherein there are the data of name that can be transmitted to data center, interim change of the nameless cell as logical process
Amount.
Reference, output, triggering rule are designed in form document, and set the priority of reference, output, triggering.Its
In.Reference pattern used by addition reference rule is as shown in fig. 6, reference data table " ask for and terminate leave table ", reference priority default
It is 0, the smaller priority of numerical value is higher.Addition output is regular, then output data table " payroll "；Used by addition triggering rule
Triggering mode is as shown in fig. 7, the small application " wage " that then this design generates improves row triggering by the additions and deletions of " ask for and terminate leave table ".
Logical relation in form document between design data is turned out for work number of days according to the table that asks for and terminates leave, according to turning out for work
Number of days calculates employee compensation, wherein it should be noted that the logical design of control field, avoids the occurrence of endless loop or branch's control of mistake
Field processed, the control field and effect in database are as shown in table 1.
1 control field of table and effect table
Step 6: the publication of form document.The application designer of the data processing centre is to above table file " wage
.xls it " is issued, generates small application " wage ", as soon as database can establish a tables of data " payroll ", field name when publication
It is the above-mentioned data name for having and naming.
Step 7: webpage design.Web designer designs two menu buttons " asking for and terminating leave " according to user demand, and " wage is looked into
It sees ".Design button " asking for and terminating leave " jump to when clicking ask for and terminate leave make a report on the modification page, when design button " wage is checked " is clicked
Jump to the wage page.By designed file distribution to web server, webpage is formed.
Step 8: using.User operates above-mentioned webpage, and employee opens the webpage, makes a report on the information that asks for and terminates leave, mentions
After friendship, payroll department opens the webpage, checks the wage situation after the employee asks for and terminates leave.
Example IV
This embodiment offers a kind of application and developments based on database and Excel and data processing system and method, lead to
Design software interface element is crossed, interacts user with software interface.
This embodiment offers a kind of application and development based on database and Excel and data processing system as shown in figure 8,
It include: database, processor, using designer, software interface designer；Wherein, database, processor, using designer
With described in embodiment one, database needs to need to be placed in local area network or wide area network according to user function, accesses convenient for user.
Interaction mode of the software interface designer for design database and software interface element is (data inputting, deletion, defeated
Out, check), the interaction mode of design software interface and user (interface jump, operating right etc.), the Interface Element of design software
Plain (button, text box, picture box etc.), and by designed file distribution to database, the formation software interface list of elements (such as:
Button element table includes " appearance attribute field, event field, the operation field of user, system field etc. ").
This embodiment offers a kind of application and development and data processing method based on database and Excel, comprising:
Step 1, it installs.Installation database, processor, using designer, software interface designer.The embodiment is with single machine
For version, it is mounted on a PC by database, processor, using designer, software interface designer.It can also be by database
Cloud server is mounted on as data center, is mounted on a PC using processor and using designer as Data processing
The heart is mounted on application designer and software interface designer on the PC of developer.
Step 2, it authenticates.It is authenticated to processor, using designer, software interface designer, obtains corresponding permission.
Step 3, software interface designs.Entitled " the window of window elements is added at software interface designer design software interface
1 ", it adds button element " button 1 ", button element table may include " appearance attribute field, event field, operation field, system word
Section etc. "；The interaction mode (data inputting deletion, is exported, checked) of design database and software interface element monitors data
The field " content attribute field " of library interface element table " 1 table of window " just updates the interface element of software once changing
" window 1 "；The interaction mode of design database and software interface element " button 1 " acquires user's operation, when user click,
Single-click operation is updated into the field " operation field " to the database interface list of elements " 1 table of button ".Design software interface and user
Interaction mode (interface jump, operating right etc.), the interface element (button, text box, picture box etc.) of design software, and will
Designed file distribution is software, can form the software interface list of elements in database when publication.
Step 4, the design of form document.Logical design is carried out to interface element table according to user demand using designer,
When form document designs, the database of other data processing systems is quoted or be output to if necessary, needs to carry out long-range to recognize
Card.
Using designer design table (schedule) file " button 1 clicks .xls ".Reference in table, output, triggering rule are designed, and
Set the priority of reference, output, triggering: reference pattern such as Fig. 9 used by the addition reference rule that the embodiment provides
It is shown, reference data library " 1 table of window " and " 1 table of button "；Addition output rule, is output to " 1 table of window " and " 1 table of button "；
Triggering mode used by the addition triggering rule that the embodiment provides is as shown in Figure 10, and the small application that the design generates is by " pressing
The change of 1 table of button " triggers.Field " the operational word of logical relation in design table (schedule) between data, i.e. database side " 1 table of button "
Section " indicates when clicking, the field " content attribute field " cumulative 1 of " 1 table of window ", then field " the operational word of " 1 table of button "
Section " resetting, pay attention to the logical design of control field, avoid the occurrence of endless loop or mistake Branch control field, control field and
Effect is as shown in table 1.When the resetting of the field " operation field " of " 1 table of button " in this table, field " automatic trigger " need to be set
It is 0, pressure does not trigger any operation in next step, endless loop otherwise occurs.Debug errorless, generation form document.
Step 5, the publication of form document.Above table file is issued in the completion of processor designer, generates small answer
With " button 1 is clicked ".
Step 6, the downloading certification of software.User downloads the software of software interface designer design, and is authenticated.
Step 7, it uses.User clicks the element interface " button 1 " of the software of above-mentioned certification, and the software is by user
Operation data, pass to database.The interface element " window 1 " of software shows the total degree clicked.
Processor calls small application, according to the design of step 4, handles data, at the same will treated data feedback to counting
According to library.The software is according to the interaction mode of design, by the data back after database processing to user.
In conclusion the embodiment of the present invention is by providing a kind of application and development and data based on database and Excel
Processing system, the system include: to close using designer, processor and database using the logic that designer is used to construct data
System obtains the form document with logical relation；Processor is for managing and the logic of executive table file；Database is for depositing
Storage is using the operating parameter in designer and processor, and storage user data.The present invention is by installation using designer, place
Device and database are managed, is authenticated to processor and using designer, logic is carried out in application designer according to user demand and is set
Family planning issues form document generation application and is handled to obtain processing result to the data of database at form document.The present invention
Interface and logic can be separated, keep software design specialized, and good compatibility, convenient for the secondary development of application；It can be across clothes
Business device operation, distributed computing construct complicated applications, meet the different use demands of user.
Those of ordinary skill in the art will appreciate that: attached drawing is the schematic diagram of one embodiment, module in attached drawing or
Process is not necessarily implemented necessary to the present invention.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for device or
For system embodiment, since it is substantially similar to the method embodiment, so describing fairly simple, related place is referring to method
The part of embodiment illustrates.Apparatus and system embodiment described above is only schematical, wherein the conduct
The unit of separate part description may or may not be physically separated, component shown as a unit can be or
Person may not be physical unit, it can and it is in one place, or may be distributed over multiple network units.It can root
According to actual need that some or all of the modules therein is selected to achieve the purpose of the solution of this embodiment.Ordinary skill
Personnel can understand and implement without creative efforts.
The foregoing is only a preferred embodiment of the present invention, but scope of protection of the present invention is not limited thereto,
In the technical scope disclosed by the present invention, any changes or substitutions that can be easily thought of by anyone skilled in the art,
It should be covered by the protection scope of the present invention.Therefore, protection scope of the present invention should be with scope of protection of the claims
Subject to.
Claims (10)
1. a kind of application development system based on database and spreadsheet software, which is characterized in that the system includes: to apply to set
Gauge, processor and database；
Described applies designer, for constructing the logical relation of data, obtains the form document with logical relation；
The processor, for managing and executing the logic of the form document；
The database, for storing the operating parameter using in designer and the processor, and storage user
Data.
2. system according to claim 1, which is characterized in that the system also includes: form-oriented processor and data
Driver；
The form-oriented processor, for things to be described as tables of data, to the tables of data carry out data cell format with
And mathematical logic processing；
The data driver, it is interrelated for will be carried out between data.
3. system according to claim 2, which is characterized in that described to apply designer, comprising: circulation and branching logic close
It is logical relation submodule between submodule and data；
The circulation and branching logic relationship submodule, for reference rule, the data by setting data to the database
To the output rule of the database and the triggering rule of data, the logical relation of circulation and branch is constructed；
Logical relation submodule between the data, for passing through the function in spreadsheet software, order, macro or generic logic mistake
Journey constructs the logical relation between data.
4. system according to claim 3, which is characterized in that the processor, comprising: management module and execution module；
The management module, for issuing and unloading the form document；
The execution module, comprising: logic implementation sub-module and logical operation submodule, the logic implementation sub-module execute institute
Reference rule, output rule and triggering rule are stated, the calling of data is carried out and executes the loop branches logic of data
Relationship, the logical operation submodule execute the logical operation between data according to logical relation between the data.
5. system according to claim 4, which is characterized in that the system further include: Web designer and Web server；
The Web designer, comprising: Web browser interface, interaction submodule one and interaction submodule two, the interaction submodule
Block one is used to be arranged the interaction mode of the database Yu the Web browser interface, and the interaction submodule two is for being arranged
The interaction mode at the Web browser interface and user；
The Web server, for the Web designer and the database to be carried out data interchange.
6. a kind of application and development method based on database and spreadsheet software is applied to described in any one of claim 1-5
System, which is characterized in that this method comprises:
Logic setting is carried out according to user demand, constructs the logical relation of data, generates form document；
The form document is issued as applying, according to the logical relation in the form document, to the number of users in database
Processing result is obtained according to data processing is carried out；
By processing result storage to database.
7. according to the method described in claim 6, it is characterized in that, described carry out logic setting, construction according to user demand
The logical relation of data generates form document, comprising:
Electrical form is established according to user demand, validated user data in electrical form are named and setup unit lattice class
Type；
There to be the user data delivery of name to database in the electrical form, the cell of no name is as logical process
Temporary variable；
The reference rule, output rule and triggering rule of data are set in the electrical form, and be arranged the reference it is regular,
Priority between the output rule and the triggering rule；
Based on the logic rules of control field in database, the logical relation between data is set in the electrical form.
8. the method according to the description of claim 7 is characterized in that described be issued as applying by the form document, according to
Logical relation in the form document carries out data processing to the user data in database and obtains processing result, comprising:
The form document is issued, corresponding application is generated, and synchronizes establish a result data table in the database；
The reference rule in the application is called, the user data in the database is inquired, pending data is obtained
Table；
According to the triggering rule, the data in the pending data table are increased, are deleted, changed handling；
According to the logical relation between the data, the data in the pending data table are handled to obtain processing result；
The output rule is added to the pending data table, the processing result in the pending data table is output to institute
State result data table.
9. according to the method described in claim 8, it is characterized in that, this method further include: setting Web browser interface, setting
Element and user in the interaction mode one of element in database and web browser interface, and setting web browser interface
Interaction mode two, formed webpage；
According to the interaction mode one, the data in the database are increased, are deleted, changed and looked into；
According to the interaction mode two, the page jump mode at the web browser interface and the operation of user are determined.
10. according to the method described in claim 9, it is characterized in that, this method further include: authenticate, obtain to the application
It takes in the corresponding authority for being configured, issuing or unloading.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910261697.0A CN110018815A (en) | 2019-04-02 | 2019-04-02 | Application development system and method based on database and spreadsheet software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910261697.0A CN110018815A (en) | 2019-04-02 | 2019-04-02 | Application development system and method based on database and spreadsheet software |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110018815A true CN110018815A (en) | 2019-07-16 |
Family
ID=67190415
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910261697.0A Pending CN110018815A (en) | 2019-04-02 | 2019-04-02 | Application development system and method based on database and spreadsheet software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110018815A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112711933A (en) * | 2020-12-31 | 2021-04-27 | 深轻(上海)科技有限公司 | Method for checking life insurance actuarial model by using spreadsheet |
| CN113435171A (en) * | 2021-07-23 | 2021-09-24 | 安徽澜深软件开发有限公司 | Interpretation execution system of data statistical logic of code-free data filling |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5883623A (en) * | 1992-04-08 | 1999-03-16 | Borland International, Inc. | System and methods for building spreadsheet applications |
| CN102063306A (en) * | 2011-01-06 | 2011-05-18 | 夏春秋 | Technical implementation method for application development through electronic form |
| CN103207783A (en) * | 2013-03-02 | 2013-07-17 | 赵宝生 | Software development engine system based on browser/server mode and building method thereof |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
| CN106020793A (en) * | 2016-05-09 | 2016-10-12 | 统通信（苏州）有限公司 | A method for rapid form building in an iOS platform application development process |
| CN107729008A (en) * | 2017-09-28 | 2018-02-23 | 武汉创客空间信息管理有限公司 | A kind of method based on electrical form rapid build management information system |
-
2019
- 2019-04-02 CN CN201910261697.0A patent/CN110018815A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5883623A (en) * | 1992-04-08 | 1999-03-16 | Borland International, Inc. | System and methods for building spreadsheet applications |
| CN102063306A (en) * | 2011-01-06 | 2011-05-18 | 夏春秋 | Technical implementation method for application development through electronic form |
| CN103631570A (en) * | 2012-08-21 | 2014-03-12 | 镇江雅迅软件有限责任公司 | Form self-definition method |
| CN103207783A (en) * | 2013-03-02 | 2013-07-17 | 赵宝生 | Software development engine system based on browser/server mode and building method thereof |
| CN106020793A (en) * | 2016-05-09 | 2016-10-12 | 统通信（苏州）有限公司 | A method for rapid form building in an iOS platform application development process |
| CN107729008A (en) * | 2017-09-28 | 2018-02-23 | 武汉创客空间信息管理有限公司 | A kind of method based on electrical form rapid build management information system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112711933A (en) * | 2020-12-31 | 2021-04-27 | 深轻(上海)科技有限公司 | Method for checking life insurance actuarial model by using spreadsheet |
| CN113435171A (en) * | 2021-07-23 | 2021-09-24 | 安徽澜深软件开发有限公司 | Interpretation execution system of data statistical logic of code-free data filling |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110989983B (en) | Zero-coding application software rapid construction system | |
| CN105549982B (en) | A kind of development of automation platform based on model configuration | |
| US8478602B2 (en) | Executing business processes using persistent variables | |
| EP1665033B1 (en) | Cross-platform development for devices with heterogeneous capabilities | |
| CN110069335A (en) | Task processing system, method, computer equipment and storage medium | |
| US20080209392A1 (en) | Systems and Methods for Definition and Execution of Batch Processing Services | |
| CN106796526A (en) | JSON Stylesheet Language Transformations | |
| CN113692582A (en) | User interface for establishing data privacy pipeline and contract agreement to share data | |
| CN103425462A (en) | Method and device for workflow data persistence | |
| Ellis et al. | Computer science and office information systems | |
| CN104615617A (en) | Dispatch monitoring information processing system for substation equipment | |
| CN106022007A (en) | Cloud platform system and method oriented to biological omics big data calculation | |
| Souri et al. | Formal modeling and verification of a service composition approach in the social customer relationship management system | |
| US20080155518A1 (en) | Methods and apparatus for tokenizing workflow process objects | |
| CN113824764A (en) | Robot process automation system based on cloud native architecture and operation method | |
| CN110018815A (en) | Application development system and method based on database and spreadsheet software | |
| US8463755B2 (en) | System and method for providing collaborative master data processes | |
| CN113468149B (en) | Data model development platform | |
| CN111027284A (en) | Standardized output method based on flexible data access | |
| CN102023859A (en) | Digital development environment-oriented software integration method with reliability, maintainability and supportability | |
| US10505873B2 (en) | Streamlining end-to-end flow of business-to-business integration processes | |
| CN116011943A (en) | Robot automation flow service system, method and medium based on low codes | |
| CN112241367B (en) | Data line testing method and device | |
| US20210312299A1 (en) | Ai connector module | |
| Chen | Web service based mobile worker supporting system for construction industry applications |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190716 |