Advertisement
Guest User

Untitled

a guest
Apr 19th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.11 KB | None | 0 0
  1. public class AlertsPageController {
  2.     public static String serveAlertsPage(Request request, Response response) {
  3.        
  4.         // Make sure the user is logged in before showing any alerts
  5.         if(request.session().attribute("user") == null) {
  6.             request.session().attribute("loginUnauthorized", true);
  7.             request.session().attribute("requestedPath", "/alerts");
  8.             response.redirect("/login");
  9.             return null;
  10.         }
  11.        
  12.         Map<String, Object> attributes = new HashMap<>();
  13.        
  14.         // Placeholder below
  15.         attributes.put("This is a placeholder.", "This is a placeholder.");
  16.        
  17.         try {
  18.            
  19.             Statement s = Database.getConnection().createStatement();
  20.             ResultSet rs = s.executeQuery("SELECT * FROM Alerts WHERE user=" + request.session().attribute("user").toString());
  21.            
  22.             if(rs.next()) {
  23.                 /**
  24.                  * If the user has alerts, start loading them into the page
  25.                  */
  26.             } else {
  27.                 /**
  28.                  * Display an empty inbox with some text like "You have no alerts"
  29.                  */
  30.             }
  31.            
  32.         } catch (SQLException e) {
  33.             e.printStackTrace();
  34.         }
  35.         return TemplateEngine.getInstance().render(attributes, "alerts.ftl");
  36.     }
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement