Create a bookmark
Bookmark is an object represent a database instance, including connection information such as connection properties, jdbc driver and so on. User can change bookmark selection and view database structure in the bookmark view conveniently.
1. Creating bookmark: You should create a bookmark before starting use CoolSQL. You can create a bookmark by the bookmark wizard. And you can start the wizard by command: File->New Bookmark, and then the wizard dialog will be displayed as the figure 1. In the wizard, you must select a jdbc driver firstly, other jdbc driver libraries should be added if there is no suitable driver available. And then you should fill some fields related to connection such as username, password and connection url, CoolSQL will aware selected driver by displaying fields needed by database.
Select a driver
Input bookmark alias
2. View structure: You can view the structure of database after connecting to database by double click on the bookmark node or select "Connect" item on the popup menu. Usually the object nodes below will be displayed:
Execute SQL and view result
You can write your sql in the SQL editor which can highlight SQL, and give you some prompt about database information (Default shortcut: alt + slash). The picture below is the presentation for this.
And you can also locat the entity object which you selected content by pressing ctrl key and left mouse button in sql editor quickly. In addition, some other useful functions are also included such as fast comment one or more line, uppercase/lowercase selected content and select text in column mode by pressing alt key.
Execute SQL and view result
Select the sql statements which you want to execute, and then you could choose one of two mode to finish execution.
CoolSQL also provides a convenient way in which you can select SQL statement and execute it fast: CoolSQL provides the shortcut key (Default: F3) for selecting SQL statement where cursor is located, and then you can use another shortcut key (Default: F4) to execute it.
Due to different statement type, CoolSQL use two style panel below to represent the result of execution:1. Query: CoolSQL use a customed table component which contains some useful functions to represent the result of execution. Please see the picture below:
After result data catches your eyes, some useful and powerful functions of result panel may attract your attention:
2. INSERT/UPDATE/DELETE: CoolSQL use a simple panel to represent the information about result including SQL statement, the row count updated in execution and elapsed time.
CoolSQL provides four log level: DEBUG, INFO, WARN, ERROR. You could change the level by global setting.
CoolSQL provides plenty options to custom for all views and common components. You can select menu(File -> Global Setting) to custom it.