CN107203615B - System and method for realizing database configuration and management based on Windows self-contained Bat command - Google Patents
System and method for realizing database configuration and management based on Windows self-contained Bat command Download PDFInfo
- Publication number
- CN107203615B CN107203615B CN201710369781.5A CN201710369781A CN107203615B CN 107203615 B CN107203615 B CN 107203615B CN 201710369781 A CN201710369781 A CN 201710369781A CN 107203615 B CN107203615 B CN 107203615B
- Authority
- CN
- China
- Prior art keywords
- user
- database
- module
- data
- input
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000011084 recovery Methods 0.000 claims abstract description 15
- 238000007726 management method Methods 0.000 claims description 26
- 238000007639 printing Methods 0.000 claims description 18
- 230000002159 abnormal effect Effects 0.000 claims description 12
- 238000012790 confirmation Methods 0.000 claims description 9
- 238000013479 data entry Methods 0.000 claims description 9
- 230000006870 function Effects 0.000 claims description 9
- 238000013475 authorization Methods 0.000 claims description 7
- 238000012795 verification Methods 0.000 claims description 6
- 238000012360 testing method Methods 0.000 description 13
- 238000012423 maintenance Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 4
- 238000007689 inspection Methods 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Abstract
The invention discloses a system and a method for realizing database configuration and management based on a Windows self-contained Bat command, comprising a permission setting and checking module for user permission distribution and user permission login check; the input interface control and check module is used for checking the integrity of input information in the user operation process; the dynamic password setting and verifying module is used for generating a dynamic password and verifying the dynamic password input by the user; converting and executing database commands, and sending query results to a user database query module; the program carries out information input after the user inputs the original data information according to the prompt, checks and returns an input result to the data input module confirmed by the user; a data deleting module for deleting operation according to the user input condition, checking and returning a deleting result; and the database creating and data backup and recovery module is used for creating a database and a data table by a user in an option mode and backing up and recovering the database and the data through options.
Description
Technical Field
The invention relates to the technical field of factory large-scale data testing, management and maintenance of test data and a test database, in particular to a method for realizing configuration and management of the test database based on a Windows self-contained Bat command.
Background
Currently, some small manufacturing enterprises and foundry enterprises have a demand for testing data management in the manufacturing and management process. However, the technical strength is not enough, the software can not be developed by self, large-scale professional management software is used, the cost and the technology are all deficient, the pertinence is not strong, some system integrated management software has strong professional performance, a large amount of time is needed for learning to configure and manage the database, certain experience accumulation is needed, the requirement on the quality of management personnel is high, the actual requirements of enterprises on small enterprises, personnel technical level and production, testing and management cost are limited, the actual requirements of the enterprises can not be well met, simple, efficient and easy-to-use management software and tools are absent in the market at present, and a Bat program based on a Windows self-contained command is developed based on the condition to realize convenient, efficient and foolproof management of configuration, management and daily maintenance of a test database so as to ensure the safety of server data and the stability of testing.
Disclosure of Invention
The invention aims to solve the problems in the prior art and provides a system and a method for realizing test database configuration and management based on a self-contained Bat command of Windows; the method of the invention is simple and easy to understand, high-efficiency, good in universality, easy to operate and low in cost, enables production enterprises to have the capability of configuring and managing the database without large investment, utilizes user authority management and dynamic password management, has high safety and reliability, and ensures the safety of database data.
The technical scheme for solving the technical problem of the invention is as follows:
a system for realizing configuration and management of a test database based on a Windows self-contained Bat command, wherein the system is completed by a user with set authority through database management operation, and comprises the following steps:
the system mainly takes charge of a user right checking right setting and checking module for user right distribution and login;
the input interface control and check module is mainly responsible for checking the integrity of input information in the user operation process;
the dynamic password setting and verifying module is mainly used for generating a dynamic password and verifying the dynamic password input by a user;
converting and executing database commands according to different query conditions of a user, and then printing a query result to a user database query module;
the data input module is used for inputting original data information by a user according to a prompt, performing information input by a program, checking and returning an input result, and printing the input result to the user for confirmation in a query mode;
the data deleting module is used for deleting the abnormal data according to the user input condition when the user needs to delete the abnormal data, checking and returning a deleting result, and printing the deleting result to the user for confirmation in a query mode;
and the database creating and data backup and recovery module is used for creating a database and a data table by a user in an option mode and backing up and recovering the database and the data through options.
A method for realizing the test of a database configuration and management system based on a Windows self-contained Bat command,
the method mainly comprises the following steps:
1) configuring basic parameter information of a program, wherein a user configures the parameter information according to a use environment, safety, use habits and the like;
2) the user selects a database operation option and verifies information such as an authorization authority, a dynamic password and the like according to the actual authorization authority;
3) after the authority and password verification is finished, the program can perform corresponding database operation according to prompt input, and print an operation result; after the current time, the operation can be returned to continue or quit according to the requirement.
The method comprises the following specific steps:
1) the authority setting and checking module is mainly responsible for distributing and checking the authority of the login user for the user, and after the user logs in, distributing corresponding operation authority according to the authority;
2) the input interface control and inspection module is mainly responsible for verifying the integrity of input information in the user operation process;
3) the dynamic password setting and verifying module is mainly used for generating a dynamic password and verifying the dynamic password input by the user;
4) the database query module is used for converting and executing database commands according to different query conditions of the user and then printing query results to the user;
5) the data entry module is used for carrying out information entry by a program after a user inputs original data information according to a prompt, checking and returning an entry result, and printing the entry result in a query mode for the user to confirm;
6) the data deleting module is used for deleting the abnormal data according to the user input condition when the user needs to delete the abnormal data, verifying and returning a deleting result, and printing the deleting result to the user for confirmation in a query mode;
7) the database creating and data backup and recovery module enables a user to establish a database and a data table in an option mode and perform backup and recovery on the database and data through options.
The method is specifically completed by the following steps:
1) managing a main program by utilizing a database, developing a program main menu selection interface on the basis of a BAT command, integrating all function program modules, realizing the connection of main menu options and a program execution module, and achieving the functions of managing and maintaining the database;
2) the authority setting and checking module is used for developing a user authority identification and checking program based on the BAT command;
3) the input and verification module develops a user input interface and an input data verification program on the basis of the BAT command;
4) the password setting and checking module is used for developing dynamic password generation based on the BAT command and inputting a password checking program by a user;
5) the data query module is combined with a database client tool on the basis of the BAT command to realize query of the database according to query conditions and print information to a user;
6) the data entry module is combined with a database client tool on the basis of the BAT command, realizes data entry according to entry conditions and prints information to a user;
7) the data deleting module is combined with a database client tool on the basis of the BAT command to delete data according to the condition information and print the information to a user;
8) the database backup and recovery module is combined with a database client tool on the basis of the BAT command to realize the functions of creating a database, a data table, a one-key backup database and data, a one-key recovery database and data and the like according to user options.
The invention has the beneficial effects that:
1. the method for realizing the configuration and management of the test database based on the self-contained Bat command of Windows and the method for realizing the management and maintenance of the completely black-boxed database based on the self-contained Bat command of Windows have the advantages of small program, good universality, support of local remote operation, simple operation and capability of meeting the requirement of the safety of the operation of the database by combining the authority and the dynamic password. The invention simplifies the difficulty of database operation and maintenance, simplifies the database maintenance, reduces the technical difficulty, and is more suitable for the characteristics of large mobility of enterprise personnel, short time for training at work and low personnel technical level.
2. The invention has good universality, and can stably run in all Windows system environments;
3. the invention is suitable for a security management mode combining authority authorization and dynamic passwords, and improves the reliability of database maintenance.
Drawings
FIG. 1 is a schematic block diagram of the present invention;
fig. 2 is a functional structure diagram of the present invention.
Detailed Description
For a better understanding of the present invention, embodiments thereof are explained in detail below with reference to the accompanying drawings.
The invention realizes a system and a method for realizing database management by a user through option operation based on the self-contained command of a common Windows system, and the invention supports local management and remote management through a network. Fig. 2 is specifically described below with reference to fig. 1:
fig. 1 is a schematic diagram of a module structure according to the present invention. A system for realizing configuration and management of a test database based on a Windows self-contained Bat command, wherein the system is completed by a user with set authority through database management operation, and comprises the following steps:
the system mainly takes charge of a user right checking right setting and checking module for user right distribution and login;
the input interface control and check module is mainly responsible for checking the integrity of input information in the user operation process;
the dynamic password setting and verifying module is mainly used for generating a dynamic password and verifying the dynamic password input by a user;
converting and executing database commands according to different query conditions of a user, and then printing a query result to a user database query module;
the data input module is used for inputting original data information by a user according to a prompt, performing information input by a program, checking and returning an input result, and printing the input result to the user for confirmation in a query mode;
the data deleting module is used for deleting the abnormal data according to the user input condition when the user needs to delete the abnormal data, checking and returning a deleting result, and printing the deleting result to the user for confirmation in a query mode;
and the database creating and data backup and recovery module is used for creating a database and a data table by a user in an option mode and backing up and recovering the database and the data through options.
A method for realizing database management by user through option operation based on common Windows system self-contained command mainly comprises the following steps:
1) configuring basic parameter information of a program, wherein a user configures the parameter information according to a use environment, safety, use habits and the like;
2) the user selects a database operation option and verifies information such as an authorization authority, a dynamic password and the like according to the actual authorization authority;
3) after the authority and password verification is finished, the program can perform corresponding database operation according to prompt input, and print an operation result; after the current time, the operation can be returned to continue or quit according to the requirement.
Referring to fig. 2, fig. 2 is a functional structure diagram of the present invention. The method specifically comprises the following steps:
(1) the authority setting and checking module is mainly responsible for distributing and checking the authority of the login user for the user, and after the user logs in, distributing corresponding operation authority according to the authority;
(2) the input interface control and inspection module is mainly responsible for verifying the integrity of input information in the user operation process;
(3) the dynamic password setting and verifying module is mainly used for generating a dynamic password and verifying the dynamic password input by the user;
(4) the database query module is used for converting and executing database commands according to different query conditions of the user and then printing query results to the user;
(5) the data entry module is used for carrying out information entry by a program after a user inputs original data information according to a prompt, checking and returning an entry result, and printing the entry result in a query mode for the user to confirm;
(6) the data deleting module is used for deleting the abnormal data according to the user input condition when the user needs to delete the abnormal data, verifying and returning a deleting result, and printing the deleting result to the user for confirmation in a query mode;
(7) the database creating and data backup and recovery module enables a user to establish a database and a data table in an option mode and perform backup and recovery on the database and data through options.
The steps are described in detail as follows:
1. managing a main program by utilizing a database, developing a program main menu selection interface on the basis of a BAT command, integrating all function program modules, realizing the connection of main menu options and a program execution module, and achieving the functions of managing and maintaining the database;
2. developing a user authority identification and verification program based on the BAT command by utilizing an authority setting and verification module;
3. developing a user input interface and an input data verification program based on the BAT command by using an input interface control and check module;
4. developing dynamic password generation based on BAT command by using dynamic password setting and checking module, and inputting password checking program by user;
5. utilizing a database query module, combining a database client tool based on a BAT command, realizing query of a database according to query conditions, and printing information to a user;
6. the data entry module is combined with a database client tool on the basis of the BAT command to realize data entry according to entry conditions and print information to a user;
7. the data deleting module is utilized to realize the data deletion according to the condition information and print the information to the user by combining a database client tool based on the BAT command;
8. the database creating, data backup and recovery module is utilized, and a database client tool is combined on the basis of a BAT command, so that the functions of creating a database, a data table, a one-key backup database and data, recovering the database and the data by one key and the like according to user options are realized.
Although the embodiments of the present invention have been described with reference to the accompanying drawings, the scope of the present invention is not limited thereto, and various modifications and variations which do not require inventive efforts and which are made by those skilled in the art are within the scope of the present invention.
Claims (2)
1. A system for realizing database configuration and management based on Windows self-contained Bat command is completed by a user with set authority through database management operation, and is characterized by comprising the following steps:
the system mainly takes charge of a user right checking right setting and checking module for user right distribution and login;
the input interface control and check module is mainly responsible for checking the integrity of input information in the user operation process;
the dynamic password setting and verifying module is mainly used for generating a dynamic password and verifying the dynamic password input by a user;
converting and executing database commands according to different query conditions of a user, and then printing a query result to a user database query module;
the data input module is used for inputting original data information by a user according to a prompt, performing information input by a program, checking and returning an input result, and printing the input result to the user for confirmation in a query mode;
the data deleting module is used for deleting the abnormal data according to the user input condition when the user needs to delete the abnormal data, checking and returning a deleting result, and printing the deleting result to the user for confirmation in a query mode;
the user establishes a database and a data table in an option mode and carries out database creation and data backup and recovery modules for backing up and recovering the database and the data through options;
the using method mainly comprises the following steps:
1) configuring basic parameter information of a program, wherein a user configures the parameter information according to a use environment, safety and a use habit;
2) the user selects a database operation option and verifies the authorization authority and dynamic password information according to the actual authorization authority;
3) after the authority and password verification is finished, the program can perform corresponding database operation according to prompt input, and print an operation result; after the current time is finished, the operation can be returned to continue or quit according to the requirement;
the method comprises the following specific steps:
1) using an authority setting and checking module to allocate and check the user authority, and after the user logs in, allocating corresponding operation authority according to the authority;
2) the integrity of input information in the user operation process is verified by utilizing an input interface control and check module;
3) the dynamic password setting and verifying module is used for generating a dynamic password and verifying the dynamic password input by the user;
4) utilizing a database query module to convert and execute database commands according to different query conditions of a user, and then printing a query result to the user;
5) utilizing a data entry module, after a user inputs original data information according to a prompt, carrying out information entry by a program, checking and returning an entry result, and printing the entry result in a query mode for the user to confirm;
6) when a user needs to delete abnormal data, the data deleting module is utilized to delete the abnormal data according to the user input conditions, verify and return the deleting result, and print the deleting result to the user for confirmation in a query mode;
7) by utilizing the database creating and data backup and recovery module, a user can establish a database and a data table in an option mode and perform backup and recovery on the database and data through options.
2. The system for implementing database configuration and management based on Windows self-contained Bat command as claimed in claim 1, wherein the system is specifically implemented by the following steps:
1) managing a main program by utilizing a database, developing a program main menu selection interface on the basis of a BAT command, integrating all function program modules, realizing the connection of main menu options and a program execution module, and achieving the functions of managing and maintaining the database;
2) the authority setting and checking module is used for developing a user authority identification and checking program based on the BAT command;
3) the input and verification module develops a user input interface and an input data verification program on the basis of the BAT command;
4) the password setting and checking module is used for developing dynamic password generation based on the BAT command and inputting a password checking program by a user;
5) the data query module is combined with a database client tool on the basis of the BAT command to realize query of the database according to query conditions and print information to a user;
6) the data entry module is combined with a database client tool on the basis of the BAT command, realizes data entry according to entry conditions and prints information to a user;
7) the data deleting module is combined with a database client tool on the basis of the BAT command to delete data according to the condition information and print the information to a user;
8) and the database backup and recovery module is combined with a database client tool on the basis of the BAT command to realize the functions of creating a database, a data table, a one-key backup database and data and one-key recovery database and data according to the user options.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710369781.5A CN107203615B (en) | 2017-05-23 | 2017-05-23 | System and method for realizing database configuration and management based on Windows self-contained Bat command |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710369781.5A CN107203615B (en) | 2017-05-23 | 2017-05-23 | System and method for realizing database configuration and management based on Windows self-contained Bat command |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107203615A CN107203615A (en) | 2017-09-26 |
| CN107203615B true CN107203615B (en) | 2021-01-29 |
Family
ID=59906419
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710369781.5A Active CN107203615B (en) | 2017-05-23 | 2017-05-23 | System and method for realizing database configuration and management based on Windows self-contained Bat command |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107203615B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110321979A (en) * | 2019-06-21 | 2019-10-11 | 上海翊视皓瞳信息科技有限公司 | A kind of management method and system applied to wisdom factory |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7028019B2 (en) * | 1998-11-11 | 2006-04-11 | Wise Solutions, Inc. | Method and system of managing software conflicts in computer system that receive, processing change information to determine which files and shared resources conflict with one another |
| CN101477485B (en) * | 2009-01-15 | 2010-12-08 | 中山大学 | MySQL database remote backup and reduction method based on ASP.net |
| CN101859428A (en) * | 2010-04-02 | 2010-10-13 | 上海博繁企业发展有限公司 | Equipment check and management system |
| CN106095678B (en) * | 2016-06-08 | 2018-11-23 | 上海爱数信息技术股份有限公司 | The automation result inspection method operated for data bank service under windows platform |
-
2017
- 2017-05-23 CN CN201710369781.5A patent/CN107203615B/en active Active
Non-Patent Citations (2)
| Title |
|---|
| 批处理命令 BAT备份MySQL数据库;嘎子哥;《https://www.cnblogs.com/baocheng/p/3816594.html》;20140630;第1页 * |
| 通过批处理(bat)命令创建mysql数据库及用户等;张志峰;《https://www.cnblogs.com/zhangzhifeng/p/6069588.html》;20161116;第1页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107203615A (en) | 2017-09-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109460322B (en) | Disaster recovery switching drilling system and method based on process scheduling engine technology | |
| CN104281469A (en) | Method and system for realizing refreshing and writing of ECU (Electronic Control Unit) program | |
| CN109299855B (en) | Power information communication scheduling system and scheduling method thereof | |
| CN104483842A (en) | Regulation and control integrated automatic master station comparison method | |
| CN109086213B (en) | Commercial vehicle network test management system and method based on distributed system | |
| CN110516454A (en) | Exchange method, system, device and the computer readable storage medium of more equipment | |
| CN111130922A (en) | Airborne information safety automatic test method and test platform | |
| CN110913016A (en) | Resource management system for cloud resource platform and storage medium | |
| CN105978147B (en) | The long-range fixed value modification system of automatic safety device based on file interaction | |
| WO2019047070A1 (en) | Database maintenance method and system | |
| CN107203615B (en) | System and method for realizing database configuration and management based on Windows self-contained Bat command | |
| CN105656907A (en) | Router management password recovery method and system | |
| CN103281407B (en) | A kind of IP address long-distance management system based on Godson cloud terminal | |
| CN107154982B (en) | Method and system for auditing log records | |
| CN108712247A (en) | Server account cipher management method, system and server | |
| CN107370761B (en) | LCA system security and secrecy management method | |
| CN110879936A (en) | Method for batch generation and output of process control plan based on Teamcenter | |
| CN103888278A (en) | Business activation method and system based on business simulation | |
| CN113281594B (en) | System and method for realizing remote intelligent automatic test for relay protection | |
| CN105681291A (en) | Method and system for realizing unified authentication of multiple clients | |
| CN109886528A (en) | A method of management control is executed for manufacturing | |
| CN109507922B (en) | Port data acquisition method based on intelligent Internet of things | |
| CN101141258B (en) | Method and system for completing authentication in software installation process | |
| CN113688376A (en) | Tenant authority control method for realizing container cloud platform based on CMDB system and RBAC model | |
| CN113743905A (en) | Engineering information processing platform and method based on RPA technology |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210106 Address after: Building 9, No.1, guanpu Road, Guoxiang street, Wuzhong Economic Development Zone, Wuzhong District, Suzhou City, Jiangsu Province Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Address before: Room 1601, floor 16, 278 Xinyi Road, Zhengdong New District, Zhengzhou City, Henan Province Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |