You are here:
<%@ page import="javax.naming.*"%> <%@ page import="java.sql.*"%> <%@ page import="javax.sql.DataSource"%> <% Context ctx = null; DataSource ds = null; Connection dbConnection = null; Statement statement = null; ResultSet rs = null; String subCat = ""; try { ctx = new InitialContext(); ds = (DataSource) ctx.lookup("java:comp/env/jdbc/oraprod"); dbConnection = ds.getConnection(); statement = dbConnection.createStatement(); String strResult = ""; String sqlQuery = ""; %>

Product Search

"; out.print(strResult); strResult = ""; out.print(strResult); %> <% // do sub type, only those available to www sqlQuery = "select cat_type, sub_type from products.catsubs where sub_type in (select sub_type from products.web_agsocat) order by cat_type, sub_type"; rs = statement.executeQuery(sqlQuery); while (rs.next()) { subCat = subCat + rs.getString("CAT_TYPE") + "$" + rs.getString("SUB_TYPE") + ";"; } //end while %>
Product/Map title: 
(e.g. Mount Isa)
Product type: 
Product sub type: 
Product theme: 
(press down Ctrl key for multiple choices)
Product Number (GEOCAT): 
Surname of author: 
Maximum number of results: 
 
<% out.flush(); } catch (Exception e) { e.printStackTrace(); out.println(e); out.flush(); } finally { try { if (rs != null) rs.close(); if (statement != null) statement.close(); if (dbConnection != null) dbConnection.close(); if (ctx != null) ctx.close(); } catch (Exception e) { /*ignore*/ } } %>