Mysql,oracle,postgresql Manage maintenance through the web to improve development and operational efficiency

In the development and project operations, the operation of the database is currently using client tools, such as the client tool navicat,oracle MySQL Client tool

PL/SQL Developer, MSSQL Client Tool Query Analyzer, etc. At present, the majority of the use of C/s stand-alone client tools, to even the database of computers to install client tools,

Navicat is also a good installation, and the Oracle Client tool installation is cumbersome.

When the remote server database access management, especially the Linux server, to open the appropriate port, which also increased the security of the server, increased workload.

If you have Web-based database client tools, you can improve and solve some of the above problems. After months of unremitting efforts, this web-based client tool is finally available.

The currently supported databases include Mysql,oracle,postgresql,mssql.

Let's introduce this Java Web development based TREEDMS database management system, similar to phpMyAdmin software.

1. Installation and Login System
Access http://www.treesoft.cn/dms.html, download Treedms,window directly decompression, run can be used, the program has included the Java Runtime Environment, Linux to install the Java environment, the program directly copied the past, can be run. For the main page after login:



2. System Homepage
After successful login, make the system homepage, first use the user click the "Parameter Configuration" button in the upper right, the database address, user and other information configuration, so as to connect to the user database.
The System homepage includes: The left side is the database table display area, the middle is the SQL edit and the data display area, the right side is the query support area. The function is intuitive and easy to operate.

3. SQL Online Editing execution
In the SQL edit area, you can edit the statement directly, and maintain the operation of the database. Support multi-statement batch execution, support selection execution, support keyword highlighting, support multi-result display.

4. Online editing and maintenance of table data
After selecting the library table on the left, the table data will be queried directly and displayed. The table data can be maintained by adding, editing, and deleting buttons. You can also directly double-click the row for data editing, the operation is very convenient.


5, table structure on-line editing and maintenance
By clicking the "Design" button, you will switch to the table structure design page, you can easily add, modify, delete table fields, adjust the field order, set the primary key, set non-empty operations.

6. Saving SQL query statements
When you have edited many SQL statements, you can click on the "SQL Save" button to save your labor results, through the right "my SQL" list, you can query to save records.

7. Help with SQL syntax
The system integrates some common SQL syntax help information, you can select and view the corresponding statement, and the post-selection syntax information will be displayed in the editing area.



8, the choice of skin color matching
The system contains 14 sets of UI skins, 45 sets of code editing area UI scheme, can be set freely, the dark screen helps to protect eyesight. The above is the choice of different skin.

Summary, I hope this software to help you work, but also hope that domestic software can lead the industry technology innovation!

If you think reading this article to help you, please click on the " recommended " button, your "recommendation" will be my biggest research and development power! You are welcome to download.

Mysql,oracle,postgresql Manage maintenance through the web to improve development and operational efficiency