| Java Source Code / Java Documentation » Database Client » SQL Workbench |
| SQL Workbench/J SQL Clients | |
| License: | |
| URL: | http://www.sql-workbench.net |
| Description: | SQL Workbench/J is a DBMS independet frontend for SQL databases. |
| Package Name | Comment |
| workbench | A DBMS independent SQL Tool |
| workbench.db |
Database metadata related classes.
The db package contains backend classes to
|
| workbench.db.datacopy | Implementation of a class to copy data from one DBMS to another |
| workbench.db.derby | Apache Derby specific classes. |
| workbench.db.diff | Classes to compare two different database schemas. The differences are described in a XML file. |
| workbench.db.exporter |
Export data in various formats.
The classes in this package are used to create export files a ResultSet
The DataExporter class will handle the generation of the ResultSets and manages
access to the Writer or Stream of the outputfile. The DataExporter will
create an ExportWriter that will take care of writing the data to the
output file (created by the DataExporter).
To convert a single row into the desired output format, the ExportWriter will
create a RowDataConvert that is suitable to convert a complete {@link workbench.storage.RowData}
object into the output format
The data can be exported in different formats:
|
| workbench.db.firebird | FirebirdSQL specific classes |
| workbench.db.firstsql | FirstSQL specific classes |
| workbench.db.h2database | H2 Database Engine specific classes. |
| workbench.db.hsqldb | HSQLDB specific classes. |
| workbench.db.ibm | IBM DB2 specific classes. |
| workbench.db.importer | Import XML or text files into the database. |
| workbench.db.importer.modifier | |
| workbench.db.ingres | Ingres R3 specific classes. |
| workbench.db.mckoi | McKoi Database specific classes. |
| workbench.db.mssql | Microsoft SQL Server specific classes. |
| workbench.db.mysql | MySQL specific classes. |
| workbench.db.oracle | Oracle specific classes. |
| workbench.db.postgres | PostgreSQL specific classes. |
| workbench.db.report | Classes to generate a XML report of a database schema. |
| workbench.db.shutdown | Classes to that are used to shutdown embedded engines properly. The DbShutdownFactory is used to create instances of the DbShutdownHook interface. This is used by the {@link workbench.db.ConnectionMgr}. |
| workbench.gui | All classes that implement the GUI for SQL Workbench/J |
| workbench.gui.actions | Actions used in the GUI frontend. Every Action is a descendant of {@link workbench.gui.actions.WbAction} that provides several utility functions to work with Actions. Each WbAction will register itself with the {@link workbench.resource.ShortcutManager}, in order to allow a remapping of keyboard shortcuts. Some actions are not created during startup, in this case they have to be registered with the Shortcut manager using the ActionRegistration class. If that is not done, they won't be available in the "Configure shortcuts" dialog which is implemented through {@link workbench.gui.settings.ShortcutEditor} |
| workbench.gui.completion | Implement code completion for SQL Statements. |
| workbench.gui.components | Re-usable GUI components. |
| workbench.gui.dbobjects | Display database objects |
| workbench.gui.dialogs | Re-usable dialogs. |
| workbench.gui.dialogs.dataimport | Dialog and related components that are used to import a text file into a result set. |
| workbench.gui.dialogs.export | Dialog and related components that are used to export a result set. |
| workbench.gui.editor | The SQL Editor for SQL Workbench/J. Based on the jEdit 2.2 syntax package |
| workbench.gui.filter | GUI Components to edit and save DataStore filters. |
| workbench.gui.help | A simple HTML viewer to display the help file. |
| workbench.gui.lnf | Classes to manage (load and apply) Look & Feels |
| workbench.gui.macros | Front end components to manage SQL Macros. |
| workbench.gui.menu | Menus that are used at several places. |
| workbench.gui.preparedstatement | Frontend for inputing parameters in prepared statements. |
| workbench.gui.profiles | Manage and select connection profiles |
| workbench.gui.renderer | Table renderers used to display result sets |
| workbench.gui.settings | GUI components to edit the global Workbench options |
| workbench.gui.sql | GUI components to display the result of a SQL Query and to edit SQL scripts. |
| workbench.gui.tools | Additional GUI based tools that are run outside the MainWindow. |
| workbench.interfaces | Globally used Interfaces for SQL Workbench/J |
| workbench.log | |
| workbench.print | Classes to print a {@link workbench.gui.components.WbTable} |
| workbench.resource | |
| workbench.sql |
Classes to handle SQL scripts and statements.
A {@link workbench.interfaces.StatementRunner} is used to execute a single SQL Statement. A {@link workbench.sql.BatchRunner} is used to run a sequence of SQL statements that are delimited with a defined delimiter (semicolon beeing the default). The BatchRunner uses the {@link workbench.sql.ScriptParser} to split the sequence of SQL Statements into individual statements. |
| workbench.sql.commands | Handling of important SQL commands (such as SELECT or DDL commands) |
| workbench.sql.formatter | A SQL Lexer and formatter |
| workbench.sql.preparedstatement | Support for PreparedStatements. These classes are used to PreparedStatements and to store entered parameter values. |
| workbench.sql.syntax | |
| workbench.sql.wbcommands | Implementation of Workbench specific SQL commands. |
| workbench.storage | Classes to cache a ResultSet in Memory and to update the database after modifications in the cache. |
| workbench.storage.filter | Abstract filter definitions to be used for a DataStore. |
| workbench.util | Utility classes |