CN108628887A - A kind of method and system obtaining list data - Google Patents
A kind of method and system obtaining list data Download PDFInfo
- Publication number
- CN108628887A CN108628887A CN201710167050.2A CN201710167050A CN108628887A CN 108628887 A CN108628887 A CN 108628887A CN 201710167050 A CN201710167050 A CN 201710167050A CN 108628887 A CN108628887 A CN 108628887A
- Authority
- CN
- China
- Prior art keywords
- data
- interface
- project
- data structure
- party database
- 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.)
- Withdrawn
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
- G06Q50/205—Education administration or guidance
Abstract
The present invention relates to data processing field more particularly to a kind of method and system obtaining list data.The project that the present invention includes by configuration form；Identification third party database corresponding with the project；Identify the initial data structure of data in the third party database；Obtain the data structure translation interface that the convertible initial data structure is XML format data；It is data acquisition interface to encapsulate the data source access interface of the third party database and the data structure translation interface；The data acquisition interface is executed, the corresponding data of the project are obtained.It realizes and is directed to different application scenarios, fast implement the interface for obtaining list data, improve development efficiency.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of method and system obtaining list data.
Background technology
Curriculum schedule is the essential auxiliary tool of teaching process, uses the object of curriculum schedule and setting for display school timetable
It is standby numerous.Using curriculum schedule personnel such as：Student, teacher, class management personnel, laboratory room managing personnel, school administrator,
Row class personnel, teaching supervise and examine personnel etc..The presentation device of curriculum schedule is such as：Computer, mobile phone, tablet, TV, large screen, papery are beaten
Printed document etc..
Currently, when carrying out data organization to curriculum schedule, specific relational database usually is established according to different system, with
The bivariate table structure of relational database carrys out a group organization data；In display data, also frequently with two-dimensional table form；Therefore, program
Member needs to write the related data of different code organization curriculum schedules according to different application scenarios, and development efficiency is relatively low, to different
The adaptability of structure data source is poor, is unfavorable for software repeated usage.
Invention content
The technical problem to be solved by the present invention is to：A kind of method and system obtaining list data are provided, for difference
Application scenarios, fast implement obtain list data interface, improve development efficiency.
In order to solve the above-mentioned technical problem, the technical solution adopted by the present invention is：
The present invention provides a kind of method obtaining list data, including：
The project that configuration form includes；
Identification third party database corresponding with the project；
Identify the initial data structure of data in the third party database；
Obtain the data structure translation interface that the convertible initial data structure is XML format data；
It is data acquisition to encapsulate the data source access interface of the third party database and the data structure translation interface
Interface；
The data acquisition interface is executed, the corresponding data of the project are obtained.
The present invention also provides a kind of systems obtaining list data, including：
First configuration module, the project for including for configuration form；
First identification module, for identification third party database corresponding with the project；
Second identification module, for identification in the third party database data initial data structure；
Acquisition module connects for obtaining the data structure conversion that the convertible initial data structure is XML format data
Mouthful；
Package module, data source access interface and data structure conversion for encapsulating the third party database connect
Mouth is data acquisition interface；
Execution module obtains the corresponding data of the project for executing the data acquisition interface.
The beneficial effects of the present invention are：The present invention is by providing a kind of general list data acquisition methods so that journey
Sequence person is not necessarily to write acquisition table according to the data source with different data structure or the data source from different third party databases
The code of lattice data is realized and is directed to different application scenarios, and the interface for obtaining list data is fast implemented, and improves development efficiency.
Description of the drawings
Fig. 1 is a kind of flow diagram of the specific implementation mode of method obtaining list data provided by the invention；
Fig. 2 is a kind of structure diagram of the specific implementation mode of system obtaining list data provided by the invention；
Fig. 3 is a kind of further structural frames of the specific implementation mode of system obtaining list data provided by the invention
Figure；
Label declaration：
1, the first configuration module；2, the first identification module；3, the second identification module；4, acquisition module；
5, package module；6, execution module；7, generation module；8, add module；
9, the second configuration module；10, third configuration module.
Specific implementation mode
To explain the technical content, the achieved purpose and the effect of the present invention in detail, below in conjunction with embodiment and coordinate attached
Figure is explained.
The design of most critical of the present invention is：The present invention is realized by providing a kind of general list data acquisition methods
For different application scenarios, the interface for obtaining list data is fast implemented, improves development efficiency.
Fig. 1 to Fig. 3 is please referred to,
As shown in Figure 1, the present invention provides a kind of method obtaining list data, including：
The project that configuration form includes；
Identification third party database corresponding with the project；
Identify the initial data structure of data in the third party database；
Obtain the data structure translation interface that the convertible initial data structure is XML format data；
It is data acquisition to encapsulate the data source access interface of the third party database and the data structure translation interface
Interface；
The data acquisition interface is executed, the corresponding data of the project are obtained.
Further, further include：
The table is generated according to the project and the corresponding data of the project.
Seen from the above description, the efficiency for generating table corresponding with different application scene is improved.
Further, further include：
The title of the data acquisition interface and the table is added to configuration file.
Seen from the above description, when that need to generate the table comprising identical items next time, it is right in configuration file only to call
The data acquisition interface answered improves the efficiency for obtaining list data.
Further, further include：
Configuration data source access interface corresponding with the third party database.
Seen from the above description, by extending the data source access interface of third party database, more third parties can be obtained
Data in database, so that the data acquisition interface that the method provided through the invention obtains is applicable to more answer
Use scene.
Further, further include：
Configure the data structure translation interface that the convertible initial data structure is XML format data.
Seen from the above description, by extended data structure translation interface, further types of data structure can be converted to
XML format data, to improve compatibility of the data acquisition interface to isomeric data.
As shown in Fig. 2, the present invention also provides a kind of systems obtaining list data, including：
First configuration module 1, the project for including for configuration form；
First identification module 2, for identification third party database corresponding with the project；
Second identification module 3, for identification in the third party database data initial data structure；
Acquisition module 4 connects for obtaining the data structure conversion that the convertible initial data structure is XML format data
Mouthful；
Package module 5, the data source access interface for encapsulating the third party database and data structure conversion
Interface is data acquisition interface；
Execution module 6 obtains the corresponding data of the project for executing the data acquisition interface.
Further, further include：
Generation module 7, for generating the table according to the project and the corresponding data of the project.
Further, further include：
Add module 8, for adding the title of the data acquisition interface and the table to configuration file.
Further, further include：
Second configuration module 9, for configuring data source access interface corresponding with the third party database.
Further, further include：
Third configuration module 10, for configuring the data structure that the convertible initial data structure is XML format data
Translation interface.
The embodiment of the present invention one is：
The project that S1, configuration form include；
Wherein, the table is made of the curriculum information in one term of student, and the project which includes has academic year
Term, student number, name, cycle, week, section, place name, teacher's name and course name；
S2, identification third party database corresponding with the project；Specially：
S21, project set is obtained according to the project；
Wherein, according to predefined project aggregate information it is found that student number and name belong to student's project set, teacher's name
Belong to teacher's project set, course name belongs to course project set, and place name belongs to place project set of attending class, cycle and
Belong to time started in term project set week, section belongs to class period project set；Term academic year is predefined project
One of set comprising term number, term title, Start Date and Close Date project；Project set information is XML lattice
Formula data；
S22, identification third party database corresponding with the project set；
Wherein, third party's data source mainly has standard relationship SQL database, such as Mysql, SqlServer, Oracle,
The general-purpose interfaces such as ODBC, OLEDB, JDBC may be used in its access interface；In addition, third party's data source can also be connect by service
Mouthful mode provides, and such as WebService modes, access interface is provided by http https agreements, and data format can be with
It is provided using JSON or XML；
S3, configuration data source access interface corresponding with the third party database；
It wherein, can be by predefined if not searching data source access interface corresponding with the third party database
Expansion interface configure relevant data source access interface；
The initial data structure of data in S4, the identification third party database；Configure the convertible initial data knot
Structure is the data structure translation interface of XML format data；Obtain the number that the convertible initial data structure is XML format data
According to structure translation interface；
Wherein, if not searching the data structure translation interface that the convertible initial data structure is XML format data,
Relevant data structure translation interface then can be configured by predefined expansion interface；Currently, having been configured with bivariate table structure
Data are converted to the data structure translation interface of XML format data；
S5, the data source access interface of the encapsulation third party database and the data structure translation interface obtain for data
Take interface；
S6, the data acquisition interface is executed, obtains the corresponding data of the project；According to the project and the project
Corresponding data generate the table, as shown in the table：
S7, the title of the data acquisition interface and the table is added to configuration file.
Seen from the above description, the project that user need to be included only according to business demand configuration form, you can automatically according to
The project that table is included obtains corresponding data from multiple third party databases, and will be from different third party databases
Heterogeneous data source is converted to same data format, and the project data corresponding with its for including further according to table, which automatically generate, meets industry
The table of business demand so that be directed to different application scene, the program of table is automatically generated without overlapping development, improve exploitation effect
Rate；Meanwhile the data from different third party databases are converted into XML format data, convenient for subsequent inquiry, modification or number
It is operated according to verification；Furthermore additionally provide the expansion interface of configurable data structure translation interface and data source access interface so that
List data acquisition methods provided by the invention are applicable to more application scenarios.
The embodiment of the present invention two is：
As shown in figure 3, the project that 1 configuration form of the first configuration module includes；First identification module 2 identifies and the project
Corresponding third party database；If the interface for being not present in current system and data in the third party database being obtained,
The second configuration module 9 is called to configure data source access interface corresponding with the third party database；Second identification module 3 identifies
The initial data structure of data in the third party database；If the convertible initial data structure is not present in current system
For the interface of XML format data, then it is XML format number to call third configuration module 10 to configure the convertible initial data structure
According to data structure translation interface；Acquisition module 4 obtains the data knot that the convertible initial data structure is XML format data
Structure translation interface；Package module 5 encapsulates the data source access interface of the third party database and data structure conversion connects
Mouth is data acquisition interface；Execution module 6 executes the data acquisition interface, obtains the corresponding data of the project；Generate mould
Block 7 generates the table according to the project and the corresponding data of the project；Add module 8 adds the data acquisition interface
With the title of the table to configuration file.
In conclusion the method and system provided by the invention for obtaining list data, by providing a kind of general table
Data capture method so that programmer is not necessarily to according to the data source with different data structure or comes from different third party databases
Data source write the code for obtaining list data, realize and be directed to different application scenarios, fast implement and obtain list data
Interface improves development efficiency.Further, the efficiency for generating table corresponding with different application scene is improved.Further, when
When next time need to generate the table comprising identical items, corresponding data acquisition interface in configuration file only need to be called, is improved
Obtain the efficiency of list data.Further, by extending the data source access interface of third party database, more the can be obtained
Data in three party databases, so that the data acquisition interface that the method provided through the invention obtains is applicable to more
Application scenarios.Further, by extended data structure translation interface, further types of data structure can be converted to XML
Formatted data, to improve compatibility of the data acquisition interface to isomeric data.
Example the above is only the implementation of the present invention is not intended to limit the scope of the invention, every to utilize this hair
Equivalents made by bright specification and accompanying drawing content are applied directly or indirectly in relevant technical field, include similarly
In the scope of patent protection of the present invention.
Claims (10)
1. a kind of method obtaining list data, which is characterized in that including：
The project that configuration form includes；
Identification third party database corresponding with the project；
Identify the initial data structure of data in the third party database；
Obtain the data structure translation interface that the convertible initial data structure is XML format data；
It is data acquisition interface to encapsulate the data source access interface of the third party database and the data structure translation interface；
The data acquisition interface is executed, the corresponding data of the project are obtained.
2. the method according to claim 1 for obtaining list data, which is characterized in that further include：
The table is generated according to the project and the corresponding data of the project.
3. the method according to claim 1 for obtaining list data, which is characterized in that further include：
The title of the data acquisition interface and the table is added to configuration file.
4. the method according to claim 1 for obtaining list data, which is characterized in that further include：
Configuration data source access interface corresponding with the third party database.
5. the method according to claim 1 for obtaining list data, which is characterized in that further include：
Configure the data structure translation interface that the convertible initial data structure is XML format data.
6. a kind of system obtaining list data, which is characterized in that including：
First configuration module, the project for including for configuration form；
First identification module, for identification third party database corresponding with the project；
Second identification module, for identification in the third party database data initial data structure；
Acquisition module, for obtaining the data structure translation interface that the convertible initial data structure is XML format data；
Package module, data source access interface and the data structure translation interface for encapsulating the third party database are
Data acquisition interface；
Execution module obtains the corresponding data of the project for executing the data acquisition interface.
7. the system according to claim 6 for obtaining list data, which is characterized in that further include：
Generation module, for generating the table according to the project and the corresponding data of the project.
8. the system according to claim 6 for obtaining list data, which is characterized in that further include：
Add module, for adding the title of the data acquisition interface and the table to configuration file.
9. the system according to claim 6 for obtaining list data, which is characterized in that further include：
Second configuration module, for configuring data source access interface corresponding with the third party database.
10. the system according to claim 6 for obtaining list data, which is characterized in that further include：
Third configuration module connects for configuring the data structure conversion that the convertible initial data structure is XML format data
Mouthful.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710167050.2A CN108628887A (en) | 2017-03-20 | 2017-03-20 | A kind of method and system obtaining list data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710167050.2A CN108628887A (en) | 2017-03-20 | 2017-03-20 | A kind of method and system obtaining list data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108628887A true CN108628887A (en) | 2018-10-09 |
Family
ID=63687710
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710167050.2A Withdrawn CN108628887A (en) | 2017-03-20 | 2017-03-20 | A kind of method and system obtaining list data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108628887A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1439131A (en) * | 2000-04-27 | 2003-08-27 | 网上技术公司 | Method and system for retrieving search results from multiple disparate databases |
| US7707168B2 (en) * | 2004-01-14 | 2010-04-27 | Agency For Science, Technology And Research | Method and system for data retrieval from heterogeneous data sources |
| CN101957747A (en) * | 2009-07-17 | 2011-01-26 | 浙江省公众信息产业有限公司 | Method for customizing form |
| CN104216952A (en) * | 2014-08-20 | 2014-12-17 | 烽火通信科技股份有限公司 | Universal report generation method and universal report generation system based on XML (extensive markup language) technology |
| CN104573115A (en) * | 2015-02-04 | 2015-04-29 | 新余兴邦信息产业有限公司 | Method and system for achieving integration interface supporting operation of multi-type databases |
| CN104778285A (en) * | 2015-05-12 | 2015-07-15 | 成都广达电子股份有限公司 | XML-based WEB service system and working method thereof |
| CN106066871A (en) * | 2016-05-30 | 2016-11-02 | 中国人民解放军装备学院 | A kind of multiple and distributing sources access method based on open interface |
-
2017
- 2017-03-20 CN CN201710167050.2A patent/CN108628887A/en not_active Withdrawn
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1439131A (en) * | 2000-04-27 | 2003-08-27 | 网上技术公司 | Method and system for retrieving search results from multiple disparate databases |
| US7707168B2 (en) * | 2004-01-14 | 2010-04-27 | Agency For Science, Technology And Research | Method and system for data retrieval from heterogeneous data sources |
| CN101957747A (en) * | 2009-07-17 | 2011-01-26 | 浙江省公众信息产业有限公司 | Method for customizing form |
| CN104216952A (en) * | 2014-08-20 | 2014-12-17 | 烽火通信科技股份有限公司 | Universal report generation method and universal report generation system based on XML (extensive markup language) technology |
| CN104573115A (en) * | 2015-02-04 | 2015-04-29 | 新余兴邦信息产业有限公司 | Method and system for achieving integration interface supporting operation of multi-type databases |
| CN104778285A (en) * | 2015-05-12 | 2015-07-15 | 成都广达电子股份有限公司 | XML-based WEB service system and working method thereof |
| CN106066871A (en) * | 2016-05-30 | 2016-11-02 | 中国人民解放军装备学院 | A kind of multiple and distributing sources access method based on open interface |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| TWI748175B (en) | Data processing method, device and equipment | |
| US10127507B2 (en) | Project management system providing interactive issue creation and management | |
| CN103106188B (en) | The graphical analytic system of data model and graphical analytical approach | |
| CN101727324B (en) | Code generation method and device | |
| CN104778241A (en) | Report generation method and system | |
| CN105045775A (en) | Method and apparatus for generating Excel document in designated format | |
| CN104331284A (en) | Method and system for generating and displaying dynamic page | |
| CN105512265A (en) | Method and device for displaying data through figure | |
| CN104657384A (en) | Dynamic allocation report data processing method based on two-dimension relationship | |
| CN103176802B (en) | Realize the method that the user interface UI of system separates with widget library by control pond | |
| CN101976199A (en) | Object-oriented middleware distributed system development platform | |
| CN103914307A (en) | Interactive-interface fast implementation method based on reusable library | |
| WO2015154474A1 (en) | Query interface generation method and device | |
| CN107402766A (en) | Page layout management method and device | |
| CN102567334A (en) | Office automation system based on heterogeneous data | |
| CN103347079A (en) | Method and mobile device for schedule event synchronization | |
| CN103064916A (en) | Emin DI data integration engine and report generation method | |
| CN110069247A (en) | A kind of development approach and device, application method and device of application program | |
| CN113467972A (en) | Communication interface construction method, communication interface construction device, computer equipment and storage medium | |
| CN108628887A (en) | A kind of method and system obtaining list data | |
| CN105468570B (en) | A kind of document synthesis methods of exhibiting and device | |
| CN106470278A (en) | A kind of generation method of application affairs and device | |
| CN103729455A (en) | Master data storage method based on primary copy storage pattern | |
| CN111126946A (en) | Modeling method and device for data tracing of information system | |
| WO2016201813A1 (en) | Dynamic layout method and system based on android |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20181009 |
|
| WW01 | Invention patent application withdrawn after publication |