%@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);
}
}
}
}
%>