CN113741968A - Method for quickly generating table corresponding to directory tree and tree node of software system - Google Patents
Method for quickly generating table corresponding to directory tree and tree node of software system Download PDFInfo
- Publication number
- CN113741968A CN113741968A CN202111000829.8A CN202111000829A CN113741968A CN 113741968 A CN113741968 A CN 113741968A CN 202111000829 A CN202111000829 A CN 202111000829A CN 113741968 A CN113741968 A CN 113741968A
- Authority
- CN
- China
- Prior art keywords
- node
- tree
- configuration
- directory
- nodes
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/75—Structural analysis for program understanding
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/168—Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Stored Programmes (AREA)
Abstract
The invention belongs to the technical field of directory trees, in particular to a method for quickly generating a software system directory tree and a list corresponding to a tree node, which comprises S1, establishing a metadata layer in a database, and storing the node and the relation of a tree type directory, the list corresponding to each resource node, the association relation of a master table and a slave table and the configuration information of the button authority of each node in the metadata layer; s2, reading the node tree configuration and the node authority configuration of the metadata layer after the service system is started; s3, clicking the nodes on the directory tree by the user, reading the form configuration of the nodes, and displaying the forms corresponding to the nodes after calculation; s4, performing read-write operation on the form corresponding to the tree node according to the table name information corresponding to the tree node acquired in the S2, and actually converting the read-write operation into operation on the corresponding table; only the information such as node authority, node tree, node form display and the like is configured on the metadata layer of the database, the related directory tree and node form information can be displayed, development is not needed, and time and efficiency are saved.
Description
Technical Field
The invention belongs to the technical field of directory trees, and particularly relates to a method for quickly generating a list corresponding to a directory tree and a tree node of a software system.
Background
In the current software system development, a front-end interface element needs to be placed, if the requirement changes, the interface element also needs to be adjusted, for example, a certain type of node is newly added in a directory tree, and then, if a certain directory tree node attribute column is set to display or not display, the node attribute column is read-only or writable, the attribute name is changed, the effect requirements displayed by different users are different, and the work generally needs to be customized and developed.
With the increase of the directory tree and the forms of the corresponding nodes thereof, the workload is multiplied, no matter in a B/S, C/S or single-edition architecture, if the requirement changes and interface elements need to be adjusted, such as setting a certain attribute column to display or not to display, read only or write, changing the attribute name, and the effect requirements displayed by different users are different, and if the tasks are customized and developed, the workload is very large.
Therefore, the invention provides a method for quickly generating a table corresponding to a directory tree and a tree node of a software system.
Disclosure of Invention
In order to make up for the deficiency of the prior art, solve with the directory tree and its form of correspondent node increase, the work load is multiplied, no matter it is B/S, C/S or single edition framework, if need change need adjust interface element, if set up some attribute column to display or not display, read-only or writable, attribute name change, different users reveal the effect require different, these work all need customize and develop, the work load will be very big problem, the invention provides a method for generating the directory tree of software system and form that the tree node corresponds to rapidly.
The technical scheme adopted by the invention for solving the technical problems is as follows: the invention relates to a method for quickly generating a table corresponding to a directory tree and a tree node of a software system, which comprises the following steps:
s1, building a metadata layer in the database, and storing the nodes and the relations of the tree-type directory, the lists corresponding to each resource node, the association relations of the master-slave lists and the configuration information of the button authority of each node in the metadata layer;
s2, reading node tree configuration and node authority configuration of a metadata layer after a service system is started, wherein the node tree configuration comprises the relationship among tree nodes, and table names and sorting field names corresponding to the tree nodes;
s3, clicking the nodes on the directory tree by the user, reading the form configuration of the nodes, and displaying the forms corresponding to the nodes after calculation;
and S4, performing read-write operation on the form corresponding to the tree node according to the table name information corresponding to the tree node acquired in the S2, and actually converting the read-write operation into the operation on the corresponding table.
Preferably, the node authority configuration includes tree nodes that can be displayed by the current operating user, and the service system calculates a directory tree that can be displayed to the current user through the node tree configuration and the node authority configuration.
Preferably, the form configuration is used for setting attribute display or hiding, read-only or writable, display sequence and whether external association exists or not; if the table is associated with the external table, reading the corresponding table data, and if the table is not associated with the external table, terminating the operation.
Preferably, the form configuration is further configured to determine whether the sequence number sequence and the sequence name are serial numbers or not, and whether the statistics is performed according to the attribute or not, and finally calculate and display the form corresponding to the node, and if the master-slave table exists, read and display the configuration information of the master-slave table together.
Preferably, the metadata layer of the database can also be replaced by a file, the nodes and relationships of the tree directory, the form corresponding to each resource node, the association relationship of the master-slave table, the button authority of each node and the like are configured and stored in the file, and the configuration information in the file is read when the system is loaded.
The invention has the following beneficial effects:
1. the invention relates to a method for quickly generating a table corresponding to a directory tree and tree nodes of a software system, which is characterized in that a metadata layer is built in a database through the technology, the nodes and the relations of a tree-type directory, the table corresponding to each resource node, the association relation of a master-slave table, the button authority of each node and the like are configured and stored in the metadata layer, then the configuration data are read for operation when the system is loaded or the tree nodes are clicked, the interface information of the corresponding directory tree and the table of the tree node is displayed, if the relations among the nodes need to be adjusted, the table corresponding to the nodes, the attributes of the table are added, the attributes are deleted, the attributes are modified and the like, and the development work can be completed only by adjusting the configuration information of the metadata layer without modifying codes.
2. The method for quickly generating the forms corresponding to the directory trees and the tree nodes of the software system can complete the form interface development work corresponding to the directory trees and the tree nodes only by changing the configuration information of the metadata layer, is efficient and practical, can greatly reduce the labor input, and can help enterprises reduce the development workload.
Drawings
The invention will be further explained with reference to the drawings.
FIG. 1 is a process flow diagram of the present invention;
FIG. 2 is a flowchart of a software system directory tree generation process of the present invention;
Detailed Description
In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further described with the specific embodiments.
As shown in fig. 1 to fig. 2, the method for quickly generating a table corresponding to a directory tree and a tree node of a software system according to the present invention includes the following steps:
s1, building a metadata layer in the database, and storing the nodes and the relations of the tree-type directory, the lists corresponding to each resource node, the association relations of the master-slave lists and the configuration information of the button authority of each node in the metadata layer;
s2, reading node tree configuration and node authority configuration of a metadata layer after a service system is started, wherein the node tree configuration comprises the relationship among tree nodes, and table names and sorting field names corresponding to the tree nodes;
s3, clicking the nodes on the directory tree by the user, reading the form configuration of the nodes, and displaying the forms corresponding to the nodes after calculation;
and S4, performing read-write operation on the form corresponding to the tree node according to the table name information corresponding to the tree node acquired in the S2, and actually converting the read-write operation into the operation on the corresponding table.
Through the steps, relevant directory tree and node form information can be displayed only by configuring information such as node authority, node tree and node form display in a metadata layer of the database, development and code compiling are not needed, and if the node relation or the node form information needs to be adjusted, the configuration information only needs to be adjusted in the metadata layer, so that the method is very simple, convenient, time-saving and efficient.
As another embodiment of the present invention, the node authority configuration includes tree nodes that can be displayed by the current operating user, and the service system calculates a directory tree that can be displayed to the current user through the node tree configuration and the node authority configuration.
As another embodiment of the present invention, the form configuration is used to set attribute display or hiding, read-only or writable, display order, and whether there is an external association; if the table is associated with the external table, reading the corresponding table data, and if the table is not associated with the external table, terminating the operation.
As another embodiment of the present invention, the form configuration is further used to determine whether the sequence number sequence and the sequence name are serial numbers or not, and whether the statistics is based on the attribute or not, and finally, the form corresponding to the node is displayed after the calculation, and if the master-slave table exists, the master-slave table configuration information is read and displayed together.
As another embodiment of the present invention, the metadata layer of the database may also be replaced by a file, and the configuration of the nodes and relationships of the tree directory, the table corresponding to each resource node, the association relationship between the master table and the slave table, the button authority of each node, and the like are stored in the file, and the configuration information in the file is read when the system is loaded.
The technology can help enterprises to reduce development workload, can complete corresponding directory trees and form interface development work corresponding to tree nodes only by changing configuration information of the metadata layer, is efficient and practical, and can greatly reduce manpower input.
The working principle is as follows: and storing the configuration of the nodes and the relationships of the directory tree, the lists corresponding to the tree nodes, the association relationship of the master-slave table, the button authority of each node and the like in a metadata layer, and then performing operation by reading the configuration data when the system is loaded or the tree nodes are clicked to display the list interface information corresponding to the corresponding directory tree and the tree nodes.
The working process is as follows:
the method comprises the steps that user information is stored in sys _ worker, a sys _ viewer storage permission group, sys _ treeview _ node storage permission points and buttons of a sys _ tone _ button storage permission point form page are stored, after a user logs in a service system, a program searches permission groups owned by the user from a sys _ worker _ server table according to a work number, then searches permission points owned by the permission groups from the sys _ node _ server table according to the permission groups, finally calculates a directory tree and tree nodes owned by the user and displays the directory tree and the tree nodes on an interface, and the configuration of the sys _ treeview _ node tree further comprises the relationship among the tree nodes, table names corresponding to the tree nodes, sequencing field names and the like.
b. A user clicks a node on a directory tree, reads the form configuration (sys _ resource _ show) of the node, sets attribute display or hiding, is read-only or writable, displays the sequence, has no external association or is externally associated to which form to fetch, is a serial number sequence and a sequence name, is a statistic according to the attribute, and finally displays the form corresponding to the node after calculation; if the master-slave table exists, the sys _ node _ master _ detail is also searched, and the configuration information of the master-slave table is read and displayed; meanwhile, the button authority owned by the form corresponding to the node can be obtained and displayed in the interface by looking up sys _ node _ toolbar _ buttons.
c. And c, according to the table name information corresponding to the tree node obtained in the step a, performing read-write operation on the table corresponding to the tree node, and actually converting into operation on the corresponding table.
Through the steps, relevant directory tree and node form information can be displayed only by configuring information such as node authority, node tree and node form display in a metadata layer of the database, development and code compiling are not needed, and if the node relation or the node form information needs to be adjusted, the configuration information only needs to be adjusted in the metadata layer, so that the method is very simple, convenient, time-saving and efficient.
The technology can help enterprises to reduce development workload, can complete corresponding directory trees and form interface development work corresponding to tree nodes only by changing configuration information of the metadata layer, is efficient and practical, and can greatly reduce manpower input.
The front, the back, the left, the right, the upper and the lower are all based on figure 1 in the attached drawings of the specification, according to the standard of the observation angle of a person, the side of the device facing an observer is defined as the front, the left side of the observer is defined as the left, and the like.
In the description of the present invention, it is to be understood that the terms "center", "longitudinal", "lateral", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", etc., indicate orientations or positional relationships based on those shown in the drawings, and are used merely for convenience in describing the present invention and for simplifying the description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the scope of the present invention.
The foregoing illustrates and describes the principles, general features, and advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (5)
1. A method for quickly generating a table corresponding to a directory tree and a tree node of a software system is characterized by comprising the following steps: the method comprises the following steps:
s1, building a metadata layer in the database, and storing the nodes and the relations of the tree-type directory, the lists corresponding to each resource node, the association relations of the master-slave lists and the configuration information of the button authority of each node in the metadata layer;
s2, reading node tree configuration and node authority configuration of a metadata layer after a service system is started, wherein the node tree configuration comprises the relationship among tree nodes, and table names and sorting field names corresponding to the tree nodes;
s3, clicking the nodes on the directory tree by the user, reading the form configuration of the nodes, and displaying the forms corresponding to the nodes after calculation;
and S4, performing read-write operation on the form corresponding to the tree node according to the table name information corresponding to the tree node acquired in the S2, and actually converting the read-write operation into the operation on the corresponding table.
2. The method of claim 1, wherein the method for rapidly generating the corresponding table of the directory tree and the tree node of the software system comprises: the node authority configuration comprises tree nodes which can be displayed by the current operation user, and the business system calculates a directory tree which can be displayed to the current user through the node tree configuration and the node authority configuration.
3. The method of claim 1, wherein the method for rapidly generating the corresponding table of the directory tree and the tree node of the software system comprises: the form configuration is used for setting attribute display or hiding, read-only or writable, display sequence and whether external association exists or not; if the table is associated with the external table, reading the corresponding table data, and if the table is not associated with the external table, terminating the operation.
4. The method of claim 3, wherein the method for rapidly generating the corresponding table of the directory tree and the tree node of the software system comprises: and the form configuration is also used for judging whether the serial number sequence and the serial name exist or not, counting according to the attribute, finally calculating and displaying the form corresponding to the node, and if the master-slave table exists, reading and displaying the configuration information of the master-slave table together.
5. The method of claim 4, wherein the method for rapidly generating the corresponding table of the directory tree and the tree node of the software system comprises: the metadata layer of the database can also be replaced by files, the nodes and the relations of the tree directory, the lists corresponding to each resource node, the association relation of the master-slave table, the button authority of each node and the like are configured and stored in the files, and the configuration information in the files can be read when the system is loaded.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111000829.8A CN113741968A (en) | 2021-08-27 | 2021-08-27 | Method for quickly generating table corresponding to directory tree and tree node of software system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111000829.8A CN113741968A (en) | 2021-08-27 | 2021-08-27 | Method for quickly generating table corresponding to directory tree and tree node of software system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113741968A true CN113741968A (en) | 2021-12-03 |
Family
ID=78733760
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111000829.8A Pending CN113741968A (en) | 2021-08-27 | 2021-08-27 | Method for quickly generating table corresponding to directory tree and tree node of software system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113741968A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050216482A1 (en) * | 2004-03-23 | 2005-09-29 | International Business Machines Corporation | Method and system for generating an information catalog |
| CN101799753A (en) * | 2009-12-17 | 2010-08-11 | 中国电力科学研究院 | Method and device for realizing tree structure |
| CN104239073A (en) * | 2014-10-15 | 2014-12-24 | 中国科学院软件研究所 | Data maintenance system rapid prototyping development system and method |
| CN107608747A (en) * | 2017-09-22 | 2018-01-19 | 携程旅游信息技术（上海）有限公司 | The construction method of form system, device, electronic equipment, storage medium |
| US20210191919A1 (en) * | 2019-12-20 | 2021-06-24 | Oracle International Corporation | Using path encoding method and relational set operations for search and comparison of hierarchial structures |
-
2021
- 2021-08-27 CN CN202111000829.8A patent/CN113741968A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050216482A1 (en) * | 2004-03-23 | 2005-09-29 | International Business Machines Corporation | Method and system for generating an information catalog |
| CN101799753A (en) * | 2009-12-17 | 2010-08-11 | 中国电力科学研究院 | Method and device for realizing tree structure |
| CN104239073A (en) * | 2014-10-15 | 2014-12-24 | 中国科学院软件研究所 | Data maintenance system rapid prototyping development system and method |
| CN107608747A (en) * | 2017-09-22 | 2018-01-19 | 携程旅游信息技术（上海）有限公司 | The construction method of form system, device, electronic equipment, storage medium |
| US20210191919A1 (en) * | 2019-12-20 | 2021-06-24 | Oracle International Corporation | Using path encoding method and relational set operations for search and comparison of hierarchial structures |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113342821B (en) | Report configuration method, device, equipment and computer storage medium | |
| CN108733713B (en) | Data query method and device in data warehouse | |
| US5159669A (en) | Automatically creating a second workspace operation record including history data and a unit ID based on a first workspace operation | |
| US8010530B2 (en) | Presentation of multilingual metadata | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN110781183B (en) | Processing method and device for incremental data in Hive database and computer equipment | |
| WO2006098031A1 (en) | Keyword managing apparatus | |
| CN102541867A (en) | Data dictionary generating method and system | |
| CN102810094A (en) | Report generation method and device | |
| US7370030B2 (en) | Method to provide management of query output | |
| CN106951254B (en) | Method and device for multiplexing similar service function modules in payment system | |
| CN115544183B (en) | Data visualization method, device, computer equipment and storage medium | |
| US20040078355A1 (en) | Information management system | |
| CN113434482A (en) | Data migration method and device, computer equipment and storage medium | |
| EP1618456A2 (en) | System and method for providing a territory management tool | |
| US7308457B1 (en) | Method and apparatus for providing customized filters to restrict datasets retrieved from a database | |
| CN113741968A (en) | Method for quickly generating table corresponding to directory tree and tree node of software system | |
| CN114153438A (en) | API automatic generation system | |
| CN112286879B (en) | Metadata-based data asset construction method and device | |
| CN115080594A (en) | Method and system for carrying out multi-dimensional analysis on data and electronic equipment | |
| CN101159049A (en) | Dynamic configuring arrange method and system | |
| CN114281845A (en) | Index generation method and device, electronic equipment and readable storage medium | |
| CN111797125A (en) | Report creating method and device, electronic equipment and computer readable storage medium | |
| CN107729013B (en) | Method for managing operation buttons on web page and computer-readable storage medium |
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 |