Active Query Builder Java Edition

Swing-based Java bean Visual Query Builder

Active Query Builder Java Edition is a visual SQL query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface. The component has powerful API to analyze, parse and modify SQL queries.

Active Query Builder Java Edition is built with the standard Swing library, JRE 6 (1.6), and supports all modern Java development environments. The component was successfully tested with NetBeans, Eclipse and IntelliJ IDEA.

• Common product information about Active Query Builder
  
  • Easy visual building of complex SQL queries with unions and sub-queries.
  • MS-Access style user-friendly interface with drag & drop support.
  • Two-way SQL query building (combined with SQL text editing).
  • Defining user-friendly aliases for tables and field names.
  • Powerful means of SQL query analysis and programming modification.
  • Working in offline mode, storing metadata in XML files.
  • Restricting access to unwanted objects, preventing query execution.
  • Sophisticated SQL parser, support of most popular database servers.
  • SQL query text formatting.
  • Ability to localize the component
• Integration with Java applications is achieved by setting a few properties or adding a few lines of code.

  The component may be integrated into your Java application with just few lines of code. Active Query Builder Java Edition does not force the programmer to use the embedded data grid, SQL editor or anything else. Instead, it allows you to integrate any accompanying tools into your application as quickly and easily as possible.

• SQL Parser with full access to internal query representation objects.

  Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects tree that represents all parts of the SQL query. You can edit existing queries or create new SQL queries using these objects in run-time. (See the Non-visual and Query Modification demo projects that included in the Trial version)

• JDBC and custom metadata providers.

  Active Query Builder is able to retrieve metadata from all supported database servers via JDBC automatically. Also it can load metadata to from any other data source using the event-driven metadata provider. Using Active Query Builder you can work disconnected providing all necessary metadata information by yourself. (You may learn more about different ways to load metadata at the Load Metadata demo project that included in the Trial version)

• Java Applet Live Demo is available at the web-site.
• Common product information about Active Query Builder.
• Take a look at the full list of features of Active Query Builder Java Edition.

• Java Query Builder. Reasons to use
• Java Query Builder. Screenshots
• Java Query Builder. Download
• Java Query Builder. Purchase