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();
34 HashMap<String, Object> vars = new HashMap<String, Object>();
36 t.output(out, getLanguage(req), vars);
39 public void doPost(HttpServletRequest req, HttpServletResponse resp)
41 PrintWriter out = resp.getWriter();
42 System.out.println("searching for");
44 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
45 "SELECT id FROM users WHERE email=? AND dob=?");
46 ps.setString(1, req.getParameter("email"));
47 String day = req.getParameter("year") + "-"
48 + req.getParameter("month") + "-" + req.getParameter("day");
50 ResultSet rs = ps.executeQuery();
56 out.println("Error, ambigous user. Please contact support@cacert.org");
58 out.println("Found member: " + id);
62 } catch (SQLException e) {