ELSE uden IF
import java.io.*;import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class Showdata extends HttpServlet
{
public void doGet (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
String pageID = request.getParameter ("pageID");
String firstcell = "50";
response.setContentType("text/html");
// out = response.getWriter();
// if (pageID == null)
// {
// pageID = "start";
// }
out.println("<html><head>");
out.println("<link rel='stylesheet' type='text/css' href='../style/styles.css'>");
out.println("<style>");
out.println("body { background:transparent;margin='5px,10px,0px,5px';}");
out.println("</style>");
out.println("</head>");
out.println("<body>");
out.println("<table border='0' cellpadding='0' cellspacing='0' style='width:100%;'>");
Databaseforbindelsemysql d = new Databaseforbindelsemysql("jdbc:mysql://URL/DB?user=USER&password=USER","org.gjt.mm.mysql.Driver");
try {
if(pageID.equals("news")){
ResultSet rsnews = d.select("SELECT datee,news FROM news ORDER BY id DESC");
while (rsnews.next()) {
String date = rsnews.getString("datee").replaceAll("\n","<BR>");
String news = rsnews.getString("news").replaceAll("\n","<BR>");
System.out.println(date+news);
out.println("<tr><td class='celltext' style='width:30%;'>");
out.println(date);
out.println("</td><td class='celltext'>");
out.println(news);
out.println("</td></tr>");
out.println("<tr style='height:10px;'><td></td></tr>");
}
else if(pageID.equals("guestbook")){
System.out.println("guestbook");
}
}
else
{
ResultSet rs = d.select("select content,content1 from pages where name='"+pageID+"'");
if (rs.next()) {
String content = rs.getString("content").replaceAll("\n","<BR>");
String content1 = rs.getString("content1").replaceAll("\n","<BR>");
out.println("<tr><td class='celltext' style='width:"+firstcell+"%;'>");
out.println(content);
out.println("</td><td class='celltext'>");
out.println(content1);
out.println("</td></tr>");
}
else
{
System.out.println("No records in resultset");
}
}
out.println("</table></body>");
out.println("</html>");
out.close();
} catch (SQLException s) {
out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
d.close();
}
}
