Hi Bhaskar Duvvuri :
I hope you are the same Sunny that has been sending me private messages. It is easier for me or anyone else to assist you here on javaranch than thru the use of private messages.
Now I want you to try this code.
Jus copy it and paste on your JSP page, tell us what the outcome is and lets go from there.
dbconn = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
sql = dbconn.prepareStatement("SELECT AdStore.AdId, " +
"AdStore.AdType, " +
"AdStore.AdDesc FROM AdStore " +
"WHERE (((AdStore.AdStatus)='" + activeStatus + "'))");
ResultSet rs = sql.executeQuery();
int recnum = 0;
while(rs.next())
{
System.out.println("Got more rows\n");
recnum ++;
String id = rs.getString(1) ;
out.println("<tr>");
out.println("<font color=\"blue\" size =\"3\"></size></font>");
out.println("<td>" + id + "</td>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("<td><A HREF='PlaceBid.jsp?ad=\" + id + \"'>Bid</A></td>");
System.out.println("The link is: \n" +
"<td><A HREF='PlaceBid.jsp?ad=\" + id + \"'>Bid</A></td>");
out.println("</tr>") ;// not very necessarily since the start of a <tr> automatically closes the previous <tr>
}
I do not see the start and end of your table tags. If they are not there please add them.
If this does not work, you might have to remove everything like font and colors and have just plain html, that will make things less clustered and easier to spot errors. After we might have had a working html then you can add your fonts and colors. Do not be discouraged by this initial difficulties. With the help of those of us at JavaRanch and hard work on your part, you sure will overcome this initail difficulties.
Let us know which error if any that is generated this time around.