adminSelect.jsp

<html>
<head>
<title>
adminSelect.jsp
</title>
</head>

<%@ page import= "javax.swing.*" %>
<%@ page import= "java.sql.*" %>
<%@ page import= "com.UpdatePayRecord" %>
<%@ page import= "java.util.*" %>
<%@ page import= "com.*"%>
<%@ page import= "java.io.*"%>
<%@ page import = "java.io.IOException"%>
<%@ page import = "com.ArrangePayments"%>
<%@ page import = "com.bankFiles"%>
<body>
<h1>
JBuilder Generated JSP
</h1>
<%
String query = request.getParameter("SQLStatement");
Connection connection = ConnectionPool2.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery( query );
ConnectionPool2.returnConnection(connection);
ResultSetMetaData metaData = resultSet.getMetaData();
int st = metaData.getColumnType(1);
%>
<TABLE BORDER="1" WIDTH="100%">
<%
for(int i = 1; i <= metaData.getColumnCount();i++)
    {
    %>
    <TD>
    <%=" " + metaData.getColumnName(i)+ " "%>
    </TD>
    <%
    }
while(resultSet.next())
    {
    %>
    <TR>
    <%
    for(int i = 1; i <= metaData.getColumnCount();i++)
        {
        System.out.println("displaydata  " +  metaData.getColumnType(i));
        switch(metaData.getColumnType(i))
            {
            case 1:
//System.out.println("displaydata  " +resultSet.getInt(i));
            %><TD>
            <%=resultSet.getString(i)%>
            </TD><%
            break;
            case -1:
//System.out.println("displaydata  " +resultSet.getString(i));
            %><TD>
            <%=resultSet.getString(i)%>
            </TD><%
            break;
            case 6:
//System.out.println("displaydata  " +resultSet.getFloat(i));
            %><TD>
            <%=resultSet.getFloat(i)%>
            </TD><%
            break;
            case -7:
//System.out.println("displaydata  " +resultSet.getBoolean(i));
            %><TD>
            <%=resultSet.getBoolean(i)%>
            </TD><%
            break;
            }
        }
    %>
    </TR>
    <%
    }
%>
</TABLE>
</body>
</html>