1 package org.cacert.gigi.pages.wot;
3 import java.io.IOException;
4 import java.io.InputStreamReader;
5 import java.io.PrintWriter;
6 import java.sql.PreparedStatement;
7 import java.sql.ResultSet;
8 import java.sql.SQLException;
9 import java.util.HashMap;
11 import javax.servlet.http.HttpServletRequest;
12 import javax.servlet.http.HttpServletResponse;
14 import org.cacert.gigi.database.DatabaseConnection;
15 import org.cacert.gigi.output.DateSelector;
16 import org.cacert.gigi.output.Template;
17 import org.cacert.gigi.pages.Page;
19 public class AssurePage extends Page {
20 public static final String PATH = "/wot/assure/*";
21 DateSelector ds = new DateSelector("day", "month", "year");
25 super("Assure someone");
26 t = new Template(new InputStreamReader(
27 AssurePage.class.getResourceAsStream("AssureeSearch.templ")));
31 public void doGet(HttpServletRequest req, HttpServletResponse resp)
33 PrintWriter out = resp.getWriter();
35 String pi = req.getPathInfo().substring(PATH.length() - 2);
36 if (pi.length() > 1) {
37 out.println("I am a Placeholder for the Assurance form # ");
38 out.println(pi.substring(1));
40 HashMap<String, Object> vars = new HashMap<String, Object>();
42 t.output(out, getLanguage(req), vars);
46 public void doPost(HttpServletRequest req, HttpServletResponse resp)
48 PrintWriter out = resp.getWriter();
49 System.out.println("searching for");
51 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
52 "SELECT id FROM users WHERE email=? AND dob=?");
53 ps.setString(1, req.getParameter("email"));
54 String day = req.getParameter("year") + "-"
55 + req.getParameter("month") + "-" + req.getParameter("day");
57 ResultSet rs = ps.executeQuery();
63 out.println("Error, ambigous user. Please contact support@cacert.org");
65 resp.sendRedirect(PATH.substring(0, PATH.length() - 2) + "/"
70 } catch (SQLException e) {