Java Reference
In-Depth Information
out.println("</HTML>");
out.fl ush();
System.exit(1);
}
try
{
statement = link.createStatement();
ResultSet results =
statement.executeQuery(
"SELECT * FROM PhoneNums");
out.println("Updated table:");
out.println("<BR><BR><CENTER>");
out.println("<TABLE BORDER>");
out.println("<TR><TH>Surname</TH>");
out.println("<TH>Forename(s)</TH>");
out.println("<TH>Phone No.</TH></TR>");
while (results.next())
{
out.println("<TR>");
out.println("<TD>");
out.println(results.getString("Surname"));
out.println("</TD>");
out.println("<TD>");
out.println(results.getString("Forenames"));
out.println("</TD>");
out.println("<TD>");
out.println(results.getString("PhoneNum"));
out.println("</TD>");
out.println("</TR>");
}
out.println("</TABLE>");
}
catch(SQLException sqlEx)
{
out.println(
"<BR><H2>Unable to retrieve data!</H2>");
out.println("</BODY>");
out.println("</HTML>");
out.fl ush();
System.exit(1);
}
out.println("</CENTER>");
out.println("<BODY>");
Search WWH ::
Custom Search