src/org/cacert/gigi/pages/account/MailOverview.java

   1 package org.cacert.gigi.pages.account;
   2
   3 import java.io.IOException;
   4 import java.sql.PreparedStatement;
   5 import java.sql.ResultSet;
   6 import java.sql.SQLException;
   7
   8 import javax.servlet.http.HttpServletRequest;
   9 import javax.servlet.http.HttpServletResponse;
  10
  11 import org.cacert.gigi.User;
  12 import org.cacert.gigi.database.DatabaseConnection;
  13 import org.cacert.gigi.pages.LoginPage;
  14 import org.cacert.gigi.pages.Page;
  15
  16 public class MailOverview extends Page {
  17         public static final String DEFAULT_PATH = "/account/mails";
  18
  19         public MailOverview(String title) {
  20                 super(title);
  21         }
  22
  23         @Override
  24         public void doGet(HttpServletRequest req, HttpServletResponse resp)
  25                         throws IOException {
  26                 User us = LoginPage.getUser(req);
  27                 int id = us.getId();
  28                 try {
  29                         PreparedStatement ps = DatabaseConnection.getInstance().prepare(
  30                                         "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
  31                         ps.setInt(1, id);
  32                         ResultSet rs = ps.executeQuery();
  33                 } catch (SQLException e) {
  34                         e.printStackTrace();
  35                 }
  36         }
  37
  38 }