src/org/cacert/gigi/pages/wot/AssurePage.java

   1 package org.cacert.gigi.pages.wot;
   2
   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;
  10
  11 import javax.servlet.http.HttpServletRequest;
  12 import javax.servlet.http.HttpServletResponse;
  13
  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;
  18
  19 public class AssurePage extends Page {
  20         public static final String PATH = "/wot/assure";
  21         DateSelector ds = new DateSelector("day", "month", "year");
  22         Template t;
  23
  24         public AssurePage() {
  25                 super("Assure someone");
  26                 t = new Template(new InputStreamReader(
  27                                 AssurePage.class.getResourceAsStream("AssureeSearch.templ")));
  28         }
  29
  30         @Override
  31         public void doGet(HttpServletRequest req, HttpServletResponse resp)
  32                         throws IOException {
  33                 PrintWriter out = resp.getWriter();
  34                 HashMap<String, Object> vars = new HashMap<String, Object>();
  35                 vars.put("DoB", ds);
  36                 t.output(out, getLanguage(req), vars);
  37         }
  38         @Override
  39         public void doPost(HttpServletRequest req, HttpServletResponse resp)
  40                         throws IOException {
  41                 PrintWriter out = resp.getWriter();
  42                 System.out.println("searching for");
  43                 try {
  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");
  49                         ps.setString(2, day);
  50                         ResultSet rs = ps.executeQuery();
  51                         int id = 0;
  52                         if (rs.next()) {
  53                                 id = rs.getInt(1);
  54                         }
  55                         if (rs.next()) {
  56                                 out.println("Error, ambigous user. Please contact support@cacert.org");
  57                         } else {
  58                                 out.println("Found member: " + id);
  59                         }
  60
  61                         rs.close();
  62                 } catch (SQLException e) {
  63                         e.printStackTrace();
  64                 }
  65         }
  66 }