Reputation: 164
I am trying to Select data from a Table Clients, and display it using a servlet in the form of an HTML table. The problem I face is in the display of the table, the cells in each row do not match with the cells from the next row in width, how can it fix this ?
Problem solved
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection cnx=DriverManager.getConnection("jdbc:derby://localhost:1527/ndb","me","123");
Statement st=cnx.createStatement();
ResultSet rs=st.executeQuery("Select * from Clients");
out.println("<HTML>");
// Start on the body
out.println("<BODY>");
out.println("<CENTER>");
out.println("<table BORDER=1 CELLPADDING=0 CELLSPACING=0 WIDTH=50% >");
while (rs.next()){
out.println("<tr>");
out.print("<td>"+rs.getString("CIN")+ "</td>");
out.print("<td>"+rs.getString("NOM")+ "</td>");
out.print("<td>"+rs.getString("PRENOM")+ "</td>");
out.print("<td>"+rs.getString("TEL")+ "</td>");
out.print("<td>"+rs.getString("EMAIL")+ "</td>");
out.print("<td>"+rs.getString("SEX")+ "</td>");
out.println("</tr>");
}
} catch(Exception ex){
}
out.println("</table>");
out.println("</CENTER>");
out.println("</BODY></HTML>");
}
Upvotes: 2
Views: 8487