Move the "dbObject"s to their own package.

[gigi.git] / src / org / cacert / gigi / pages / Verify.java

diff --git a/src/org/cacert/gigi/pages/Verify.java b/src/org/cacert/gigi/pages/Verify.java
index 32da54250c0d4b1096658ac62f82ebc0b9bf0ba0..2ebd54c5f2d4447ae9fe5a8352a05c53229c8300 100644 (file)
--- a/src/org/cacert/gigi/pages/Verify.java
+++ b/src/org/cacert/gigi/pages/Verify.java
@@ -2,67 +2,54 @@ package org.cacert.gigi.pages;
 
 import java.io.IOException;
 import java.io.PrintWriter;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.SQLException;
 
 import javax.servlet.http.HttpServletRequest;
 import javax.servlet.http.HttpServletResponse;
 
-import org.cacert.gigi.database.DatabaseConnection;
+import org.cacert.gigi.GigiApiException;
+import org.cacert.gigi.dbObjects.Domain;
+import org.cacert.gigi.dbObjects.EmailAddress;
 
 public class Verify extends Page {
-       public static final String PATH = "/verify";
 
-       public Verify() {
-               super("Verify email");
-       }
+    public static final String PATH = "/verify";
+
+    public Verify() {
+        super("Verify email");
+    }
+
+    @Override
+    public boolean needsLogin() {
+        return false;
+    }
+
+    @Override
+    public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
+        PrintWriter out = resp.getWriter();
+        String hash = req.getParameter("hash");
+        String type = req.getParameter("type");
+        String id = req.getParameter("id");
+        if ("email".equals(type)) {
+            try {
+                EmailAddress ea = EmailAddress.getById(Integer.parseInt(id));
+                ea.verify(hash);
+                out.println("Email verification completed.");
+            } catch (IllegalArgumentException e) {
+                out.println(translate(req, "The email address is invalid."));
+            } catch (GigiApiException e) {
+                e.format(out, getLanguage(req));
+            }
+        } else if ("domain".equals(type)) {
+            try {
+                Domain ea = Domain.getById(Integer.parseInt(id));
+                ea.verify(hash);
+                out.println("Domain verification completed.");
+            } catch (IllegalArgumentException e) {
+                out.println(translate(req, "The domain address is invalid."));
+            } catch (GigiApiException e) {
+                e.format(out, getLanguage(req));
+            }
+        }
+    }
 
-       @Override
-       public boolean needsLogin() {
-               return false;
-       }
-
-       @Override
-       public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
-               PrintWriter out = resp.getWriter();
-               String hash = req.getParameter("hash");
-               String type = req.getParameter("type");
-               String id = req.getParameter("id");
-               if ("email".equals(type)) {
-                       try {
-                               PreparedStatement ps = DatabaseConnection.getInstance().prepare(
-                                       "select email, memid from `email` where `id`=? and `hash`=? and `hash` != '' and `deleted` = 0");
-                               ps.setString(1, id);
-                               ps.setString(2, hash);
-                               ResultSet rs = ps.executeQuery();
-                               rs.last();
-                               if (rs.getRow() == 1) {
-                                       PreparedStatement ps1 = DatabaseConnection.getInstance().prepare(
-                                               "update `email` set `hash`='', `modified`=NOW() where `id`=?");
-                                       ps1.setString(1, id);
-                                       ps1.execute();
-                                       PreparedStatement ps2 = DatabaseConnection.getInstance().prepare(
-                                               "update `users` set `verified`='1' where `id`=? and `email`=? and `verified`='0'");
-                                       ps2.setString(1, rs.getString(2));
-                                       ps2.setString(2, rs.getString(1));
-                                       ps2.execute();
-                                       out.println("Your email is good.");
-                               } else {
-                                       out.println("Your request is invalid");
-                               }
-                       } catch (SQLException e) {
-                               e.printStackTrace();
-                       }
-               }
-       }
-
-       @Override
-       public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
-               String hash = req.getParameter("hash");
-               String type = req.getParameter("type");
-               if ("email".equals(type)) {
-
-               }
-       }
 }