Project to dinamically export queries to Excel, PDF and Jasper Viewer
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.
Java graphic front end for SQLite database (eg addressbook)
...Typically the database may be an address book. addressdb incorporates flexible field searches based on SQlite's native comparison operators and word and regular expression searches.
Records may be exported as pdf files with flexible formats (eg address labels) and as text files (eg comma separated values - csv) also with flexible formatting. csv files may be used as backup and to transfer data between databases; addressdb can create a database from a csv file.
Database fields and output formats are specified through a text configuration file which may refer to more than one database and include several output formats. ...