Jsp Error Cant Get Data from database
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>