Browse Code ▾
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
License
Apache License V2.0Follow Dynamic Queries
Other Useful Business Software
Gen AI apps are built with MongoDB Atlas
MongoDB Atlas provides built-in vector search and a flexible document model so developers can build, scale, and run gen AI apps without stitching together multiple databases. From LLM integration to semantic search, Atlas simplifies your AI architecture—and it’s free to get started.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Dynamic Queries!