For new Java developers just learning the language and class libraries, trying to figure out how to add database functionality to an applet is a daunting process. You need to learn even more classes with JDBC, the SQL language, and of course technical details about your specific relational database such as Oracle, or SQL Server. If you only have simple database requirements, then eCriteria is the perfect solution.

Instead of dealing with the technical hassles of dealing with Java database connectivity, you can create your Web database with eCriteria. All you need to do from Java is provide an HTTP link into our service for both searchable and data entry web databases. As with our HTML interface, we host your data and make it easy to administer your multiple databases. A Premium or Enterprise account is required to use eCriteria from Java. Take advantage of our free 30-day trial account to see if eCriteria provides the Java database solution you need.

Here is an example of a Java applet that searches an eCriteria web database:

Search example (Applet Version)

Here is an example of the same searchable eCriteria database in HTML:

Search example (HTML Version)

Here is an example of a Java applet that serves as a data entry form for an eCriteria web database:

Data entry example (Applet Version)

Here is an example of the same data entry eCriteria database in HTML:

Data entry example (HTML Version)

Download our sample Java code (ver 1.1) that illustrates the desired code structure in order to communicate with eCriteria:

Code for search example

Code for data entry example

There is absolutely no additional software or drivers to install on your web server. The applet is self-contained as it links into eCriteria. You can easily modify the sample source code to match the structure of your own database. The entire process of creating a Java eCriteria-enabled applet takes less than an hour depending on the number of fields in your database. You can get more complex by adding your own Java pull-down lists populated with values matching the structure of your database. It’s pretty much up to you the degree you wish to embellish your applet code.