InteractiveQuery.jsp

<!doctype html public "-//w3c/dtd HTML 4.0//en">
<html>

<!-- Creates an HTML page that can be used interactively to take
input from a client and then structure a query with it.
Copyright (c) 1999-2000 by BEA Systems, Inc. All Rights Reserved.-->

<head>
<title>Interactive Query</title>
</head>
<body bgcolor=#FFFFFF>
<font face="Helvetica">

<h2>
<font color=#DB1260>
Interactive Query
</font>
</h2>

<%@ import="
weblogic.db.jdbc.*, 
java.sql.*
" %>

<%!
Connection conn  = null;
String jdbcClass = "COM.cloudscape.core.JDBCDriver";
String jdbcURL   = "jdbc:cloudscape:demo";

public Connection getCon() {
  try {
    Class.forName(jdbcClass).newInstance();
    conn = DriverManager.getConnection(jdbcURL);
  } catch (Exception e) {}
  return conn;
}
%>

<%
try {
  conn = getCon();
  if (conn != null) {
    Statement stmt = conn.createStatement();
    stmt.execute("select * from emp");
    ResultSet ds = stmt.getResultSet();
      
    String myURL  = request.getRequestURI();
    String person = request.getParameter("person");
      
    if (person == null) {
%>

      <table border=1 cellpadding=5>
        <th>Employee no</th>
        <th>Select a name</th>
        <th>Job</th>
        <th>Manager</th>
        <th>Date of hire</th>
        <th>Salary</th>
        <th>Commission</th>
        <th>Dept no</th>

<%
      while (ds.next()) {
        String ename = "<a href=" + myURL + "?person=" +
	                  ds.getString("ename") + ">" +
		             ds.getString("ename") + "</a>";
%>

        <tr>
          <td><%= ds.getString("empno") != null ? ds.getString("empno") : " " %></td>
          <td><%= ename %></td>
          <td><%= ds.getString("job") != null ? ds.getString("job") : " " %></td>
          <td><%= ds.getString("mgr") != null ? ds.getString("mgr") : " " %></td>
          <td><%= ds.getString("hiredate") != null ? ds.getString("hiredate") : " " %></td>
          <td><%= ds.getString("sal") != null ? ds.getString("sal") : " " %></td>
          <td><%= ds.getString("comm") != null ? ds.getString("comm") : " " %></td>
          <td><%= ds.getString("deptno") != null ? ds.getString("deptno") : " " %></td>
        </tr>

<%
      }
%>      

      </table>

<%
      ds.close();
      conn.close();
      out.flush();
    }
    else {
%>    

      <p>
      <b>Results of your interactive query</b>:
      <p>
      You chose person: <%= person %>

<%
    }
  }
  else {
    out.print("Sorry. Database is not available.");
  }
} catch (Exception e) {
  out.print("Exception: " + e);
}
%>

<p>
<font size=-1>Copyright (c) 1999-2000 by BEA Systems, Inc. All Rights Reserved.
</font>

</font>
</body>
</html>