Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class AlertsPageController {
- public static String serveAlertsPage(Request request, Response response) {
- // Make sure the user is logged in before showing any alerts
- if(request.session().attribute("user") == null) {
- request.session().attribute("loginUnauthorized", true);
- request.session().attribute("requestedPath", "/alerts");
- response.redirect("/login");
- return null;
- }
- Map<String, Object> attributes = new HashMap<>();
- // Placeholder below
- attributes.put("This is a placeholder.", "This is a placeholder.");
- try {
- Statement s = Database.getConnection().createStatement();
- ResultSet rs = s.executeQuery("SELECT * FROM Alerts WHERE user=" + request.session().attribute("user").toString());
- if(rs.next()) {
- /**
- * If the user has alerts, start loading them into the page
- */
- } else {
- /**
- * Display an empty inbox with some text like "You have no alerts"
- */
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return TemplateEngine.getInstance().render(attributes, "alerts.ftl");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement