Servlet, er det her bare tæt på at være til at køre???
Kom med dine rettelser hvis du har nogle..import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
import java.util.*;
/**
*
* @author damski
* @version
*/
public class Hotellet extends HttpServlet {
/** Initializes the servlet.
*/
public void init(ServletConfig config) throws ServletException
{ super.init(config); }
public void doget(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOEception
{ doPost(request, response); }
/** her bruger vi doPost til at sende oplysninger om den tilsendte resevering tilbage til klienten */
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html><head><title>Reservering</title><link rel=\"stylesheet\" href=\"form.html\" type=\"text/html\"></head><body class=\"baggrund2\">");
/** her henter vi så den information der er givet fra web siden*/
char kunde_navn = request.getParameter("kundenavn");
char bekr_type = request.getParameter("bekrtype");
char rsv_type = request.getParameter("rsvtype");
int dato_start = request.getParameter("ankomsttid");
int naetter = request.getParameter("antal_naetter");
int antal_pers = request.getParameter("db_ankomst");
char eventuelt = request.getParameter("andet");
out.println("<table border=\"0\" align=\"center\" class=\"ramme\" cellpadding=\"1\" cellspacing=\"1\" width=\"200\">");
out.println("<tr><td class=\"baggrund2\">Navn :</td><td class=\"baggrund2\" style=\"font-weight: bold;\"> " + kunde_navn +"</td></tr> ");
out.println("<tr><td class=\"baggrund2\">Bekræftigelses type: </td><td class=\"baggrund2\" style=\"font-weight: bold;\">" + bekr_type +"</td></tr> ");
out.println("<tr><td class=\"baggrund2\">Reseverings type : </td><td class=\"baggrund2\" style=\"font-weight: bold;\">" + rsv_type +"</td></tr>");
out.println("<tr><td class=\"baggrund2\">Ankomst tid : </td><td class=\"baggrund2\" style=\"font-weight: bold;\">" + dato_start +"</td></tr> ");
out.println("<tr><td class=\"baggrund2\">Antal dage :</td><td class=\"baggrund2\" style=\"font-weight: bold;\"> " + naetter +"</td></tr> ");
out.println("<tr><td class=\"baggrund2\">Antal personer :</td><td class=\"baggrund2\" style=\"font-weight: bold;\"> " + antal_pers +"</td></tr>");
out.println("<tr><td class=\"baggrund2\">Eventuelt: </td><td class=\"baggrund2\" style=\"font-weight: bold;\">"+ eventuelt +"</td></tr>");
Connection con=null;
try
{
Class.forname("org.postgresql.Driver") .newInstance();
}
catch (Exception E)
{
out.println("ude af stand til at loade Driver");
//E.printStackTrace();
}
try
{
con.DriverManager.getconnection
("jdbc:postgresql://home/user");
if (con!=null)
{
System.err.println("forbindelsen er oprettet");
statement stm=con.createStatement();
//knr = kundenummeret, fritvnr = værelsesnummeret og rnr = reservationsnummeret
String reservationinsert = "Insert into Reservationen Values(" + kunde_navn + ", " + bekr_type + ", " + rsv_type + ", " + dato_start + ", " + naetter + ", " + antal_pers + ", " + evt_forhold + ")
while (rs.next())
{
out.println("<tr>");
out.println("<td>"Måske en lille lykoenskning her"</td>");
out.println("</tr>");
}
rs.close();
out.println("/table");
}
}
catch (SQLException sqle)
{
out.println(sqle.getmessage());
}
catch (Exception e)
{
out.println(e.getMessage());
}
finally
{
try {
if (con!=null)
{ con.close(); }
}
catch (SQLException sgle)
{
out.println(sqle.getmassage());
}
}
out.println("</body></html>");
out.close();
}
}
