Solution overview：
In the process of business requirements development and testing of bank core system, there are a lot of situations that require developers to modify test data artificially, and there are communication timeliness problems between testers and developers. In order to improve the testing efficiency of testers and the development efficiency of developers, it is necessary to develop a test coordination management system.
Functionality：
1. General developers maintain the corresponding business scenario SQL statements.
2. Senior developers review whether the business scenario is consistent with the configured SQL and parameters, and enable the business scenario after passing the audit.
3. The tester selects the corresponding business scenario to fill in the parameters and modify the data function.
4. After submitting and modifying the corresponding business scenario, testers need to record the operation log, such as the selected business scenario name, execution environment, execution result, execution time, executor, etc.
5. User management, used to manage system users.
6. Department management
7. Rights management, so that each user with different roles has his own permissions, which can be flexibly configured.
8. Change the password so that each user can change the password by himself.
9. The system needs to be equipped with the functions of other external systems to this system. At present, the log query system has been attached.
10. There are several test environments, such as dev, sit, UAT. Multiple environment databases need to be implemented in configuration mode, which is actually easy to modify.
Technical features：
Development technology：spring mvc、mybaties、mysql、ztree、topjui、jquery
Database：mysql
Deployment container：Tomcat
Terminal database：oracle
Module function design and Implementation：
SQL configuration center：For general developers to configure SQL statements, including add, modify, delete functions. The data item includes,
title, execution times, SQL statement, description, creator ID and modifier ID, which can be flexibly configured according to corresponding business scenarios.
SQL configuration audit：For senior developers, check whether the SQL configured by general developers conforms to the business scenario.
If so, mark it as enabled.
SQL execution：Testers use this function to select the corresponding business scenarios, fill in the parameters and modify the relevant data.
SQL execution log：This function is used to query the SQL execution log. If the tester fails to execute, it is convenient for developers to analyze
problems. At present, there is no corresponding record in the link of modifying test data. This function is convenient for recording test data.
Department management：This function is used for the management department and is maintained in a tree structure. It has the operations of
adding, modifying and deleting.
User center： This function is used to manage login system users.
Authority management：It is used to manage the permission group, the authority of the permission group, and the personnel contained in the
permission group.
Terminal database environment configuration：Configure database connection configuration for different environments.
