QcjDataClass package.

Overview of the package

This package provides a class framework for building database applications quickly and easily. The classes have been formulated with the idea that the QcjData should be entered and modified in forms. Table views are provided for representing and selecting the entire data set for the table. Quite often it is convenient to provide an sql view to use in the table view and link it to a form which manipulates a single record of the actual table.

The resulting programs can then be readily customized by the end user by changing an XML file for the application. The XML file specifies what tables and fields are displayed on what forms or tables (table views not QcjDatabase tables). The XML files also specifiy the configuration items to present to the user as well as help strings and other resources.

There are currently for main widgets this application provides. Other widgets are available also, but the intention is for them to be used by the main four widgets.

The widgets are:

• QcjDataForm A QFrame widget for holding elements for a single record of the database. The contents of the record can be manipulated, a new record created, and an existing record can be deleted using this widget.

• QcjDataTable A QFrame holding a QTableView for selecting one or more of multiple records in the database. This widget allows you to sort on multiple columns, search for a record with specific data in the fields, filter on data contents. The internals of the table are accessable to be able to perform bulk actions on multiple records.

• QcjDataSheet A QTextBrowser widget for displaying multiple records in a nicely formated fashion. This widget does not allow data mainipulation by the user, no ordering or filtering by the user either. It does provide ordering and filtering with by program.

• QcjPhotoFrame This is a QFrame which will show one or more photos saved in a table in the database. They can have other fields in the record displayed as text with the photos as well.

In addition to the widgets above, there are two Dialogs provided. These are:

• QcjDataConfigure This dialog provides an interface for the user to set configuration values for the application. Help displayed can be provided in the XML docuiment for each item to provide the user with guidence of what and how the setting acts on the application.

• QcjDataReport This dialog displays reports. Queries can be built prameters can be provided and a nicely formated report will be generated for the user. This report can then either be printed or saved as a pdf file.

Application integration and integration into the Designer

To use the code in your project, It should reside in a directory called QcjData in the source directory of your application. You then just need to add the files for it into the .pro file used to build you application.

To integrate it into the Qt designer, There are several .pro files in the QcjData directory. Run qmake <name>.pro; make for each one. This will build and place their plugins into the appropriate directory for the desinger to see them. Be sure you have proper permissions for the designer's plugin directory. If all went well, when you start the designer you will find a category named QcjData Widget with the available widgets listed in it.

Download

This project is hosted on LinuxLots and the latest download as well as older version can be downloaded from there. Follow this link ftp://ftp.linuxlots.com/pub/qcj to get the code!

---