Outline

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 fields

Input bookmark alias
After above steps, a bookmark node will be add to bookmark tree in the bookmark view.

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:
  • Bookmark Node
  • Catalog Node
  • Schema Node
  • Entity Group Node
  • Entity Node
  • Column Node


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.

  • Concurrent: If you selected multiply SQL statements, CoolSQL will execute them concurrently.
  • Sqlscript: If you selected multiply SQL statements, CoolSQL will execute them as a sql script within one thread.

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:
  • Modify table data on result panel directly: If your querying related to one table only, the result table will be editable including updating and deleting. And you can save your modification to table cell conveniently by just using a shortcut (Default: ctrl + s). Note: you will be informed whether current result panel is editable by the color of left bottom ball icon(Green: Editable. Blue: Not Editable but you can change the status of result panel. Red: forbid modifying)
  • Add new rows for table in database: Select "Add New Data" in right popup menu, and then a new dialog will be popped like picture below:

    In this dialog you can add/edit row data conveniently with functions provided by CoolSQL including error notification, fast drag for continious value or copying, commonly pasting from other table sources.
  • Modify only one row in updating dialog: This function will be more precise than modifing on result panel. You can select "Update Current Row In Frame" item in right popup menu to get it.

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.

Log

CoolSQL provides four log level: DEBUG, INFO, WARN, ERROR. You could change the level by global setting.

Global Setting

CoolSQL provides plenty options to custom for all views and common components. You can select menu(File -> Global Setting) to custom it.