Exception, men jeg forstår ikek hvorfor?
Hvad er det som er galt med det her? Jeg er løbet tør for ideerimport java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import util.*;
import java.util.Vector;
public class Login extends HttpServlet
{
public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
response.setContentType("text/html");
StringBuffer buffer = new StringBuffer();
String navn = request.getParameter ("navn");
String pass = request.getParameter ("pass");
out = response.getWriter();
buffer.append("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">");
buffer.append("<html><head><title>");
buffer.append("Login");
buffer.append("</title>");
buffer.append("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">");
buffer.append("</head>");
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("jdbc:mysql://192.168.1.11/DB?user=USER&password=PASS","com.mysql.jdbc.Driver");
try {
Vector vi = new Vector();
vi.addElement(navn);
vi.addElement(pass);
ResultSet rs = d.select("SELECT name,password FROM users WHERE name=? AND password=?", vi);
if(rs.next()) {
HttpSession session = request.getSession(true);
session.setMaxInactiveInterval(600);
String SessionIndhold = navn;
session.setAttribute("brugernavn", SessionIndhold);
// Who is requesting??
String remoteadr = request.getRemoteAddr();
// Server time?
Dato da = new Dato();
String dato = da.nyDato();
System.out.println(navn+" har oprettet en session. Request fra: "+remoteadr+" Logget på: "+dato);
buffer.append("<body onload='document.send.submit();');>");
buffer.append("<form name='send' action='Start' method='post'>");
buffer.append("<input type='hidden' name='page' value='"+navn+"'>");
buffer.append("<input type='hidden' name='sel' value=''>");
buffer.append("</form>");
buffer.append("</body></html>");
}
else
{
buffer.append("<body>");
buffer.append("<form action='/' method='get'>");
buffer.append("<h1>Wrong username or password</h1>");
buffer.append("<input type='submit' value='Try again'>");
buffer.append("</form>");
buffer.append("</body></html>");
}
} catch (SQLException s) {
buffer.append("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
out.println(buffer.toString());
out.close();
d.close();
}
}
