SQL Server Web-based remote maintenance, management

Now that many applications are in the cloud, the database requires remote management and maintenance, then the web-based approach is more secure and convenient.

Treesoft database management software uses the Java development, uses the stable common SPRINGMVC+JDBC architecture, realizes the Web-based method to the SQL Server,mysql,oracle,postgresql database to carry on the maintenance management operation.

Features include: Database display, library table display, table field structure display, SQL statement online editing batch execution, table structure of online design maintenance, data online editing maintenance, query statement save, JSON data format, SQL syntax help, online data source selection configuration. The system contains 14 sets of UI skins, 45 sets of code editing area UI scheme, which can choose color scheme according to personal preference.

Feature Description:

1, in the SQL edit area can directly edit the statement, the database operation and maintenance. Support multi-statement batch execution, support selection execution, support keyword highlighting, support multi-result display.

2, select the left side of the library table, the table data will be directly queried and displayed. The table data can be maintained by adding, editing, and deleting buttons. can also directly to the data editing, operation is very convenient.

3, by clicking the "Design" button, 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.

4, when you edit a lot of 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.

5, the system built-in 14 sets of UI skin, 45 sets of code editing area UI scheme, can be set freely combination, dark screen helps to protect eyesight.

6, provide the JSON data format function, convenient to the JSON data hierarchical selection operation view.

SQL Server Web-based remote maintenance, management