X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fpages%2Fwot%2FAssurePage.java;fp=src%2Forg%2Fcacert%2Fgigi%2Fpages%2Fwot%2FAssurePage.java;h=dfd72b7b6966a85536a8c2f5cf7b3dd97fe1c61e;hp=e0cb4a211e57aed40125df653ee99a163283807e;hb=a8a6c492e30d4202e499778b69a5354494f86f84;hpb=2f50dbb24105e6345329b8e9ecb5ef4d67ab2a8c diff --git a/src/org/cacert/gigi/pages/wot/AssurePage.java b/src/org/cacert/gigi/pages/wot/AssurePage.java index e0cb4a21..dfd72b7b 100644 --- a/src/org/cacert/gigi/pages/wot/AssurePage.java +++ b/src/org/cacert/gigi/pages/wot/AssurePage.java @@ -2,8 +2,6 @@ package org.cacert.gigi.pages.wot; import java.io.IOException; import java.io.PrintWriter; -import java.sql.Date; -import java.util.Calendar; import java.util.HashMap; import javax.servlet.http.HttpServletRequest; @@ -73,10 +71,10 @@ public class AssurePage extends Page { } try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `users`.`id`, `verified` FROM `users` INNER JOIN `certOwners` ON `certOwners`.`id`=`users`.`id` WHERE `email`=? AND `dob`=? AND `deleted` IS NULL")) { + ds.update(req); + ps.setString(1, req.getParameter("email")); - Calendar c = Calendar.getInstance(); - c.set(Integer.parseInt(req.getParameter("year")), Integer.parseInt(req.getParameter("month")) - 1, Integer.parseInt(req.getParameter("day"))); - ps.setDate(2, new Date(c.getTimeInMillis())); + ps.setDate(2, ds.getDate().toSQLDate()); GigiResultSet rs = ps.executeQuery(); int id = 0; if (rs.next()) { @@ -101,11 +99,12 @@ public class AssurePage extends Page { } } } else { - GigiApiException e = new GigiApiException("I'm sorry, there was no email and date of birth matching" // + throw new GigiApiException("I'm sorry, there was no email and date of birth matching" // + " what you entered in the system. Please double check your information."); - e.format(out, getLanguage(req)); } + } catch (GigiApiException e) { + e.format(out, getLanguage(req)); } } }