The Design And Implementation Of DBTool

During everyday software development, the testers and the developers always need to transfer the data in the database between the different servers. In the relational database, there are some relationships between the records in general.when doing the data transferring, we need to transfer the record and the records related to.which takes a lot of time to do analysis and operation.The problem that how to transfer the records fast and right needs us to figure out.In the department of some e-commerce company, there are some internal web tools and Java programs, so there are a lot of databases used. And these databases are hosted on three servers, which greatly reduces development and testing personnel’s working efficiency. Therefore, we developed a database tool named DBTool is based on B /S structure. DBTool realizes the analysis of the relationship between database tables and the data transferring between the same database of different servers, which can help testers and developers can save a lot of time, improve work efficiency.DBTool uses the MVC pattern to design and AngularJS and Bootstrap frarmework to implement the front-end, and the part of server is written in the Java language.The front and rear end use Json format for communication.This paper mainly discusses the background of the project and the overview of database tools and introduces the technology used in DBTool. By analyzing the requirements of DBtool, we divide it into four modules and do the design of each module in detail. Finally, based on the detailed design and the project demand analysis, we elaborate the code realization and interface realization of each module in the tool.