CN107480262A - A kind of general management system of database based on webpage - Google Patents
A kind of general management system of database based on webpage Download PDFInfo
- Publication number
- CN107480262A CN107480262A CN201710704296.9A CN201710704296A CN107480262A CN 107480262 A CN107480262 A CN 107480262A CN 201710704296 A CN201710704296 A CN 201710704296A CN 107480262 A CN107480262 A CN 107480262A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- name
- tables
- displaying
- 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
- 230000008676 import Effects 0.000 claims abstract description 11
- 230000004048 modification Effects 0.000 claims abstract description 11
- 238000012986 modification Methods 0.000 claims abstract description 11
- 238000012217 deletion Methods 0.000 claims abstract description 8
- 230000037430 deletion Effects 0.000 claims abstract description 8
- 238000000034 method Methods 0.000 claims description 16
- 230000008569 process Effects 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 5
- 238000010276 construction Methods 0.000 claims description 3
- 238000012797 qualification Methods 0.000 claims 3
- 230000000007 visual effect Effects 0.000 claims 1
- 238000007726 management method Methods 0.000 abstract description 17
- 238000007792 addition Methods 0.000 abstract description 13
- 238000013523 data management Methods 0.000 abstract description 5
- 239000002775 capsule Substances 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 12
- 238000003780 insertion Methods 0.000 description 6
- 230000037431 insertion Effects 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 101100075995 Schizosaccharomyces pombe (strain 972 / ATCC 24843) fma2 gene Proteins 0.000 description 3
- 238000003491 array Methods 0.000 description 3
- 101150064138 MAP1 gene Proteins 0.000 description 2
- 230000006378 damage Effects 0.000 description 2
- 238000004321 preservation Methods 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005538 encapsulation Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002203 pretreatment Methods 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is a kind of general management system of the database based on webpage, belongs to data bank network management domain.It is characterized in that being based on webpage, by browser, data can be carried out and checked, while there is addition, deletion, modification, revocation, conditional information retrieval, data export and batch import function, realize the management for data.When accessing tables of data, system first obtains the displaying name of the table as gauge outfit from the background.It is configured without showing that the field of name is not shown.After front end data container loads gauge outfit, to backstage request data, it is loaded into data capsule.The system data management function is performed sql sentences using JDBC modes and realized by java backstages connection database.The system carries out management data table by two tables in database:Data table information, content be each to be shown tables of data displaying name, table name;Tables of data dictionary, content are the field and field name that each tables of data will externally be shown.
Description
Technical field:
The present invention relates to data bank network management domain, the general management system of more particularly to a kind of database based on webpage
System, suitable for database is checked and managed online by webpage.
Background technology:
Generally, administrative staff are managed using customer end/server mode to database.Administrative staff are by using visitor
Family end software conducts interviews to the database in server, carries out additions and deletions to specific tables of data and look into the operation such as to change.Such behaviour
Client software is relied on as mode, high is required to objective device hardware, while there is regular hour and limitation spatially.
Faithfully reconnoitre, in the case of ground observation, administrative staff are not easy contact and are provided with client software, have access consideration
Computer equipment, it is difficult to database is conducted interviews whenever and wherever possible with management operate.
Another method is then that database is managed using Browser/Server Mode.Which is set to access
Standby hardware requirement is low, only to Web server request need to be submitted to can be achieved to access database by browser.However, currently deposit
In following deficiency:
1. function is single.Except checking data, in order to complete data base administration, addition, delete, inquire about, change and cancel
The function of data is essential.
2. ease for use is poor.Importing and exporting for high-volume data can not be carried out.
It is 3. maintainable poor.The web page files containing Table Header information must be built for the original creation of each data form, define the number
Backstage code according to table etc..Workload is big, and can cause code server redundancy, burden, be also unfavorable for increasing in the future, delete or
Change data table information.
4. whether uncontrollable specific field shows in a browser.
Therefore, a set of easily accessed, complete function, the convenient data management system of management configuration has important reality meaning
Justice.
The content of the invention:
For prior art defect, the present invention provides a kind of general management system of database based on webpage, have addition,
Deletion, modification, revocation, conditional information retrieval, data export and batch import function, it can be achieved all kinds of to tables of data progress based on webpage
Operation and management.The system is by whether the Chinese displaying name of configuration field is realized to field clear in tables of data dictionary
Look at and controlled shown in device.
A kind of general management system of database based on webpage, its content of the invention are as follows:
Pre-treatment, comprise the steps of:
1. establish table:Data table information, content be each to be shown tables of data displaying name, table name.
2. establish table:Tables of data dictionary, content are the field and field name that each tables of data will externally be shown.
3. establishing configuration file, content includes database access account, password, database access address, tables of data special topic
Information, the information of data table information.
4. creating conventional data displayed page, the page includes data display container, for showing Table Header information and data.
Display data table, step are as follows:
1. data table information, all tables of data for being available for accessing of displaying are read in front end.
2. user-selected number is according to table.
3. enter data form displayed page.
4. the data sheet field is obtained, field type and displaying name information, as gauge outfit.
5. front end data container loads Table Header information.
6. data capsule binding obtains the link of data.
7. request data table content and rowid.
8. loading result is to front end data container.
Database management function includes:
1. addition
1) user inputs each field contents in front end, and whether the content for verifying every input meets corresponding field type.
2) after confirming that all input contents meet the form of corresponding field type, it is submitted to backstage.
3) configuration file is read, connects database.
4) data type of each field in tables of data is inquired about.
5) each input content is converted to the class of corresponding field type.
6) sql orders are built.
7) perform.
2. delete
1) the data row to be deleted is selected.
2) rowid of the row to be deleted is obtained, is submitted to backstage.
3) configuration file is read, connects database.
4) sql orders are built, with rowid location data rows.
5) deletion is performed.
3. modification
1) rowid of the row to be changed is obtained.
2) user inputs each field contents in front end, and whether the content for verifying every input meets corresponding field type.
3) after confirming that all input contents meet the form of corresponding field type, it is submitted to backstage.
4) configuration file is read, connects database.
5) data type of each field in tables of data is inquired about.
6) each input content is converted to the class of corresponding field type.
7) sql orders are built, with rowid location data rows.
8) modification is performed.
4. revocation
If 1) modify operation, the data row original contents to be changed are recorded before operation.Destruction operation is performed, ought
Preceding data row is reduced to original contents.
If 2) be added operation, all addition contents are removed.
5. conditional information retrieval
1) Field Options, construction logic operator option are built according to Table Header information.
2) by selecting the process of field-selection logical operator-input content to add search condition one by one.
3) search condition is switched into sql sentences, is submitted to backstage.
4) configuration file is read, connects database.
5) search condition structure sql query statements are utilized.
6) inquiry is performed.
7) front end is returned to.
6. data export
1) current queries condition is obtained.
2) search condition is switched into sql sentences, is submitted to backstage.
3) configuration file is read, connects database.
4) search condition structure sql query statements are utilized.
5) field-displaying name relation of the table in tables of data dictionary is inquired about.
6) newly-built excel files.
7) sql query statements are built using search condition and performs inquiry.
8) excel gauge outfits are created:Traversal queries result field, row name is write successively in gauge outfit row:Name is shown for existing
Field, write-in displaying name, otherwise write field name.
9) all Query Results are write into excel files successively.
10) excel files are returned.
7. batch imports
1) data form file is obtained.
2) form document gauge outfit row is read.
3) configuration file is read, connects database.
4) data type of each field in tables of data is inquired about.
5) field-displaying name relation of the table in tables of data dictionary is inquired about.
6) gauge outfit row is traveled through, judges whether each row name is displaying name or true field name.If there is a row name to be discontented with
The foot condition, termination process, prompt the field that None- identified be present.
7) by 6), obtaining true field name corresponding to each gauge outfit row name in data form file.
8) log-on data storehouse batch performs command functions.
9) for every data line in data form file, each row is converted to the class of corresponding field type, built
Sql orders, added to pending command queue.
10) batch data insertion is performed.
The present invention has advantages below:
1. data display is simple and clear.Front end data table gauge outfit shows default field displaying name, should be readily appreciated that.
2. input content requirement is strict.When carrying out data addition and modification, user's input content can be verified, really
The form (such as date, numeral) for determining input content matching field types entail is just submitted to backstage.Ensure data accuracy, prevent
Erroneous input.
3. complete function.In addition to checking data content, also there is addition, deletion, modification, revocation, conditional information retrieval, number
According to export and batch import function, realize and each generic operation and management are carried out to tables of data based on webpage.
4. accessibility is good.The system is used by browser, requires low to device hardware.
5. size of code is small, succinctly.
6. interpolation data efficiency high, integrality is good.When carrying out batch data insertion, held due to enabling database batch
Line command function, one side operational efficiency are higher than performing sql orders one by one.On the other hand, if mistake, system meeting occurs in midway
It is automatic to perform rolling back action, be not in be difficult to determine that how many are ordered situation about being performed.
7. Auto-matching disparate databases field data types, and the content of text of input is switched into corresponding class, avoid
The mistake that data conversion is brought, suitable for the tables of data of any field type.
8. management is convenient.Data base administrator can increase in data table information, data table information is deleted or modified, real
Now to the management for the tables of data for being available for accessing.Meanwhile data base administrator can increase in tables of data dictionary, be deleted or modified
Tables of data shows name, determines whether a certain field shows in front end.
9. hommization.The system can be by adding search condition just data query, query statement displaying in plain text, user
It is very clear.Meanwhile the system can export full table data or export condition query the data obtained, be easy to user to check use.
It is 10. easy to operate.The system supports to use true field name as gauge outfit or the displaying name conduct of predefined field
Gauge outfit, or two ways mixing carry out batch importing.
Brief description of the drawings:
Fig. 1 functional block diagrams of the present invention.
Fig. 2 present invention checks data flowchart.
Fig. 3 present invention obtains Table Header information flow chart.
Fig. 4 interpolation data flow charts of the present invention.
Fig. 5 present invention modification data flowcharts.
Fig. 6 present invention deletes data flowchart.
Fig. 7 present invention revocation additions or modification data flowchart.
Fig. 8 condition query flow charts of the present invention.
Fig. 9 present invention batches import data flowchart.
Figure 10 present invention export data flowcharts.
Figure 11 checks data.
Figure 12 conditional information retrievals.
Figure 13 uploads form document and carries out batch importing.
Embodiment:
The present invention is a kind of general management system of the database based on webpage, and realization is looked into tables of data based on browser
See and be added, delete, changing, cancelling, the data management operations (accompanying drawing 1) that the export of conditional information retrieval, data imports with batch.
Java used below is elaborated as backstage language, JDBC as database manipulation mode to the present invention.
1. realization principle
Pretreatment part is illustrated first:
1) table is established:Data table information, content be each to be shown tables of data displaying name, table name.
2) table is established:Tables of data dictionary, content are the field and field name that each tables of data will externally be shown.
3) configuration file is established, content includes database access account, password, database access address.
4) conventional data displayed page is created, the page includes data display container, for showing Table Header information and data.
Secondly illustrate and check data flow (accompanying drawing 2):
1) data table information, all tables of data for being available for accessing of displaying are read in front end.
2) user selects the tables of data to be checked.
3) data form displayed page is entered.
4) data sheet field, field type and displaying name information are obtained, is encapsulated as JSON arrays (JSONArray), and
Rowid is added as row are hidden, using the JSON arrays as gauge outfit data.(accompanying drawing 3)
5) front end data container loads Table Header information.
6) data capsule binding obtains the link of data, and when user is checked, front end sends parameter to backstage, including
Number of pages, every page of display data number, sortord etc..
7) backstage obtains the query argument on foreground, as condition query tables of data content and the rowid of each data row.
8) the every data line for inquiring about gained is encapsulated as a JSON object, then the JSON object encapsulations of every a line is arrived
JSON arrays simultaneously return, and are loaded onto front end data container.
Then inquiry data sheet field name and field type flow are illustrated:
1) configuration file is read, connects database.
2) sql orders " select COLUMN_NAME, DATA_TYPE from all_tab_columns where are built
Table_name=' table names ' and owner=' tables user name ';”
3) inquiry is performed, Query Result is packaged into JSON objects in the form of " field name-field type " and returned.
Finally illustrate seven functional modules (accompanying drawing 1) of data management:
1) (accompanying drawing 4) is added:
It is except rowid each field sets up input frame in front end page.It is right after user completes content input
The input content of the field of special data type (such as numeral, date) is verified.If all input contents just will by verification
Input content is submitted to backstage.After backstage receives input content, first to data type, structure corresponding to each field of data base querying
Build insertion data sql orders " insert into table names (field 1, field 2 ...) values (,...) ", "" number
It is identical with field number.The PreparedStatement objects of database connection are obtained using sql orders.By input content by
Character string switchs to corresponding class, and according to different types of data, PreparedStatement objects are set using different set methods
Put data.Citing:SetDouble () method sets DOUBLE data types, and setTimestamp () method is set
TIMESTAMP and DATE data types.Finally perform.
2) (accompanying drawing 5) is changed:
It is except rowid each field sets up input frame after user selects a data in front end page.Input
Change content.After user completes content input, the input content of the field of special data type (such as numeral, date) is carried out
Verification.If input content and rowid are just submitted to backstage by all input contents by verification.Backstage receives input content
Afterwards, corresponding class is first switched to by character string to data type corresponding to each field of data base querying, then by input content.With addition
Operate similar, build sql orders " the update table name set fields 1=updated the data, field 2=……where rowid
=the rowid " submitted.The PreparedStatement objects of database connection are obtained using sql orders.According to different pieces of information
Type, PreparedStatement objects set data using different set methods.Finally perform.
3) (accompanying drawing 6) is deleted:
In front end page, user selects one or more data to be deleted, the rowid of the data is obtained, after being sent to
Platform." rowid " that delete from table name where rowid=are submitted, utilizes sql orders for the sql orders of structure deletion data
Obtain the PreparedStatement objects of database connection.Rowid is set, finally performed.
4) (accompanying drawing 7) is cancelled:
If modifying operation, the data row original contents to be changed are recorded before operation.Destruction operation is performed, will be current
Data row is reduced to original contents.If being added operation, all addition contents are removed.
5) conditional information retrieval (accompanying drawing 8):
After data form displayed page obtains Table Header information, Field Options, construction logic computing are built with Table Header information
Accord with option.User adds search condition one by one according to the process of " selection field-selection logical operator-input content ".Meanwhile
Search condition is converted into sql sentences.After user determines that search condition is errorless, sql sentences are submitted to backstage.Backstage obtains
After sql sentences, inquiry data flow is carried out with this condition.
6) data export (accompanying drawing 9):
Front end obtains current queries condition, and search condition is switched into sql sentences, is submitted to backstage.Backstage obtains sql languages
After sentence.Field-displaying name relation of the table in tables of data dictionary is inquired about, saves as map.Newly-built excel files, are entered with this condition
Row inquiry data flow, obtains Query Result resultSet.
Initially set up excel File Table Headers.All row names are obtained by resultSet.getMetaData ().For
Each row name, inquire about the row name whether in map by correspondingly showing name.Have, write-in shows name successively in excel files;
No, then row name is write.For each Query Result, each row are obtained using resultSet.getObject () successively
Data.Switch to String classes again, write excel files so that the corresponding Query Result of every a line in excel files.Most
After return to the excel files.
7) batch imports (accompanying drawing 10):
The function is divided into two stages:Field detects and insertion data.
A) field detects:
User uploads data form file in front end page.After backstage obtains, the first row is read as gauge outfit row, by gauge outfit
Capable content is read in list.The true field name in gauge outfit row items correspondence database is recorded with fieldList.Obtain again
Database information, database is connected, inquire about field-field type relation of the table in database, be placed in mapl;Inquire about tables of data
Field displaying name-field relation of the table, is placed in map2 in dictionary.For each single item in list, if map1 contains this,
FieldList adds this;Otherwise, if map2 contains this, that is, represent this for displaying name.Obtain true corresponding to the displaying name
Full word section, is added to fieldList.If all there is no this in map1, map2, then termination process.None- identified be present in this document
Field.Front end is returned to, prompts user, is terminated.
B) data are inserted:
After data form file is detected by field, then insertion data phase is carried out.Build sql orders " insert into
Table name (field 1, field 2 ...) values (,……)”.Wherein, "" number is fieldList length, " field i " is
I-th of fieldList.The PreparedStatement objects of database connection are obtained using sql orders.Turn-on data storehouse
Batch perform command functions.For every a line of data form file, according to different types of data, PreparedStatemen
T objects are that each field sets data using different set methods, then pass through PreparedStatement objects
Sql orders are added in pending sentence by addBatch () method.After all data rows have all been read, pass through
PreparedStatement objects executeBatch () method performs batch data insertion.
2. example
1) data (Figure 11) are checked
A) user selects form, checks data.
2) add
A) " addition " button is clicked on, input meets the content of call format, clicks on " preservation " button.
3) delete
A) the data row to be deleted, a line or multirow are selected, clicks on " deletion " button.
4) change
A) input meets the content of call format, clicks on " preservation " button.
5) cancel
A) during addition or modification, " revocation " button is clicked on.
6) conditional information retrieval
A) " conditional information retrieval " button is clicked on.
B) search condition is added one by one according to the process of " selection field-selection logical operator-input content ".
C) " submission " button is clicked on.
7) data export (Figure 12)
A) selection completely export or exported according to condition determined by " conditional information retrieval ".
B) click on " it is determined that " button.
C) form document derived from downloading.
8) batch imports (Figure 13)
A) " batch imports " button is clicked on, uploads data file.
B) after file is detected by field, data will be performed and imported.
Hereby it is achieved that being based on webpage, tables of data is checked, with including adding, deleting, changing, cancelling, condition examines
The data management function that rope, data export import with batch.
Claims (6)
- A kind of 1. general management system of database based on webpage, it is characterised in that:Based on webpage, line number can be entered by browser It is investigated that seeing, there is data addition to be imported with data modification, deletion, revocation, data qualification retrieval, data export and batch data, Realize checking and managing for data.
- 2. the general management system of a kind of database based on webpage according to claim 1, wherein, described data are checked It is characterised by:With tables of data dictionary, tables of data dictionary content is the displaying name and word that each tables of data will externally be shown Section name, determines the Table Header information of front end data, and the displaying star for configuring certain field shows the field data in front end.
- 3. the general management system of a kind of database based on webpage according to claim 1, wherein, the addition of described data It is characterised by with data modification:Field data types information is obtained before input content, to there is the field of special format requirement Input content format check is carried out, when all fields meet that call format can perform, otherwise requires that user changes input content; Backstage obtains the data submitted, and inquires about the data type of the affiliated field of each data, is switched to input content pair according to data type The data class answered, input value is set with corresponding set methods, realizes tables of data Auto-matching.
- 4. the general management system of a kind of database based on webpage according to claim 1, wherein, described data qualification Retrieval is characterised by:By gauge outfit displaying name structure Field Options, gauge outfit field is option value, construction logic computing option, with Logical operator is option value, and user is by selecting the process of field-selection logical operator-input content to add one by one in plain text Search condition, while sql sentences corresponding to plaintext search condition are obtained, as condition query data and return to front end displaying.
- 5. the general management system of a kind of database based on webpage according to claim 1, wherein, the export of described data It is characterised by:Search condition determined by being retrieved by data qualification inquires about data, and Query Result is exported;Obtain the table Field-displaying name relation, to show that name is visual and clear as data export gauge outfit, export.
- 6. the general management system of a kind of database based on webpage according to claim 1, wherein, described batch data Importing is characterised by:Data, which import file, can use displaying name or true field name as defined in tables of data dictionary simultaneously as table Head, from the background data are imported with file and carries out field verification, i.e., after user uploads data form file, to the every of form document gauge outfit One is detected, judge this whether be the table field name or displaying name, if this neither the true field of tables of data, Nor the displaying name of certain field, represents that this document gauge outfit is incorrect, terminates guiding flow;It is all logical for each single item in gauge outfit The data form file of field verification is crossed, inquires about the data type of the affiliated field of each data, according to data type by data form Content in file switchs to corresponding data class, sets input value with corresponding set methods, realizes automatic of data type Match somebody with somebody.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710704296.9A CN107480262A (en) | 2017-08-05 | 2017-08-05 | A kind of general management system of database based on webpage |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710704296.9A CN107480262A (en) | 2017-08-05 | 2017-08-05 | A kind of general management system of database based on webpage |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107480262A true CN107480262A (en) | 2017-12-15 |
Family
ID=60600692
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710704296.9A Pending CN107480262A (en) | 2017-08-05 | 2017-08-05 | A kind of general management system of database based on webpage |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107480262A (en) |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108228551A (en) * | 2018-01-08 | 2018-06-29 | 平安科技(深圳)有限公司 | Data lead-in method, device, equipment and the computer readable storage medium of excel |
CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo(重庆)智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
CN110928899A (en) * | 2019-11-29 | 2020-03-27 | 中孚安全技术有限公司 | Universal database backup method and system |
CN112417027A (en) * | 2020-11-19 | 2021-02-26 | 青岛以萨数据技术有限公司 | Data processing method, system, terminal and medium for visual operation database |
CN112487776A (en) * | 2020-12-07 | 2021-03-12 | 北京致远互联软件股份有限公司 | Report design method based on Portal designer |
CN114237511A (en) * | 2021-12-18 | 2022-03-25 | 杭州视洞科技有限公司 | Solution method for optimizing data based on Shardingsphere-JDBC |
CN115061612A (en) * | 2022-04-25 | 2022-09-16 | 杭州每刻科技有限公司 | Method for displaying detail components in full screen state |
CN115544006A (en) * | 2022-09-23 | 2022-12-30 | 北京上里科技文化有限公司 | General database data operation model and construction method thereof |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
JP2012048592A (en) * | 2010-08-30 | 2012-03-08 | Hitachi Solutions Ltd | File retrieval system having automatic index generation device for retrieval |
CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
CN104537129A (en) * | 2015-01-30 | 2015-04-22 | 中国地质大学(武汉) | Web based database virtual storage processing method |
-
2017
- 2017-08-05 CN CN201710704296.9A patent/CN107480262A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
CN101499162A (en) * | 2009-03-05 | 2009-08-05 | 唐文超 | Medical research data management system and method |
JP2012048592A (en) * | 2010-08-30 | 2012-03-08 | Hitachi Solutions Ltd | File retrieval system having automatic index generation device for retrieval |
CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
CN104537129A (en) * | 2015-01-30 | 2015-04-22 | 中国地质大学(武汉) | Web based database virtual storage processing method |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108228551A (en) * | 2018-01-08 | 2018-06-29 | 平安科技(深圳)有限公司 | Data lead-in method, device, equipment and the computer readable storage medium of excel |
CN108228551B (en) * | 2018-01-08 | 2021-02-05 | 平安科技(深圳)有限公司 | excel data import method, device, equipment and computer readable storage medium |
CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo(重庆)智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
CN110928899A (en) * | 2019-11-29 | 2020-03-27 | 中孚安全技术有限公司 | Universal database backup method and system |
CN110928899B (en) * | 2019-11-29 | 2023-06-20 | 中孚安全技术有限公司 | Universal database backup method and system |
CN112417027A (en) * | 2020-11-19 | 2021-02-26 | 青岛以萨数据技术有限公司 | Data processing method, system, terminal and medium for visual operation database |
CN112487776A (en) * | 2020-12-07 | 2021-03-12 | 北京致远互联软件股份有限公司 | Report design method based on Portal designer |
CN114237511A (en) * | 2021-12-18 | 2022-03-25 | 杭州视洞科技有限公司 | Solution method for optimizing data based on Shardingsphere-JDBC |
CN114237511B (en) * | 2021-12-18 | 2024-01-26 | 杭州视洞科技有限公司 | Solution method for data optimization based on SharingSphere-JDBC |
CN115061612A (en) * | 2022-04-25 | 2022-09-16 | 杭州每刻科技有限公司 | Method for displaying detail components in full screen state |
CN115061612B (en) * | 2022-04-25 | 2024-05-03 | 杭州每刻科技有限公司 | Display method of detail assembly in full screen state |
CN115544006A (en) * | 2022-09-23 | 2022-12-30 | 北京上里科技文化有限公司 | General database data operation model and construction method thereof |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107480262A (en) | A kind of general management system of database based on webpage | |
CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
US8510330B2 (en) | Configurable search graphical user interface and engine | |
US20180101621A1 (en) | Identifier vocabulary data access method and system | |
US9223817B2 (en) | Virtual repository management | |
US5832497A (en) | Electronic automated information exchange and management system | |
CN104361038B (en) | Improved search engine | |
US7979456B2 (en) | Method of managing and providing parameterized queries | |
US7251653B2 (en) | Method and system for mapping between logical data and physical data | |
US20170109454A1 (en) | Identifying an industry associated with a web page | |
CN111259303A (en) | System and method for automatically generating front-end page of WEB information system | |
US6448981B1 (en) | Intermediate user-interface definition method and system | |
CN109840257B (en) | Database query method, database query device, computer device and readable storage medium | |
US20010003455A1 (en) | Method, system and graphic user interface for entering and editing filter conditions for filtering a database | |
US20030158724A1 (en) | Agent system supporting building of electronic mail service system | |
US20080140694A1 (en) | Data transformation between databases with dissimilar schemes | |
US9020976B2 (en) | System and method for processing data in diverse storage systems | |
KR102034679B1 (en) | A data input/output system using grid interface | |
US20110246535A1 (en) | Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment | |
US20110022635A1 (en) | Method and System to Formulate Queries With Minivisuals | |
US20080263142A1 (en) | Meta Data Driven User Interface System and Method | |
US20060004693A1 (en) | Graphical user interface for exploring databases | |
US5940820A (en) | GUI apparatus for generating an object-oriented database application | |
US20060085492A1 (en) | System and method for modifying process navigation | |
US7861253B1 (en) | Systems and methods for accessing a business intelligence system through a business productivity client |
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 | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20171215 |