CN104537129A - Web based database virtual storage processing method - Google Patents
Web based database virtual storage processing method Download PDFInfo
- Publication number
- CN104537129A CN104537129A CN201510050980.0A CN201510050980A CN104537129A CN 104537129 A CN104537129 A CN 104537129A CN 201510050980 A CN201510050980 A CN 201510050980A CN 104537129 A CN104537129 A CN 104537129A
- Authority
- CN
- China
- Prior art keywords
- virtual relation
- record
- relation table
- name
- virtual
- 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.)
- Granted
Links
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/25—Integrating or interfacing systems involving database management systems
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual 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 invention discloses a web based database virtual storage processing method. The web based database virtual storage processing method comprises the following steps: designing and building a database; creating and deploying the Web engineering by use of the Web technology, and dynamically linking the database to realize Web site access; carrying out adding, deletion, amendment or inquiry to the information of a virtual relationship table on a browser webpage; and carrying out adding, deletion, amendment or inquiry, which are recorded in the virtual relationship table of the database, on the browser webpage. According to the method, the database can be subjected to virtual storage processing on the webpage, and the authority limit problem that a new database table, a revised database table, and recording in the new managing user database table cannot be provided to a user in the Web browser in the Web engineering can be solved, the Web site capacity can be improved, the interaction of the user and a background and the user and the data base can be enhanced, and the web site is enabled to have good user experience.
Description
Technical field
The present invention relates to a kind of database virtual store disposal route of sing on web, belong to database technical field.
Background technology
Along with the fast development of internet, WWW also develops rapidly thereupon, and changeable user's request and data type will seriously restrict the progress of Web project development, and fixing database is difficult to meet changeable user's request.Therefore often need in project the field of operationally dynamic establishment table and dynamic Maintenance Table even show and show between relation, and dynamic creation and management database relation table can improve the performance of Web site on webpage, strengthen the mutual of user and backstage and database.
Current Java Web technology, based on the OO programming idea of Java, a corresponding JavaBean object can be set up for each relation table in database in exploitation, use ORM (Object Relation Mapping simultaneously, Object Relation Mapping) framework technology, make to form mapping relations between this object and relation table, like this, an example of each object in fact just represents a record of its mapping table, and backstage is exactly by realizing operating the data in relation table to the operation of these examples.
But for prior art, although JDBC (Java Data BaseConnectivity can be used in Web engineering, java DataBase combining), the technology production Methods table in a database such as Hibernate, but JavaBean corresponding to relation table to as if automatically cannot be generated by program coding, JavaBean object corresponding to relation table normally the project development stage artificial write or use the artificial reverse generation of developing instrument.Due to opening relationships corresponding JavaBean object cannot be shown, therefore backstage cannot obtain the instance objects corresponding to newly-built relation table, then the record in newly-built relation table and relation table simply can not being increased, delete, change, look into operation, must operate relation table by writing sql statement.This just requires that user is proficient in sql statement knowledge, obviously can not meet the demand of most of user.
Summary of the invention
In order to solve the deficiencies in the prior art, the invention provides a kind of database virtual store disposal route of sing on web, user can be made by record in the virtual management database relation table of webpage and relation table, greatly enhance user and the mutual dirigibility of database, effective performance improving Web site, has realistic meaning and practical value.
The technical scheme that the present invention adopts for its technical matters of solution is: the database virtual store disposal route providing a kind of sing on web, for processing virtual relation table, described virtual relation table and user wish the relation table created, and specifically comprise the following steps:
(1) building database, database comprises master meter and tables from table two;
The field of described master meter comprises table name, field name, start field sequence number and stops field sequence number; Wherein table name is used for the title of storing virtual relation table, table name is the major key of master meter, field name is used for the title of all fields of storing virtual relation table, separate with separator between different field, start field sequence number, for marking the ordinal number of first character section in field name, stops field sequence number for marking the ordinal number of last field in field name;
The described field from table comprises sequence number, table name and more than 1 field, and wherein sequence number is the major key from table, and table name is the external key associated from table and master meter, and more than 1 field is used for the record of storing virtual relation table;
(2) use Web technology to create, dispose Web engineering, connection data storehouse, realizes the access to Web site in Web engineering;
(3) carry out on the webpage of browser virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table increases newly: the page preset at browser submits the newly-increased request of virtual relation table to, and virtual relation table increases table name and the field name that request comprises virtual relation table to be increased newly newly, jumps to backstage; Backstage obtains virtual relation table information by http agreement, verifies table name, if the title of virtual relation table exists in master meter, then prompting amendment table name resubmits, if the title of virtual relation table does not exist in master meter, then verifies field name; If field name form meets preset requirement, then give the instance objects assignment that master meter is corresponding, use Hibernate to insert the record of virtual relation table information to master meter;
Virtual relation list deletion: preset the page at browser and submit the request of virtual relation list deletion to, the request of virtual relation list deletion comprises the table name of virtual relation table to be deleted, jump to backstage, backstage obtains table name by http agreement, the virtual relation table of identical table name whether is there is in inquiry master meter, if exist, delete all records from table with identical table name, then delete the record of identical table name in master meter, finally return to foreground and refresh browser page;
Virtual relation table is revised: the page preset at browser submits virtual relation table amendment request to, virtual relation table amendment request comprises the table name of virtual relation table to be modified, jump to backstage, backstage obtains virtual relation table table name to be modified by http agreement, there is in inquiry master meter the record of identical table name, this record is reached foreground webpage show, foreground webpage is preserved after modifying to this record, jump to that verification table name in backstage is whether unique and form is correct, if then use Hibernate to upgrade the record of this table name in master meter, if not then return foreground webpage prompting user to remodify rear preservation,
Virtual relation table is inquired about: the page preset at browser submits virtual relation table inquiry request to, the request of virtual relation table comprises querying condition, jump to backstage, backstage gets querying condition by http agreement, generate corresponding hql statement according to querying condition, use Hibernate to perform hql statement, traversal queries result, Query Result assignment to instance objects corresponding to master meter, then by http agreement, instance objects is passed to foreground web displaying;
(4) carry out on the webpage of browser the record in database virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table record increases newly: the page preset at browser submits the newly-increased request of virtual relation table record to, virtual relation table record increases the table name that request comprises the virtual relation table treating newly-increased record newly, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, then the record of this virtual relation table in master meter is inquired about, Query Result assignment to instance objects corresponding to master meter, instance objects is passed to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain the title of all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, user submits to after filling in newly-increased virtual relation table record, jump to backstage, backstage gets newly-increased record by http agreement, and carry out assignment to the instance objects from table is corresponding, then Hibernate is used to insert record to from table,
Virtual relation table record is deleted: the page preset at browser submits virtual relation table record removal request to, virtual relation table record removal request comprises the table name of the virtual relation table of record to be deleted, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then inquire about master meter and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, instance objects is passed to foreground webpage, webpage splits the field name of instance objects corresponding to master meter, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, choose wall scroll to be deleted or many records to submit to and confirm removal request, jump to backstage, backstage gets the sequence number of record to be deleted by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to delete, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is revised: the page preset at browser submits virtual relation table record amendment request to, virtual relation table record amendment request comprises the table name of the virtual relation table of record to be modified, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then this virtual relation table in master meter is inquired about, inquire about the record therefrom with identical table name simultaneously, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, revise each bar record respectively, submit the request of preservation to, jump to backstage, backstage gets amended record by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to modify operation, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is inquired about: the page preset at browser submits virtual relation table record inquiry request to, virtual relation table record inquiry request comprises the table name of the virtual relation table of record to be checked, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly.
Database described in step (1) is SQL Server 2008 database.
In step (2), Web engineering is disposed by following steps, connection data storehouse, realize the access to Web site in Web engineering: under Java Integrated Development Environment, create Web engineering, use Tomcat as Web server, with Eclipse developing instrument, Web engineering is packaged into war wrap and be deployed on Web server, starts server, to realize utilizing browser to the access of issuing engineering; Utilize Hibernate framework technology that Web engineering and database are carried out dynamic link.
The present invention is based on the beneficial effect that its technical scheme has to be: the present invention real removes newly-built relation table in a database, but store by the master meter existed in database the basic structure information that user wishes the relation table (being called virtual relation table) created, user can be made by record in the virtual management database relation table of webpage and relation table, realize " the increasing newly " of on the webpage of browser, carrying out virtual relation table, " deletion ", " amendment " or " inquiry " operates, and the webpage of browser carries out the record in database virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry " operates, solve and be difficult to provide " newly-built (self-defined in other words) database table " to user in Web engineering, " Update Table database table structure ", the problem of the authority of " record in the table of leading subscriber newdata storehouse ", improve Web site performance, strengthen the mutual of user and backstage and database, make Web site can have better Consumer's Experience, greatly enhance user and the mutual dirigibility of database, effective performance improving Web site, have realistic meaning and practical value.
Embodiment
Below in conjunction with embodiment, the invention will be further described.
The invention provides a kind of database virtual store disposal route of sing on web, for processing virtual relation table, described virtual relation table and user wish the relation table created, and specifically comprise the following steps:
(1) building database, database comprises master meter and tables from table two; Described database can be SQLServer 2008 database.
The field of described master meter comprises table name, field name, start field sequence number and stops field sequence number; Wherein table name is used for the title of storing virtual relation table, table name is the major key of master meter, field name is used for the title of all fields of storing virtual relation table, separate with separator between different field, start field sequence number, for marking the ordinal number of first character section in field name, stops field sequence number for marking the ordinal number of last field in field name;
The described field from table comprises sequence number, table name and more than 1 field, and wherein sequence number is the major key from table, and table name is the external key associated from table and master meter, and more than 1 field is used for the record of storing virtual relation table;
Table 1 and table 2 respectively illustrate master meter and the data dictionary from table:
| Field name | Data type | Length | Allow empty | Major key | Annotation |
| tableName | varchar | 100 | not null | PK | Table name |
| startColumn | int | not null | Start field | ||
| endColumn | int | not null | Stop field | ||
| columnName | varchar | Max | not null | Field name |
The data dictionary of table 1 master meter
Wherein, tableName, startColumn, endColumn and colummName are respectively table name, start field sequence number, stop field sequence number and field name.
| Field name | Data type | Length | Allow empty | Major key | Annotation |
| id | int | PK | id | ||
| tableName | varchar | 100 | not null | FK | Table name |
| column1 | varchar | 200 | null | Field 1 | |
| column2 | varchar | 200 | null | Field 2 | |
| column3 | varchar | 200 | null | Field 3 | |
| … | varchar | 200 | null | … | |
| column250 | varchar | 200 | null | Field 250 |
Table 2 is from the data dictionary of table
Wherein, id is sequence number, and tableName is table name, and column1, column2, column3 to column250 are field 1 to field 250.
In the present invention so-called sing on web database virtual store disposal route be in fact meant to be not that real dynamic creation of going in a database is newly shown, but the basic structure information of storing virtual relation table is carried out by the master meter " TableInfor " existed in database, essential information comprises table name, start field, stop field, field name, and want the record left in virtual relation table to be all stored in from table " TableData " all users, in " TableData " table, arrange " tableName " is external key, retrained by this external key and must exist in master meter " TableInfor " from " tableName " of the record table " TableData "." columnName " field in master meter is used to the field name of storing virtual relation table, user-defined all field names is connected into a character string by " | " symbolic link and is stored in table." startColumn " and " endColumn " field in master meter be by split that " columnName " obtain rise, only field sequence number, they represent in its corresponding virtual relation table be recorded in from table " TableData " which field that uses, for the sake of simplicity, all fields of default setting User Defined are varchar data type.
Below by the storage data instance in these two tables, the present invention is explained, table 3 and table 4 be respectively master meter " TableInfor " with from the storage data instance shown " TableData ".
| tableName | startColumn | endColumn | columnName | … |
| A | 1 | 2 | Name | student number | |
| B | 1 | 3 | Province | counties and cities | district | |
| C | 1 | 3 | Name | the age | the birthday | |
| D | 1 | 4 | School | institute | class | student number | |
| … | … | … | … |
The storage data instance of table 3 master meter
| id | tableName | column1 | column2 | column3 | column4 | … | column250 |
| 1 | A | Zhang San | 124611026 | ||||
| 2 | A | Li Si | 124611063 | ||||
| 3 | B | Hubei | Wuhan | Jiangxia District | |||
| 4 | B | Hunan | Changsha | Yuelu District | |||
| 5 | C | King five | 23 | 19930214 | |||
| 6 | C | Zhao six | 27 | 19870412 | |||
| 7 | … | … | … | … | … | … | … |
Table 4 is from the storage data instance of table
Table 3 can be found out, the start field sequence number of virtual relation Table A is 1, stopping field sequence number is 2, field is called " name | student number ", the value being meant to column1 in the record that in table 4, " tableName " is A is the value of " name " field in virtual relation Table A, and the value of column2 is the value of " student number " field in virtual relation Table A; Equally, the start field sequence number of virtual relation table B is 1, stopping field sequence number is 3, field is called " province | counties and cities | district ", the value being meant to column1 in the record that " tableName " is B from table is the value of " province " field in virtual relation table B, the value of column2 is the value of " counties and cities " field in virtual relation table B, and the value of column3 is the value of " district " field in virtual relation table B.
(2) under Java Integrated Development Environment, Web engineering is created, use Tomcat as Web server, with Eclipse developing instrument, Web engineering is packaged into war wrap and be deployed on Web server, starts server, to realize utilizing browser to the access of issuing engineering; Utilize Hibernate framework technology and sqljdbc4.jar bag that Web engineering and database are carried out dynamic link;
(3) carry out on the webpage of browser virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table increases newly: the page preset at browser submits the newly-increased request of virtual relation table to, and virtual relation table increases table name and the field name that request comprises virtual relation table to be increased newly newly, jumps to backstage; Backstage obtains virtual relation table information by http agreement, verifies table name, if the title of virtual relation table exists in master meter, then prompting amendment table name resubmits, if the title of virtual relation table does not exist in master meter, then verifies field name; If field name form meets preset requirement, then give the instance objects assignment that master meter is corresponding, use Hibernate to insert the record of virtual relation table information to master meter;
Virtual relation list deletion: preset the page at browser and submit the request of virtual relation list deletion to, the request of virtual relation list deletion comprises the table name of virtual relation table to be deleted, jump to backstage, backstage obtains table name by http agreement, the virtual relation table of identical table name whether is there is in inquiry master meter, if exist, delete all records from table with identical table name, then delete the record of identical table name in master meter, finally return to foreground and refresh browser page;
Virtual relation table is revised: the page preset at browser submits virtual relation table amendment request to, virtual relation table amendment request comprises the table name of virtual relation table to be modified, jump to backstage, backstage obtains virtual relation table table name to be modified by http agreement, there is in inquiry master meter the record of identical table name, this record is reached foreground webpage show, foreground webpage is preserved after modifying to this record, jump to that verification table name in backstage is whether unique and form is correct, if then use Hibernate to upgrade the record of this table name in master meter, if not then return foreground webpage prompting user to remodify rear preservation,
Virtual relation table is inquired about: the page preset at browser submits virtual relation table inquiry request to, the request of virtual relation table comprises querying condition, jump to backstage, backstage gets querying condition by http agreement, generate corresponding hql statement according to querying condition, use Hibernate to perform hql statement, traversal queries result, Query Result assignment to instance objects corresponding to master meter, then by http agreement, instance objects is passed to foreground web displaying;
(4) carry out on the webpage of browser the record in database virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table record increases newly: the page preset at browser submits the newly-increased request of virtual relation table record to, virtual relation table record increases the table name that request comprises the virtual relation table treating newly-increased record newly, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, then the record of this virtual relation table in master meter is inquired about, Query Result assignment to instance objects corresponding to master meter, instance objects is passed to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain the title of all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, intend relation table structure as shown in the table:
| B | Province | Counties and cities | District |
Table 5 virtual relation list structure
User submits to after filling in newly-increased virtual relation table record, jumps to backstage, and backstage gets newly-increased record by http agreement, and carries out assignment to the instance objects from table is corresponding, then uses Hibernate to insert record to from table;
Virtual relation table record is deleted: the page preset at browser submits virtual relation table record removal request to, virtual relation table record removal request comprises the table name of the virtual relation table of record to be deleted, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then inquire about master meter and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, instance objects is passed to foreground webpage, webpage splits the field name of instance objects corresponding to master meter, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, choose wall scroll to be deleted or many records to submit to and confirm removal request, jump to backstage, backstage gets the sequence number of record to be deleted by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to delete, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is revised: the page preset at browser submits virtual relation table record amendment request to, virtual relation table record amendment request comprises the table name of the virtual relation table of record to be modified, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then this virtual relation table in master meter is inquired about, inquire about the record therefrom with identical table name simultaneously, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, revise each bar record respectively, submit the request of preservation to, jump to backstage, backstage gets amended record by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to modify operation, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is inquired about: the page preset at browser submits virtual relation table record inquiry request to, virtual relation table record inquiry request comprises the table name of the virtual relation table of record to be checked, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly.
Described instance objects is JavaBean instance objects.
Claims (4)
1. a database virtual store disposal route for sing on web, is characterized in that for processing virtual relation table, and described virtual relation table and user wish the relation table created, and specifically comprise the following steps:
(1) building database, database comprises master meter and tables from table two;
The field of described master meter comprises table name, field name, start field sequence number and stops field sequence number; Wherein table name is used for the title of storing virtual relation table, table name is the major key of master meter, field name is used for the title of all fields of storing virtual relation table, separate with separator between different field, start field sequence number, for marking the ordinal number of first character section in field name, stops field sequence number for marking the ordinal number of last field in field name;
The described field from table comprises sequence number, table name and more than 1 field, and wherein sequence number is the major key from table, and table name is the external key associated from table and master meter, and more than 1 field is used for the record of storing virtual relation table;
(2) use Web technology to create, dispose Web engineering, connection data storehouse, realizes the access to Web site in Web engineering;
(3) carry out on the webpage of browser virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table increases newly: the page preset at browser submits the newly-increased request of virtual relation table to, and virtual relation table increases table name and the field name that request comprises virtual relation table to be increased newly newly, jumps to backstage; Backstage obtains virtual relation table information by http agreement, verifies table name, if the title of virtual relation table exists in master meter, then prompting amendment table name resubmits, if the title of virtual relation table does not exist in master meter, then verifies field name; If field name form meets preset requirement, then give the instance objects assignment that master meter is corresponding, use Hibernate to insert the record of virtual relation table information to master meter;
Virtual relation list deletion: preset the page at browser and submit the request of virtual relation list deletion to, the request of virtual relation list deletion comprises the table name of virtual relation table to be deleted, jump to backstage, backstage obtains table name by http agreement, the virtual relation table of identical table name whether is there is in inquiry master meter, if exist, delete all records from table with identical table name, then delete the record of identical table name in master meter, finally return to foreground and refresh browser page;
Virtual relation table is revised: the page preset at browser submits virtual relation table amendment request to, virtual relation table amendment request comprises the table name of virtual relation table to be modified, jump to backstage, backstage obtains virtual relation table table name to be modified by http agreement, there is in inquiry master meter the record of identical table name, this record is reached foreground webpage show, foreground webpage is preserved after modifying to this record, jump to that verification table name in backstage is whether unique and form is correct, if then use Hibernate to upgrade the record of this table name in master meter, if not then return foreground webpage prompting user to remodify rear preservation,
Virtual relation table is inquired about: the page preset at browser submits virtual relation table inquiry request to, the request of virtual relation table comprises querying condition, jump to backstage, backstage gets querying condition by http agreement, generate corresponding hql statement according to querying condition, use Hibernate to perform hql statement, traversal queries result, Query Result assignment to instance objects corresponding to master meter, then by http agreement, instance objects is passed to foreground web displaying;
(4) carry out on the webpage of browser the record in database virtual relation table " increasing newly ", " deletion ", " amendment " or " inquiry ", wherein,
Virtual relation table record increases newly: the page preset at browser submits the newly-increased request of virtual relation table record to, virtual relation table record increases the table name that request comprises the virtual relation table treating newly-increased record newly, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, then the record of this virtual relation table in master meter is inquired about, Query Result assignment to instance objects corresponding to master meter, instance objects is passed to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain the title of all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, user submits to after filling in newly-increased virtual relation table record, jump to backstage, backstage gets newly-increased record by http agreement, and carry out assignment to the instance objects from table is corresponding, then Hibernate is used to insert record to from table,
Virtual relation table record is deleted: the page preset at browser submits virtual relation table record removal request to, virtual relation table record removal request comprises the table name of the virtual relation table of record to be deleted, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then inquire about master meter and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, instance objects is passed to foreground webpage, webpage splits the field name of instance objects corresponding to master meter, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, choose wall scroll to be deleted or many records to submit to and confirm removal request, jump to backstage, backstage gets the sequence number of record to be deleted by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to delete, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is revised: the page preset at browser submits virtual relation table record amendment request to, virtual relation table record amendment request comprises the table name of the virtual relation table of record to be modified, jump to backstage, backstage gets the table name of virtual relation table by http agreement, then this virtual relation table in master meter is inquired about, inquire about the record therefrom with identical table name simultaneously, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly, revise each bar record respectively, submit the request of preservation to, jump to backstage, backstage gets amended record by http agreement, carry out assignment to the instance objects from table is corresponding, then Hibernate is used to modify operation, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, refresh page,
Virtual relation table record is inquired about: the page preset at browser submits virtual relation table record inquiry request to, virtual relation table record inquiry request comprises the table name of the virtual relation table of record to be checked, jump to backstage, backstage obtains the table name of virtual relation table by http agreement, inquire about master meter again and from table, there is the record of this table name, respectively give master meter with from showing corresponding instance objects assignment, pass to foreground webpage, webpage splits the field name of master meter corresponding instance object, to obtain all fields except table name and sequence number of virtual relation table, on webpage, the virtual relation list structure filling in virtual relation table record for user is shown according to splitting the field obtained, travel through from table instance objects, each attribute of instance objects is placed on each field display of virtual relation list structure correspondingly.
2. the database virtual store disposal route of sing on web according to claim 1, is characterized in that: the database described in step (1) is SQL Server 2008 database.
3. the database virtual store disposal route of sing on web according to claim 1, it is characterized in that: in step (2), Web engineering is disposed by following steps, connection data storehouse, realize the access to Web site in Web engineering: under Java Integrated Development Environment, create Web engineering, use Tomcat as Web server, with Eclipse developing instrument, Web engineering is packaged into war wrap and be deployed on Web server, start server, to realize utilizing browser to the access of issuing engineering; Utilize Hibernate framework technology that Web engineering and database are carried out dynamic link.
4. the database virtual store disposal route of sing on web according to claim 1, is characterized in that: described instance objects is JavaBean instance objects.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510050980.0A CN104537129B (en) | 2015-01-30 | 2015-01-30 | A kind of database virtual memory processing method based on Web |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510050980.0A CN104537129B (en) | 2015-01-30 | 2015-01-30 | A kind of database virtual memory processing method based on Web |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104537129A true CN104537129A (en) | 2015-04-22 |
| CN104537129B CN104537129B (en) | 2017-11-07 |
Family
ID=52852656
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510050980.0A Expired - Fee Related CN104537129B (en) | 2015-01-30 | 2015-01-30 | A kind of database virtual memory processing method based on Web |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104537129B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107180048A (en) * | 2016-03-10 | 2017-09-19 | 阿里巴巴集团控股有限公司 | The recognition methods of idempotent state and device in database |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| CN107315832A (en) * | 2017-07-10 | 2017-11-03 | 唐郡 | The input method and system of a kind of atomization element |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
| WO2018006577A1 (en) * | 2016-07-04 | 2018-01-11 | 陶光毅 | Database dual-core storage system based on optical disk and method using the system |
| CN108241499A (en) * | 2018-01-05 | 2018-07-03 | 金行家（深圳）文化传播有限公司 | Method and device for updating field value annotation and computer readable storage medium |
| CN108241705A (en) * | 2016-12-27 | 2018-07-03 | 北京神州泰岳软件股份有限公司 | A kind of data insertion method and device |
| CN112800149A (en) * | 2021-02-18 | 2021-05-14 | 浪潮云信息技术股份公司 | Data blood margin analysis-based data management method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030208461A1 (en) * | 2002-05-01 | 2003-11-06 | Adam Messinger | System and method for adaptively optimizing queries |
| CN1797402A (en) * | 2004-12-29 | 2006-07-05 | 国际商业机器公司 | Method and device that allow to connect to multiple database server |
-
2015
- 2015-01-30 CN CN201510050980.0A patent/CN104537129B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030208461A1 (en) * | 2002-05-01 | 2003-11-06 | Adam Messinger | System and method for adaptively optimizing queries |
| CN1797402A (en) * | 2004-12-29 | 2006-07-05 | 国际商业机器公司 | Method and device that allow to connect to multiple database server |
Non-Patent Citations (1)
| Title |
|---|
| 迟金成 等: "基于JavaBean和Hibernate数据库应用的构建", 《科学技术与工程》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107180048A (en) * | 2016-03-10 | 2017-09-19 | 阿里巴巴集团控股有限公司 | The recognition methods of idempotent state and device in database |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| CN107273369B (en) * | 2016-04-06 | 2020-11-20 | 创新先进技术有限公司 | Table data modification method and device |
| WO2018006577A1 (en) * | 2016-07-04 | 2018-01-11 | 陶光毅 | Database dual-core storage system based on optical disk and method using the system |
| CN108241705A (en) * | 2016-12-27 | 2018-07-03 | 北京神州泰岳软件股份有限公司 | A kind of data insertion method and device |
| CN107315832A (en) * | 2017-07-10 | 2017-11-03 | 唐郡 | The input method and system of a kind of atomization element |
| CN107480262A (en) * | 2017-08-05 | 2017-12-15 | 中山大学 | A kind of general management system of database based on webpage |
| CN108241499A (en) * | 2018-01-05 | 2018-07-03 | 金行家（深圳）文化传播有限公司 | Method and device for updating field value annotation and computer readable storage medium |
| CN112800149A (en) * | 2021-02-18 | 2021-05-14 | 浪潮云信息技术股份公司 | Data blood margin analysis-based data management method and system |
| CN112800149B (en) * | 2021-02-18 | 2023-08-08 | 浪潮云信息技术股份公司 | Data treatment method and system based on data blood edge analysis |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104537129B (en) | 2017-11-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104537129A (en) | Web based database virtual storage processing method | |
| CN105849726B (en) | For efficiently supporting the general index of the extemporaneous inquiry by demixing marking data | |
| US20170255709A1 (en) | Atomic updating of graph database index structures | |
| CN103425762A (en) | Telecom operator mass data processing method based on Hadoop platform | |
| CN101901265B (en) | Objectification management system of virtual test data | |
| Zhang et al. | An implementation approach to store GIS spatial data on NoSQL database | |
| CN102509012A (en) | Method for mapping contents of electronic medical record into electronic medical record standard database | |
| Barmpis et al. | Comparative analysis of data persistence technologies for large-scale models | |
| CN104346466B (en) | The method and apparatus for the data that Added New Attribute in database | |
| CN104462421A (en) | Multi-tenant expanding method based on Key-Value database | |
| CN102375827B (en) | Method for fast loading versioned electricity network model database | |
| CN105389367A (en) | Power network graphic multi-tense and multi-level distributed storage method based on Mongo database | |
| CN106886568B8 (en) | One kind divides table method, apparatus and electronic equipment | |
| CN106547644A (en) | Incremental backup method and equipment | |
| CN101819530A (en) | Program object generation method and device and computer | |
| CN101789027A (en) | Metadata management method based on DBMS and metadata server | |
| CN107526746A (en) | The method and apparatus of management document index | |
| CN106528641A (en) | Data storage method and device and communication gateway machine | |
| CN105787022A (en) | Comprehensive solution for design team data bank | |
| CN106503040B (en) | It is applicable in the KV database and its creation method of SQL query method | |
| CN110799961A (en) | System and method for creating and deleting tenants in database | |
| CN105447105A (en) | NoSQL-based single field section index query method for distributed Internet of things data | |
| US20080294673A1 (en) | Data transfer and storage based on meta-data | |
| CN101667183B (en) | Method, device and system for establishing index based on customization | |
| CN103177046B (en) | A kind of data processing method based on row storage data base and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20171107 Termination date: 20200130 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |