import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import util.*;
import java.util.Vector;
public class Opret extends HttpServlet
{
public void doPost (HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException
{
PrintWriter out;
out = response.getWriter();
StringBuffer buffer = new StringBuffer();
response.setContentType("text/html");
String onavn = request.getParameter ("onavn");
String opass = request.getParameter ("opass1");
Databaseforbindelsemysqlprepared d = new Databaseforbindelsemysqlprepared("jdbc:
mysql://URL/DB?user=USER&password=PASSWORD", "com.mysql.jdbc.Driver");
buffer.append("<html><head><title>Opret</title>\n");
buffer.append("<script language=\"JavaScript\" src=\"./script/script.js\"></script>");
buffer.append("<link rel=\"stylesheet\" type=\"text/css\" href=\"./style/golf.css\">");
buffer.append("</head>");
try
{
Vector vi0 = new Vector();
ResultSet rs = d.select("SELECT username,pass FROM users", vi0);
boolean result=false;
while(rs.next())
{
String navn = rs.getString("username");
if(navn.equals(onavn))
{
result=true;
}
}
if(result) {
buffer.append("<body>");
buffer.append("<div style=\"text-align:center;\"><h1>Beklager, det navn er optaget. Prøv igen :-)</h1></div>");
buffer.append("<div style=\"text-align:right;\"><button class=\"knap\" onclick=\"window.open('./index/ny_bruger_form.html', 'NY');\">Prøv igen</button></div>");
buffer.append("</body></html>");
}
else if(!result)
{
Vector vi1 = new Vector();
vi1.addElement(onavn);
vi1.addElement(opass);
d.insertUpdate("INSERT INTO users (username,pass) VALUES (?,?)", vi1);
buffer.append("<body onload=\"opener.name='opener';document.opret.target='opener';document.opret.submit();self.close();\">");
buffer.append("<form name=\"opret\" action='./' method='post'>");
buffer.append("<input type=\"hidden\" name=\"user\" value=\""+onavn+"\">");
buffer.append("<input type=\"hidden\" name=\"pass\" value=\""+opass+"\">");
buffer.append("</body></html>");
}
} catch (SQLException s) {
out.println("<h3>SQL fejl: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState() + "</h3>");
}
out.println(buffer.toString());
out.close();
// d.close();
}
}
