<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"
import="javax.naming.*,javax.sql.*,java.sql.*,java.io.*"
%>
Datasource Test
<%
if(request.getParameter("jndiName") != null) {
// PrintWriter writer = response.getWriter();
out.write("Results of Test11111111
");
String jndiName = request.getParameter("jndiName");
try {
InitialContext ctx = new InitialContext();
DataSource ds = null;
if (System.getProperty("istomcat")==null){
ds = (DataSource)ctx.lookup(jndiName);
}else{
ds = (DataSource)ctx.lookup("java:/comp/env/"+jndiName);
}
out.write("Successfully looked up DataSource named " + jndiName + "
");
if(request.getParameter("tableName") != null) {
String tableName = request.getParameter("tableName");
Connection conn = null;
Statement stmt = null;
conn = ds.getConnection();
out.write("Successfully connected to database.
");
stmt = conn.createStatement();
String query = "SELECT * FROM " + tableName;
out.write("Attempting query \"" + query + "\"
");
ResultSet results = stmt.executeQuery(query);
ResultSetMetaData rsMetaData = results.getMetaData();
int numberOfColumns = rsMetaData.getColumnCount();
out.write("");
//Display the header row of column names
for (int i = 1; i <= numberOfColumns; i++) {
int columnType = rsMetaData.getColumnType(i);
String columnName = rsMetaData.getColumnName(i);
if(columnType == Types.VARCHAR) {
out.write("| " + columnName + " | ");
}
}
out.write("
");
//Print the values (VARCHAR’s only) of each result
while(results.next()) {
out.write("");
for (int i = 1; i <= numberOfColumns; i++) {
int columnType = rsMetaData.getColumnType(i);
String columnName = rsMetaData.getColumnName(i);
if(columnType == Types.VARCHAR) {
out.write("| " + results.getString(columnName) + " | ");
}
}
out.write("
");
}
out.write("
");
stmt.close();
//conn.close();
}
}catch(Exception e) {
out.write("An exception was thrown: " + e.getMessage() + "
");
e.printStackTrace();
}
} else {
%>
Test an EAP Datasource
<% } %>