The JDBCQuery JSP

<%@ page import="java.sql.*" %> The JDBCQuery JSP <% String connStr=request.getParameter("connStr"); if (connStr==null) { connStr=(String)session.getValue("connStr"); } else { session.putValue("connStr",connStr); } if (connStr==null) { %> <% } %> <% String searchCondition = request.getParameter("cond"); if (searchCondition != null) { %>

Search results for : <%= searchCondition %>

<%= runQuery(connStr,searchCondition) %>

<% } %> Enter a search condition:

<%! private String runQuery(String connStr, String cond) throws SQLException { Connection conn = null; Statement stmt = null; ResultSet rset = null; try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); conn = DriverManager.getConnection(connStr, "scott", "tiger"); stmt = conn.createStatement(); rset = stmt.executeQuery ("SELECT ename, sal FROM scott.emp "+ (cond.equals("") ? "" : "WHERE " + cond )); return (formatResult(rset)); } catch (SQLException e) { return ("

SQL error:

 " + e + "

\n"); } finally { if (rset!= null) rset.close(); if (stmt!= null) stmt.close(); if (conn!= null) conn.close(); } } private String formatResult(ResultSet rset) throws SQLException { StringBuffer sb = new StringBuffer(); if (!rset.next()) sb.append("

No matching rows.

\n"); else { sb.append("

"); do { sb.append("
" + rset.getString(1) + " earns $ " + rset.getInt(2) + ".
\n"); } while (rset.next()); sb.append("

"); } return sb.toString(); } %>