<%@ page import="sqlj.runtime.ref.DefaultContext,oracle.sqlj.runtime.Oracle" %> The SQLJSelectInto JSP <% String connStr=request.getParameter("connStr"); if (connStr==null) { connStr=(String)session.getValue("connStr"); } else { session.putValue("connStr",connStr); } if (connStr==null) { %> <% } %> <% String empno = request.getParameter("empno"); if (empno != null) { %>

Employee # <%=empno %> Details:

<%= runQuery(connStr,empno) %>

<% } %> Enter an employee number:
<%! private String runQuery(String connStr, String empno) throws java.sql.SQLException { DefaultContext dctx = null; String ename = null; double sal = 0.0; String hireDate = null; StringBuffer sb = new StringBuffer(); try { dctx = Oracle.getConnection(connStr, "scott", "tiger"); #sql [dctx] { SELECT ename, sal, TO_CHAR(hiredate, 'DD-MON-YYYY') INTO :ename, :sal, :hireDate FROM scott.emp WHERE UPPER(empno) = UPPER(:empno) }; sb.append("
\n");
        sb.append("Name       : " + ename + "\n");
	sb.append("Salary     : " + sal + "\n");
	sb.append("Date hired : " + hireDate);
        sb.append("
"); } catch (java.sql.SQLException e) { sb.append("

SQL error: 

 " + e + "

\n"); } finally { if (dctx!= null) dctx.close(); } return sb.toString(); } %>