Developing Web-based Applications

Developing Web-based Applications

This section describes how to create web-based applications with the PSQL JDBC driver.

To develop web based applications using JDBC, you need to place the JDBC jar file in the codebase directory containing the applet classes.

For example, if you are developing an application called MyFirstJDBCapplet, you need to place the pvjdbc2.jar file (or the PSQL jdbc package) in the directory containing the MyFirstJDBCapplet class. For example, it might be C:\inetpub\wwwroot\myjdbc\. This enables the client web browser to be able to download the JDBC driver over the network and connect to the database.

Also, if you use the JAR file, you need to put the archive parameter within the <APPLET> tag. For example,

<applet CODE="MyFirstJDBCapplet.class" ARCHIVE="pvjdbc2.jar" WIDTH=641 HEIGHT=554>

Note: The PSQL engine must be running on the web server that hosts the applet.

Servlets and Java Server Pages

Servlets and Java Server Pages (JSP can be used to create web-based applications with the PSQL JDBC Driver.

The following is a sample Java Server Page for displaying one table in the DEMODATA sample database included with PSQL

<%@ page import="java.sql.*" %>

<%@ page import="java.util.*" %>

Class.forName("com.pervasive.jdbc.v2.Driver");

Connection con = DriverManager.getConnection("jdbc:pervasive://localhost:1583/DEMODATA");

PreparedStatement stmt = con.prepareStatement("SELECT * FROM Course ORDER BY Name");

ResultSet rs = stmt.executeQuery();

<title>PSQL JSP Sample</title>

<h1>PSQL JSP Sample</h1>

<h2>Course table in DEMODATA database</h2>

This example opens the Course table from the DEMODATA

database included with PSQL and

displays the contents of the table

<table border=1 cellpadding=5>

<th>Description</th>

<th>Credit Hours</th>

<th>Department Name</th>

<% while(rs.next()) { %>

<td><%= rs.getString("Name") %></td>

<td><%= rs.getString("Description") %></td>

<td><%= rs.getString("Credit_Hours") %></td>

<td><%= rs.getString("Dept_Name") %></td>

Information on Servlets and JSP

For more information about servlets and JSP, see Oracle’s website.