FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Jsp Error Cant Get Data from database





umeshtangnu
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

Code:
<%@ 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>
Related topics
avoid super cookies
Mysql database problem
Need help with Wordpress Please............
hierarchical data/nested/mlm table design ???
An ip 2 location system in design, interesting find
error: 1146 data base not found some one can help???
MySQL and PHP Question
Data Error [47 OF 94 93 F4 K5]
How to preset the MySQL error?
Error -> The host or user argument to GRANT is too long
500 Error/Datebase Error for the past 48+ hours
error connecting database
Internal server error and database not found
connect android app to mySQL database(5 steps)
Reply to topic    Frihost Forum Index -> Scripting -> Others

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.