Re: Programming using JSP and Tomcat: cannot be resolved to a type error

From:

Vincent Ly <vsector@gmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Mon, 30 Nov 2009 17:53:56 -0800 (PST)

Message-ID:

<f8851d34-0cbf-4bbb-866c-e638dae48052@k4g2000yqb.googlegroups.com>

Ah, right. This is the code I was using.

<h3>JSP and JDBC</h3>
<hr>

    <%-- JSP directive --%>
    <%@ page import="java.net.*, java.io.*, java.sql.*, java.util.*"
%>

    <%-- JSP scriplet --%>
    <%
            String query=request.getParameter("query");

            try
                {

                        Connection.Connect con = new Connection.Connect
();
                        ResultSet rs = con.execute(query);

                        int numCols = rs.getMetaData().getColumnCount
();

                        %><TABLE BORDER=2 ALIGN=LEFT><%
                        %><TR><%
                        int j=0;
                        for (j=1; j<=numCols; j++)
                                   out.println("<TH>"+
                           rs.getMetaData().getColumnName(j)+"</TH>");
                        %></TR><%

                        while (rs.next())
                          {
                          %><TR><%
                            int i=0;
                            for (i=1; i<=numCols; i++)
                                out.println("<TD>"+rs.getString(i)+"</
TD>");
                          %></TR><%
                          }
                        %></TABLE><%

                        con.close();
            }
            catch (Exception e)
                {out.println(e.toString());}

    %>