EasySQL

[Screenshot]

Subscribe to Mailing List - Request Feature - Report a Bug

Download

Installation: Unzip to eclipse's plugins directory

Features and Usage

• Syntax highlighting
• Database and table auto-completion (Ctrl + Space)
  • If connection is selected, will auto-complete database names
  • If database is selected, will auto-complete table names
• Execute selected text
  • If text is selected, only the selected text will be executed
  • If none selected, all will be executed
  • Execute query with results in existing ResultSet (Ctrl + Alt + E)
  • Execute query with results in new ResultSet (Ctrl + Alt + W)
• Export data
  • Right click on result set, Export
    

Use as a dependant plugin

EasySQL was designed to be easily integrated with other plugins. If you plugin needs database integration, using EasySQL is as easy as showing the ConnectionView, here is a quick example:

// IWorkbenchWindow window; this is found differently via where you are in the application (actions, editors, views, etc)
ConnectionView connectionView = (ConnectionView) window.getActivePage().showView(ConnectionView.ID);
Connection conn = connectionView.getSelectedConnection().getConnection();
Now you can use java.sql.Connection just as you normally would.

3 Views available:
ConnectionView.ID, ConnectionView.MENU_ID for the Right-Click Menu
ResultView.ID
MessageView.ID

1 Editor:
SQLEditor.ID