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 PDF

Info

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
Application number
CN201710704296.9A
Other languages
Chinese (zh)
Inventor
周翠英
张国豪
杜子纯
刘镇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sun Yat Sen University
Original Assignee
Sun Yat Sen University
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Sun Yat Sen University filed Critical Sun Yat Sen University
Priority to CN201710704296.9A priority Critical patent/CN107480262A/en
Publication of CN107480262A publication Critical patent/CN107480262A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, 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

A kind of general management system of database based on webpage
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)

  1. 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. 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. 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. 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. 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. 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.
CN201710704296.9A 2017-08-05 2017-08-05 A kind of general management system of database based on webpage Pending CN107480262A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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