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.User;
15 import org.cacert.gigi.database.DatabaseConnection;
16 import org.cacert.gigi.output.DateSelector;
17 import org.cacert.gigi.output.Template;
18 import org.cacert.gigi.pages.LoginPage;
19 import org.cacert.gigi.pages.Page;
21 public class AssurePage extends Page {
22 public static final String PATH = "/wot/assure/*";
23 DateSelector ds = new DateSelector("day", "month", "year");
27 super("Assure someone");
28 t = new Template(new InputStreamReader(
29 AssurePage.class.getResourceAsStream("AssureeSearch.templ")));
33 public void doGet(HttpServletRequest req, HttpServletResponse resp)
35 PrintWriter out = resp.getWriter();
37 String pi = req.getPathInfo().substring(PATH.length() - 2);
38 if (pi.length() > 1) {
39 User myself = LoginPage.getUser(req);
40 int mid = Integer.parseInt(pi.substring(1));
41 if (mid == myself.getId()) {
42 out.println("Cannot assure myself.");
46 new AssuranceForm(mid).output(out, getLanguage(req),
47 new HashMap<String, Object>());;
49 HashMap<String, Object> vars = new HashMap<String, Object>();
51 t.output(out, getLanguage(req), vars);
55 public void doPost(HttpServletRequest req, HttpServletResponse resp)
57 PrintWriter out = resp.getWriter();
58 System.out.println("searching for");
60 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
61 "SELECT id FROM users WHERE email=? AND dob=?");
62 ps.setString(1, req.getParameter("email"));
63 String day = req.getParameter("year") + "-"
64 + req.getParameter("month") + "-" + req.getParameter("day");
66 ResultSet rs = ps.executeQuery();
72 out.println("Error, ambigous user. Please contact support@cacert.org");
74 resp.sendRedirect(PATH.substring(0, PATH.length() - 2) + "/"
79 } catch (SQLException e) {