Java or JSP				Download the whitepaper on JSP Classes and Jars SMTP information for Jmail Database connectivity: MySQL and PostgreSQL Registering a database driver Adding a survey to a database using JSP Secure server for JSP FAQ

CGI/Perl ASP and VB Java (JSP) PHP

<%@ page language=java %>
<%@ page import='java.sql.*' %>
<%@ page import='javax.sql.*' %>
<%@ page import='javax.naming.*' %>

<%
Context env = (Context) new InitialContext().lookup("java:comp/env");
DataSource source = (DataSource) env.lookup("jdbc/your_domain_name");

Connection conn = source.getConnection();
try {
Statement stmt = conn.createStatement();

String name = request.getParameter("name");
String color = request.getParameter("color");

stmt.executeUpdate(
"insert into COLORS values (" +
"'" + name + "', '" + color + "')"
);

} finally {
conn.close();
}

%>

<h1>Thank you, <%= name %></h1>

Ensure that the database connection is closed, so that it automatically returns to the pool.

Using the try through to finally syntax will guarantee that the connections are returned to the database connection pool.