- @Override
- public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException {
- final User us = LoginPage.getUser(req);
- Language lang = Page.getLanguage(req);
- int id = us.getId();
- try {
- PreparedStatement ps = DatabaseConnection.getInstance().prepare(
- "SELECT * from `email` WHERE `memid`=? AND `deleted`=0");
- ps.setInt(1, id);
- ResultSet rs = ps.executeQuery();
- HashMap<String, Object> vars = new HashMap<>();
- vars.put("mailData", t);
- vars.put("res", rs);
- vars.put("us", us.getEmail());
- getDefaultTemplate().output(resp.getWriter(), lang, vars);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
-
- private class MailTable implements Outputable {
- private String mails, userMail;
-
- public MailTable(String mails, String userMail) {
- this.mails = mails;
- this.userMail = userMail;
- }
-
- @Override
- public void output(PrintWriter out, Language l, Map<String, Object> vars) {
- try {
- ResultSet rs = (ResultSet) vars.get(mails);
- String usM = (String) vars.get(userMail);
- while (rs.next()) {
- out.println("<tr>");
- out.println("<td><input type=\"radio\" name=\"emailid\" value=\"");
- int mailID = rs.getInt(1);
- out.print(mailID);
- out.print("\"/></td>");
- out.println("<td>");
- if (rs.getString(7).isEmpty()) {
- out.print(l.getTranslation("Verified"));
- } else {
- out.print(l.getTranslation("Unverified"));
- }
- out.print("</td>");
- out.println("<td>");
- String address = rs.getString(3);
- if (usM.equals(address)) {
- out.print(l.getTranslation("N/A"));
- } else {
- out.print("<input type=\"checkbox\" name=\"delid[]\" value=\"");
- out.print(mailID);
- out.print("\"/>");
- }
- out.print("</td>");
- out.println("<td>");
- out.print(address);
- out.print("</td>");
- out.println("</tr>");
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
-
- }