List of usage examples for org.hibernate.cfg Configuration buildSessionFactory
public SessionFactory buildSessionFactory() throws HibernateException
From source file:com.moss.telephone.hibernate.TestUserTypes.java
License:Open Source License
protected void setUp() throws Exception { catFactory = CatalogFactory.getFactory(DatabaseType.DB_TYPE_HSQLDB); handle = catFactory.createCatalog(); Configuration cfg = new Configuration() .setProperty("hibernate.connection.driver_class", "org.hsqldb.jdbcDriver") .setProperty("hibernate.dialect", "org.hibernate.dialect.HSQLDialect") .setProperty("hibernate.connection.url", "jdbc:hsqldb:mem:test") .setProperty("hibernate.connection.username", "sa").setProperty("hibernate.connection.password", "") .setProperty("hibernate.connection.pool_size", "1").setProperty("hibernate.show_sql", "true") .setProperty("hibernate.hbm2ddl.auto", "update").addClass(TestEntity.class); hFactory = cfg.buildSessionFactory(); }
From source file:com.mycompany.controllers.BoardMemberController.java
@RequestMapping(value = "/", method = RequestMethod.GET) public String boardMemberPage(@PathVariable("idClub") String idClub, Model model) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Query query = session.createQuery("from CzlonekZarzadu where Id_Klub=:id"); query.setParameter("id", idClub); List<CzlonekZarzadu> membersList = query.getResultList(); session.close();// w ww . j a v a 2s .c o m model.addAttribute("club", idClub); model.addAttribute("memberList", membersList); return "/boardmember/show_boardmember_view"; }
From source file:com.mycompany.controllers.BoardMemberController.java
@RequestMapping(value = "/create", method = RequestMethod.POST) public ModelAndView createmember(@Valid BoardMemberForm boardMember, @PathVariable("idClub") String idClub, Model model) {/*w w w .java 2s .c o m*/ Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Transaction t = session.beginTransaction(); Klub klub = session.find(Klub.class, Integer.parseInt(idClub)); CzlonekZarzadu member = new CzlonekZarzadu(); member.setImie(boardMember.getFirstName()); member.setNazwisko(boardMember.getLastName()); member.setStanowisko(boardMember.getPosition()); member.setPensja(boardMember.getSalary()); member.setProcentUdzialow(Float.parseFloat(String.valueOf(boardMember.getPercent()))); member.setIdKlub(klub); session.persist(member); t.commit(); session.close(); factory.close(); model.addAttribute("club", idClub); return new ModelAndView("redirect:/club/" + idClub + "/boardmembers/"); }
From source file:com.mycompany.controllers.BoardMemberController.java
@GetMapping("/edit/{idMember}") public String editBoardMember(BoardMemberForm boardMember, Model model, @PathVariable("idClub") String idClub, @PathVariable("idMember") String idMember) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); CzlonekZarzadu member = session.find(CzlonekZarzadu.class, Integer.parseInt(idMember)); model.addAttribute("club", idClub); model.addAttribute("member", member); session.close();// w w w. ja v a 2s . co m factory.close(); return "/boardmember/edit_boardmember_view"; }
From source file:com.mycompany.controllers.BoardMemberController.java
@PostMapping("/edit/{idMember}") @ResponseBody/*from w w w . j av a2 s .co m*/ public ModelAndView editBoardMember(@Valid BoardMemberForm boardMember, BindingResult result, Model model, @PathVariable("idClub") String idClub, @PathVariable("idMember") String idMember) throws IOException { if (result.hasErrors()) { return new ModelAndView("redirect:/club/" + idClub + "/boardmembers/edit/" + idMember); } Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); CzlonekZarzadu member = session.find(CzlonekZarzadu.class, Integer.parseInt(idMember)); member.setImie(boardMember.getFirstName()); member.setNazwisko(boardMember.getLastName()); member.setStanowisko(boardMember.getPosition()); member.setPensja(boardMember.getSalary()); member.setProcentUdzialow(Float.parseFloat(String.valueOf(boardMember.getPercent()))); session.update(member); t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/boardmembers/"); }
From source file:com.mycompany.controllers.BoardMemberController.java
@GetMapping("/remove/{idMember}") public ModelAndView removeBoardMember(Model model, @PathVariable("idClub") String idClub, @PathVariable("idMember") String idMember) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Transaction t = session.beginTransaction(); CzlonekZarzadu member = session.find(CzlonekZarzadu.class, Integer.parseInt(idMember)); session.remove(member);//from w w w. j av a2 s . co m t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/boardmembers/"); }
From source file:com.mycompany.controllers.BuildingController.java
@RequestMapping(value = "/", method = RequestMethod.GET) public String buildingPage(@PathVariable("idClub") String idClub, Model model) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Query query = session.createQuery("from Budynek where Id_Klub=:id"); query.setParameter("id", idClub); List<Budynek> buildingsList = query.getResultList(); List buildingAdminList = new ArrayList(); List arenaList = new ArrayList(); List trainingObjectList = new ArrayList(); for (Budynek b : buildingsList) { if (b.getBudynekAdministracyjny() != null) { buildingAdminList.add(b.getBudynekAdministracyjny()); }//from w w w . j ava 2 s . com if (b.getStadion() != null) { arenaList.add(b.getStadion()); } if (b.getObiektTreningowy() != null) { trainingObjectList.add(b.getObiektTreningowy()); } } session.close(); model.addAttribute("club", idClub); model.addAttribute("buildingAdminList", buildingAdminList); model.addAttribute("arenaList", arenaList); model.addAttribute("buildings", buildingsList); model.addAttribute("trainingObjectList", trainingObjectList); return "/building/show_building_view"; }
From source file:com.mycompany.controllers.BuildingController.java
@RequestMapping(value = "/edit/{idBuilding}", method = RequestMethod.GET) public String buildingEdit(BuildingForm buildingForm, @PathVariable("idBuilding") String idBuilding, Model model) {/* w w w . j ava 2s .com*/ Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Budynek building = session.find(Budynek.class, Integer.parseInt(idBuilding)); model.addAttribute("building", building); if (building.getBudynekAdministracyjny() != null) { model.addAttribute("bAdmin", building.getBudynekAdministracyjny()); } if (building.getStadion() != null) { model.addAttribute("bArena", building.getStadion()); } if (building.getObiektTreningowy() != null) { model.addAttribute("bTrainingObject", building.getObiektTreningowy()); } session.close(); factory.close(); return "/building/edit_building_view"; }
From source file:com.mycompany.controllers.BuildingController.java
@RequestMapping(value = "/edit/{idBuilding}", method = RequestMethod.POST) public ModelAndView buildingedit(@Valid BuildingForm buildingForm, @PathVariable("idBuilding") String idBuilding, @PathVariable("idClub") String idClub, Model model) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Transaction t = session.beginTransaction(); Budynek building = session.find(Budynek.class, Integer.parseInt(idBuilding)); if (building.getStadion() != null) { Stadion arena = session.find(Stadion.class, Integer.parseInt(idBuilding)); arena.setDyscyplina(buildingForm.getDiscipline()); arena.setIloscMiejsc(Integer.parseInt(buildingForm.getCapacity())); arena.setNazwa(buildingForm.getName()); session.update(arena);//from ww w. j av a 2 s .co m } if (building.getObiektTreningowy() != null) { model.addAttribute("bTrainingObject", building.getObiektTreningowy()); } building.setKodPocztowy(buildingForm.getPostcode()); building.setMiejscowosc(buildingForm.getCity()); building.setUlicanumer(buildingForm.getStreet()); session.update(building); t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/buildings/"); }
From source file:com.mycompany.controllers.BuildingController.java
@GetMapping("/remove/{idBuilding}") public ModelAndView removeClub(Model model, @PathVariable("idClub") String idClub, @PathVariable("idBuilding") String idBuilding) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Transaction t = session.beginTransaction(); Budynek building = session.find(Budynek.class, Integer.parseInt(idBuilding)); session.remove(building);//from www. j a v a2s .c om t.commit(); log.info("dziaa"); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/buildings/"); }