ResultSet can not print the first row

[Shounak Kundu]

Here's my code :

										ResultSet rs = null;
										ResultSet rs1 = null;
										PreparedStatement ps = null;
										PreparedStatement ps1 = null;
										Connection con =null;
										
										String cmpid  = session.getAttribute("cmpid").toString();
										
										String cmpemail = session.getAttribute("cmpemail").toString();
										
										try
										{
											InitialContext ctx = new InitialContext();
											
											DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/MyDataSource");
											
											con = ds.getConnection();
											
											String query = "SELECT * FROM JOBAPPLICATION WHERE CMPID=?";
											
											ps = con.prepareStatement(query);
											
											ps.setString(1,cmpid);
											
											rs = ps.executeQuery();
											
											if(rs.next())
											{
													out.println("<table border=\"1\">");
												
													out.println("<th align=\"justify\">JOB ID</th>");
												
													out.println("<th align=\"justify\">JOBSEEKER ID</th>");
												
													out.println("<th align=\"justify\">JOBSEEKER EMAIL</th>");
													
												while(rs.next())
												{
													out.println("<tr>");
													
													String jobid = rs.getString("JOBID");
													
													String jskid = rs.getString("JSKID");
													
													String jskemail = rs.getString("JSKEMAIL");
													
													
													
													out.println("<td>"+jobid+"<td>");
													
													out.println("<td>"+jskid+"</td>");
													
													out.println("<td>"+jskemail+"</td>");
													
													out.println("</tr>");		
												}
											
												
												out.println("</table>");
														
													
											}
											
											else
											{
												
												
												out.println("<font color=\"red\"><strong>Sorry, no one has applied to your jobs.</strong></font>");		
												
											}
											
											
											
										}catch(NamingException ne)
										{
											
											
										}catch(SQLException se)
										{
											
										}
										
									
									
									
									

My Problem is that :
This code does not print the very first row.

How can I do that ?

Also the table is distorted..

Please help

[Campbell Ritchie]

Check the documentation for ResultSet.next(). Not certain, but I think you are going to the first row when you call if (rs.next()) . . . and when you get to the while (rs.next()) . . . loop, you are going to the second row.

[Greg Charles]

Campbell is right. Each time you call "rs.getNext()" you move the cursor down one row. That means on the first iteration of your loop, you'll be getting data out of the second row. Use a do-while loop instead.


(Alternatively, you could call "rs.beforeFirst()" after doing your initial check, but it's more fun to annoy the people who lay down the hate against poor, poor do-while.)

[Deepak Bala]

but it's more fun to annoy the people who lay down the hate against poor, poor do-while

I didnt know they existed

[Campbell Ritchie]

Deepak Bala wrote: . . . I didnt know they existed

You'd be surprised