Jsp Error Cant Get Data from database

From:

lucifer <umeshktangnu@gmail.com>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 22 Jun 2007 07:10:02 -0000

Message-ID:

<1182496202.645178.64290@j4g2000prf.googlegroups.com>

Hi
i am writing a JSP page which connects to Mysql DataBase
i can get the connection but i cant get to execute the query on the
database
plz help

the code of jsp file

<%@ page import ="java.lang.*" %>
<%@ page import ="java.sql.*" %>
<html>
<head>
<title>
Index Page
</title>
</head>
<body>
jsp pages is better than ASP.NET
<%
int x;

Connection conn=null;
Statement st=null;
ResultSet rt=null;
String query="select * from user";

    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/
mysql","root","aaaa");

    if(conn==null)
    {
        out.print("not connected");
    }
    out.print("<br>"+"Connection"+conn+"<br>");
    try
{
    st = conn.createStatement();
    rt=st.executeQuery("select * from a.a");
    while(rt.next())
    {
        String y;
        String str;
        x=rt.getInt("id1"+"<br />.");
        y= rt.getString("id2"+"<br />.");
        str= rt.getString("id3"+"<br />.");
        out.print(x);
        out.print(y);
        out.print(str);
    }
}
catch(Exception ex)
{

        out.print("<br>");
out.print("Timeoooo "+"<br />");
}
finally
{
    if (rt != null) rt.close();
    if (st != null) st.close();
    if (conn != null) conn.close();
    out.print("<br>");
out.print("Timeoooo"+"<br />");
}

%>
<%
conn = null;
st = null;
ResultSet rs = null;

try {
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    conn =
      DriverManager.getConnection("jdbc:mysql://localhost:
3306/","root","aaaa");

    st = conn.createStatement();
    rs = st.executeQuery("select * from a.employees");
    while(rs.next()) {
%>
<TR><TD><%= rs.getString("lname_txt") %></TD>
<TD><%= rs.getString("fname_txt") %></TD></TR>
<%
     }
%>
</TABLE>
<%
} catch (Exception ex) {
    ex.printStackTrace();
    %>
</TABLE>
Ooops, something bad happened:
<%
    } finally {
    if (rs != null) rs.close();
    if (st != null) st.close();
    if (conn != null) conn.close();
    }
%>
</body>
</html>