Active Query Builder  »  SQL Query Builder

Active Query Builder Java Edition

Swing-based Java bean Visual SQL 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 analyse, parse and modify SQL queries. Active Query Builder Java Edition is a real two-way query builder so that you can combine visual query building with direct SQL query text editing.

Have a look at the Demo Java applet built with Active Query Builder Java Edition.

Product summary
Latest version:
1.9.0.1153
History of changes
Price from:
$450
All purchase options
Download free trial

Active Query Builder Java Edition requirements

  • Built using standard Swing controls.
  • Compatible with JRE 6, 7.
  • Can be used in Java applets.
  • Supports all modern Java development environments. Successfully tested with NetBeans, Eclipse and IntelliJ IDEA.

Main Features of Active Query Builder Java Edition

  • Simple and clear visual SQL query building interface
    • Easy 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).
    • Customisable SQL query text formatting.

  • Customisable query building environment
    • Complete substitution of unintelligible object and field names for user-friendly aliases.
    • Representing high-usage expressions and sub-queries as ordinary database objects and fields.

  • Easy metadata management
    • Selective unwanted objects hiding, automatic filtration by schema or object name.
    • Loading metadata programmatically from different sources (via web services or from datasets).
    • Working disconnected from the database, storing metadata in XML files.

  • Powerful API to analyse and modify SQL queries
    • Restricting access to unwanted objects, preventing SQL query execution.
    • Quick access to comprehensive information about the query: database objects and fields, query columns and parameters.
    • Full access to internal query representation objects for SQL query analysis and modification.

  • The full feature list of Active Query Builder Java Edition.
  • Active Query Builder Java Edition - Applet Demo.

Related pages

News

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks