Main - Lefteros/Tikape-smoothiearkisto GitHub Wiki

public static void main(String[] args) throws Exception {

    if (System.getenv("PORT") != null) {
        Spark.port(Integer.valueOf(System.getenv("PORT")));
    }

    Database db = new Database("jdbc:sqlite:smoothiet.db");
    Connection cnt = db.getConnection();
    RaakaAineDao raakaAineet = new RaakaAineDao(db);
    SmoothieDao smoothiet = new SmoothieDao(db);

    Spark.get("/", (req, res) -> {
        HashMap map = new HashMap<>();
        map.put("annos", smoothiet.findAll());

        return new ModelAndView(map, "html1");
    }, new ThymeleafTemplateEngine());

    Spark.get("/aine", (req, res) -> {
        HashMap map = new HashMap<>();

        map.put("aineet", raakaAineet.findLkm());
        return new ModelAndView(map, "html3");
    }, new ThymeleafTemplateEngine());

    Spark.get("/smoothie", (req, res) -> {
        HashMap map = new HashMap<>();
        map.put("annos", smoothiet.findAll());
        map.put("aineet", raakaAineet.findAll());

        return new ModelAndView(map, "html2");
    }, new ThymeleafTemplateEngine());

    Spark.post("/smoothie", (req, res) -> {
        Smoothie uusi = new Smoothie(-1, req.queryParams("nimi"));
        smoothiet.saveOrUpdate(uusi);
        res.redirect("/smoothie");
        return "";
    });

    Spark.post("/smoothie1", (req, res) -> {
        Integer jarjestys = 0;
        if (req.queryParams("jarjestys").length() != 0) {
            try {
                jarjestys = Integer.parseInt(req.queryParams("jarjestys"));
            } catch (Exception e) {

                res.redirect("/smoothie");
                return "";
            }
        }
        RaakaAine uusi = new RaakaAine(-1, req.queryParams("raakaAine"), req.queryParams("ohje"), req.queryParams("maara"), jarjestys, req.queryParams("smoothie"));
        raakaAineet.saveOrUpdate1(uusi);
        res.redirect("/smoothie");
        return "";
    });

    Spark.post("/aine", (req, res) -> {
        RaakaAine aine = new RaakaAine(-1, req.queryParams("nimi"));
        raakaAineet.saveOrUpdate(aine);
        res.redirect("/aine");
        return "";
    });

    Spark.get("/smoothie/:id", (req, res) -> {
        Integer moi = Integer.parseInt(req.params(":id"));
        HashMap map = new HashMap<>();
        List<RaakaAine> lista = raakaAineet.findRaakaAineet(moi);
        map.put("Smoothie", smoothiet.findOne(moi));
        map.put("RaakaAineet", lista);

        return new ModelAndView(map, "html4");
    }, new ThymeleafTemplateEngine());

}