Query Database Sample

This sample demonstrates how to use Resin's built-in database connection pooling to easily manage database connectivity. Note that this sample will not work correctly if you do not have a package that includes a database. Select one of the following pre-installed Resin JDBC resources:

• jdbc/amnon

Manage Sample Database

This page can be used to manage the sample database tables used for the samples. You can easily remove the sample tables from your database to clean things up for your own application. Or you can restore the sample database tables to their original condition. Note that this sample will not work correctly if you do not have a package that includes a database. Select one of the following pre-installed Resin JDBC resources:

• jdbc/amnon

Other Examples

A simple example of using Resin's connection pooling can be found within the Resin documenation that comes pre-installed with your Servlets.Net account. It is also available at http://www.caucho.com/products/resin/java_tut/db_form.xtp.

An SQL reference specific to the MySQL database can be found on the MySQL website.

You can find information on the O'Reilly site to help get started learning about the SQL query language in general.

There is a JDBC Tutorial available on Sun's Java Technology website. By using Resin's connection pooling, it is much simpler to obtain a database connection than is demonstrated on the JDBC Tutorial on Sun's site.

Your account allows you to use Server Side Includes (SSI). Just name your files with a *.shtml extention. See the hello.shtml example as well as the source for it.

PHP applications are also supported by the Servlets.Net web server. A simple hello.php3 example is available as well as the source for it.