Dynamic Queries

Project to execute SQL queries from an SQL file. Once the file is loaded you can export the result to an Excel or PDF file or to view it with Jasper Viewer. The file loaded can be seen in a textarea. This textarea is editable so that you can edit your query at runtime and export it. For the time being you can't include parameters to the query. The best of this project is that you really don't know how many columns of the table of your database are and this project dinamically does this.

Features

Dinamically export the result of a query to Excel, PDF and Jasper Viewer
Easy database connection through an xml file
Can connect to Oracle, SQL Server and MySQL

Project Samples

Project Activity

See All Activity >

License

Apache License V2.0

Follow Dynamic Queries

Dynamic Queries Web Site

Other Useful Business Software

Gen AI apps are built with MongoDB Atlas

The database for AI-powered applications.

MongoDB Atlas is the developer-friendly database used to build, scale, and run gen AI and LLM-powered apps—without needing a separate vector database. Atlas offers built-in vector search, global availability across 115+ regions, and flexible document modeling. Start building AI apps faster, all in one place.

Start Free

Rate This Project

User Reviews

Be the first to post a review of Dynamic Queries!

Additional Project Details

Operating Systems

Windows

Languages

English, Spanish

Intended Audience

Developers, End Users/Desktop, Information Technology, Testers

User Interface

Java Swing

Programming Language

Java

Database Environment

JDBC

Related Categories

Java Database Software, Java Information Analysis Software, Java Exam Software

Registered

2015-02-18

Similar Business Software

dbForge Studio for PostgreSQL

dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to...

See Software
WinSQL

WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity...

See Software
dbForge Query Builder for MySQL

dbForge Query Builder for MySQL is a visual tool that allows creating any sort of MySQL queries, from simple lookups to complex JOINs. The tool provides broad compatibility options and helps constructing and editing complex MySQL queries in a few clicks. You don't need to sweat building complex...

See Software
SQL Workbench

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical...

See Software
Hue

Hue brings the best querying experience with the most intelligent autocomplete and query editor components. The tables and storage browsers leverage your existing data catalog knowledge transparently. Help users find the correct data among thousands of databases and self-document it. Assist...

See Software
SQL Data Analysis

Import data sets from your databases using SQL queries. Analyze your data sets using analysis tables and pivot tables. Discover new patterns and trends from your analysis. Share your discoveries using PDF reports, or export to Excel, HTML, and XML files. Get actionable insights from your SQL...

See Software