Nej det virker alligevel ikke...
package sampledir;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/css");
PrintWriter out = response.getWriter();
out.println("<html><head><title>Reservering</title><link rel=\"stylesheet\" href=\"form.jsp\" type=\"text/css\"></head><body class=\"baggrund2\">");
/** her henter vi så den information der er givet fra web siden*/
public static int getInt(HttpServletRequest request, String name, int def)
{
String temp=request.getParameter(name);
if(temp==null || temp.equals("")) return def;
int val=def;
try
{
def=Integer.parseInt(temp);
}
catch (NumberFormatException e)
{
}
return def;
getInt(request,"kunde_navn",- 1);
getInt(request,"bekr_type",-1);
getInt(request,"rsv_type",-1);
getInt(request,"dato_start",-1);
getInt(request,"naetter",-1);
getInt(request,"antal_pers",-1);
getInt(request,"eventuelt",-1);
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://cvusyd.edu/cada01","eks");
if (con!=null)
{
System.err.println("forbindelsen er oprettet");
statement stm=con.createStatement();
stm.executeUpdate(resevationinsert)
String reservationinsert = "INSERT INTO RESEVATIONEN VALUES (" + kunde_navn + ", " + bekr_type + ", " + rsv_type + ", " + dato_start + ", " + naetter + ", " + antal_pers + ", " + evt_forhold + ")
while (rs.next())
{
out.println("<tr>");
out.println("<td>"Resevationen er modtaget, bekraftigelsen vil modtages snares"</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();
}
}
