<%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <%@page import="javax.sql.DataSource"%> <%@page import="javax.naming.InitialContext"%> <%@page import="javax.naming.Context"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% this.testSelect(); %>

Results

<%= this.foo %>
<%! String foo = "Not Connected"; public void testSelect() { Connection conn = null; try { Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/DS1"); conn = ds.getConnection(); PreparedStatement pstmt = conn.prepareStatement("SELECT current date FROM sysibm.sysdummy1;"); ResultSet rst = pstmt.executeQuery(); foo = ""; if (rst.next()) { foo += rst.getString(1); } } catch (Exception e) { foo = String.valueOf(e); } finally { if (null != conn) { try { conn.close(); } catch (Exception e) { foo = String.valueOf(e); } } } } %>