Shulou(Shulou.com)06/01 Report--

Now many applications are deployed to the cloud, so the database needs to be managed and maintained remotely, so it is more safe and convenient to operate based on web.

TreeSoft database management software is developed by JAVA, adopts stable and general springMVC+JDBC architecture, and realizes the maintenance and management operation of SQL Server,MySQL,Oracle,PostgreSQL database based on web.

Functions include: database display, database table display, table field structure display, SQL sentence online editing and batch execution, table structure online design and maintenance, data online editing and maintenance, query statement saving, JSON data formatting, SQL syntax help, online data source selection and configuration, etc. The system has 14 sets of UI skins and 45 sets of code editing area UI scheme, and the color matching scheme can be selected according to personal preference.

Function introduction:

1. In the SQL editing area, you can edit statements directly to operate and maintain the database. Support multi-statement batch execution, support selective execution, support keyword highlighting, support multi-result display.

2. After selecting the left database table, the table data will be queried directly and displayed. Table data can be maintained by adding, editing, and deleting buttons. It can also edit the data directly, and the operation is very convenient.

3, by clicking the "Design" button, you will switch to the table structure design page, you can easily add, modify, delete table fields, adjust the order of fields, set the primary key, set non-empty and other operations.

4, when you have edited a lot of SQL statements, you can click the "SQL Save" button to save the results of your work. Through the "my SQL" list on the right, you can query to save the record.

5. The system has 14 sets of UI skins and 45 sets of code editing area UI scheme, which can be set freely. The dark screen helps protect eyesight.

6. Provide JSON data formatting function to facilitate the hierarchical selection of JSON data.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.