User view configuration method
A user view and database technology, applied in special data processing applications, instruments, electrical and digital data processing, etc., can solve problems such as poor flexibility, inability to meet, and complicated configuration of conditions, and achieve the effect of improved flexibility and simple configuration
Inactive Publication Date: 2012-02-22
LINEWELL SOFTWARE
View PDF3 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0009] This traditional configuration method has several problems: 1. The flexibility is poor, and it is only suitable for configuring a single table or a simple composite table, but it cannot satisfy the complex configuration of multiple tables; 2. The configuration of conditions is cumbersome, usually The desired result can only be achieved by writing extended functions for assistance; 3. Since the fields in step 2 are limited by the data table in step 1, all display content will be limited by the data table configured in step 1. For the result set that needs to go through multiple layers of nesting and filtering, it is often not possible to complete it through configuration, and another method is needed to achieve it.
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0016] Such as figure 1 As shown, a user view configuration method of the present invention specifically includes the following steps:
[0017] Step 1. Start the program related to the user view configuration mechanism, set the basic information of the view name, view alias, view display structure, and database connection ID, and do not associate the data table in this step;
[0018] Step 2. Construct the SQL statement required by the result set, and set corresponding parameters according to user permissions and other filter conditions;
[0019] Step 3. Set the information column to be displayed according to the column value queried by the SQL statement, and set the alias of the column to facilitate browsing. At the same time, the column can be converted to complete the setting of the column value displayed in the user view;
[0020] Step 4. Take out data from the database to form a user view;
[0021] Step 5. Save or preview the set user view, and adjust it according to the...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a user view configuration method. Basic connection information of a database is firstly configured, then an SQL (structured query language) statement is structured and a display column value is configured on a user view according to needed results, and finally, the user view is formed by means of taking data out of the database. The SQL statement is not limited, can be programmed only according to effects required by users, the user view is displayed and configured according to an array inquired by the SQL statement, and accordingly the required user view is formed. The user view configuration method can support quick configurations of various user views, and supports configurations of complicated views associated with multiple tables, and display complication of the data base is reduced for the final users.
Description
technical field [0001] The invention relates to a method for freely configuring a user view for data display of an information application system. Background technique [0002] The user view refers to filtering out the information that the user has permission to see and care about from the data table. The user view is a virtual table called by the function module, and its content is defined by the query. Like a real table, a user view contains a series of named columns and rows of data. However, the user view does not exist in the database in the form of a stored data value set. The row and column data come from the table referenced by the query in the custom user view, and are dynamically generated when the user view is referenced. That said, the userview acts like a filter. [0003] With the rapid development of informatization, an information system currently has dozens of functional modules and hundreds of functional modules, and the target users are also diverse. Th...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More IPC IPC(8): G06F17/30
Inventor 曾文语陈应全
Owner LINEWELL SOFTWARE