Casual opportunity, found a very good JDBC debugging tool, free.
It is DBVIUALIZER. You can find downloads at http://www.dbvis.com/.
The installation process is very common, I believe that every programmer can make it easy, now we look at its true face.
Welcome interface, pure Java writes DBVIUSUALIZER in Windows, in Windows, I don't know what other platforms look.
The newly installed dbvisualizer requires setting drivers and data sources, which are completed in GUI mode and is very intuitive. Click on the left side of the toolbar Manage Drivers to enter the drive manager page, manage the data driver, such as what drove in the ClassPath of the Java system:
During the search process, I don't know what the reason is. However, there is no relationship, we can use another way to locate JDBC drivers, you can use the "Add Location ..." menu item to specify the JAR file with the "Open File" dialog box.
Open the firebird-full.jar file on my hard drive, DriverManager successfully found the Firebird driver. Now, we can use this JDBC driver to create the data connection, click "Add New Database Connection" on the Database Objects page, and the rest is set by prompts item by item:
After setting the information, please try it:
Display database object tree, lt; font face = "Times New Roman, Serif"> SQL, with high-definitive stickers, return to execute, is not enough to trigger my freshness, these features have been used to it, but this table Related page --Refrence, have to be a highlight, you know that there is a simple intervivorial diagram for our usual development database system, you can always give us a prompt, you don't have to go to the project. Documentation to determine the data structure. To know that although the same function is in MS SQL Server, that relationship is required to manually draw (of course, MSSQL's relationship map provides another powerful function), this is automatically generated, in the object, Still quite beautiful :).
Usually, we may not need to return all the data in the query. In MSSQL, you can use the "Top N" function, but in DBVISUALIZER, this feature is integrated, we don't have to modify our SQL statement.
Note "Max Rows:" and "Max Chars" on the right side of the form, here is the parameter of the specified data set size. Click the "log" button, you can also display the execution information, here you don't cut another screenshot, so as not to make a lot of money.
Bookmark Editor is another powerful tool that opens through the "Bookmarks" menu. Here we can track the execution of the SQL command, manage history commands, build a bookmark, etc.
With Debug Window, we can also track the operation of Java systems, such as exception, warning, system resources, etc.
In the "Tool Properies" item under the "Edit" menu, we can also set up Debug, but also set other system parameters, I believe this doesn't have to introduce too much.