package zesp03.webapp.page;

import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import zesp03.common.core.Database;
import zesp03.common.exception.NotFoundException;
import zesp03.webapp.dto.BuildingDto;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;

@Controller
public class BuildingPage {
    @GetMapping("/building")
    public String get(
            @RequestParam("id") long id,
            ModelMap model) {
        EntityManager em = null;
        EntityTransaction tran = null;
        try {
            em = Database.createEntityManager();
            tran = em.getTransaction();
            tran.begin();

            zesp03.common.entity.Building b = em.find(zesp03.common.entity.Building.class, id);
            if(b == null)
                throw new NotFoundException("building");
            BuildingDto dto = BuildingDto.make(b);
            model.put("building", dto);
            tran.commit();
            return "building";
        } catch (RuntimeException exc) {
            if (tran != null && tran.isActive()) tran.rollback();
            throw exc;
        } finally {
            if (em != null) em.close();
        }
    }
}

--------------------------------------------
package zesp03.webapp.page;

import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.GetMapping;
import zesp03.common.core.Database;
import zesp03.common.entity.Building;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;
import java.util.List;

@Controller
public class AllBuildingsPage {
    @GetMapping("/all-buildings")
    public String get(ModelMap model) {
        EntityManager em = null;
        EntityTransaction tran = null;


        List<Building> BuildingList;

        try {

            em = Database.createEntityManager();
            tran = em.getTransaction();

            tran.begin();

            BuildingList = em.createQuery("SELECT b FROM Building b", Building.class).getResultList();
            tran.commit();

        } catch (RuntimeException exc) {
            if( tran != null && tran.isActive() )
                tran.rollback();
            throw exc;
        } finally {
            if (em != null)
                em.close();
        }

        model.put("list", BuildingList);
        return "all-buildings";
    }
}