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;
13 import javax.servlet.http.HttpSession;
15 import org.cacert.gigi.User;
16 import org.cacert.gigi.database.DatabaseConnection;
17 import org.cacert.gigi.output.DateSelector;
18 import org.cacert.gigi.output.Template;
19 import org.cacert.gigi.pages.LoginPage;
20 import org.cacert.gigi.pages.Page;
22 public class AssurePage extends Page {
23 public static final String PATH = "/wot/assure";
24 public static final String SESSION = "/wot/assure/FORM";
25 DateSelector ds = new DateSelector("day", "month", "year");
29 super("Assure someone");
30 t = new Template(new InputStreamReader(
31 AssurePage.class.getResourceAsStream("AssureeSearch.templ")));
35 public void doGet(HttpServletRequest req, HttpServletResponse resp)
38 PrintWriter out = resp.getWriter();
39 String pi = req.getPathInfo().substring(PATH.length());
40 if (pi.length() > 1) {
41 User myself = LoginPage.getUser(req);
42 int mid = Integer.parseInt(pi.substring(1));
43 if (mid == myself.getId()) {
44 out.println("Cannot assure myself.");
48 HttpSession hs = req.getSession();
49 AssuranceForm form = (AssuranceForm) hs.getAttribute(SESSION);
50 if (form == null || form.assuree.getId() != mid) {
51 form = new AssuranceForm(mid);
52 hs.setAttribute(SESSION, form);
55 form.output(out, getLanguage(req), new HashMap<String, Object>());;
57 HashMap<String, Object> vars = new HashMap<String, Object>();
59 t.output(out, getLanguage(req), vars);
63 public void doPost(HttpServletRequest req, HttpServletResponse resp)
65 PrintWriter out = resp.getWriter();
66 String pi = req.getPathInfo().substring(PATH.length());
67 if (pi.length() > 1) {
68 AssuranceForm form = (AssuranceForm) req.getSession().getAttribute(
71 out.println("No form found. This is an Error. Fill in the form again.");
74 form.submit(out, req);
79 System.out.println("searching for");
81 PreparedStatement ps = DatabaseConnection.getInstance().prepare(
82 "SELECT id FROM users WHERE email=? AND dob=?");
83 ps.setString(1, req.getParameter("email"));
84 String day = req.getParameter("year") + "-"
85 + req.getParameter("month") + "-" + req.getParameter("day");
87 ResultSet rs = ps.executeQuery();
92 out.println("Error, ambigous user. Please contact support@cacert.org.");
94 resp.sendRedirect(PATH + "/" + id);
97 out.print("<div class='formError'>");
98 out.println(translate(
100 "I'm sorry, there was no email and date of birth matching"
101 + " what you entered in the system. Please double check"
102 + " your information."));
107 } catch (SQLException e) {