- c.waitFor(60000);
- out.println(c.getStatus());
- out.println(c.cert());
- } catch (SQLException e1) {
- e1.printStackTrace();
- } catch (GeneralSecurityException e) {
- e.printStackTrace();
- } catch (InterruptedException e) {
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare(
+ "SELECT `id`,`email` from `email` WHERE `memid`=? AND `deleted`=0");
+ ps.setInt(1, u.getId());
+ final ResultSet rs = ps.executeQuery();
+ vars.put("emails", new IterableDataset() {
+
+ @Override
+ public boolean next(Language l, Map<String, Object> vars) {
+ try {
+ if (!rs.next()) {
+ return false;
+ }
+ vars.put("id", rs.getString(1));
+ vars.put("value", rs.getString(2));
+ return true;
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return false;
+ }
+ });
+ getDefaultTemplate().output(resp.getWriter(), getLanguage(req), vars);
+ rs.close();
+ } catch (SQLException e) {