Jsp Error Cant Get Data from database

Thread view:

lucifer - 22 Jun 2007 08:10 GMT

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(" "+"Connection"+conn+" ");
 try
{
 st = conn.createStatement();
 rt=st.executeQuery("select * from a.a");
 while(rt.next())
 {
 String y;
 String str;
 x=rt.getInt("id1"+" .");
 y= rt.getString("id2"+" .");
 str= rt.getString("id3"+" .");
 out.print(x);
 out.print(y);
 out.print(str);
 }
}
catch(Exception ex)
{

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

%>
<%
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>

Reply to this Message

stefanomnn - 22 Jun 2007 09:05 GMT

> x=rt.getInt("id1"+" .");

what's this???

Reply to this Message

Lew - 22 Jun 2007 12:22 GMT

>> x=rt.getInt("id1"+" .");
>
> what's this???

What stefanomnn points out is that you are trying to get a value from a column
named
"id1 "
and that there isn't any such column in the query.

Is there? Perhaps if the SELECT listed the columns rather than "*" it would
help to debug the code.

Signature

Lew

Reply to this Message

Jsp Error Cant Get Data from database

Free Magazines