List of usage examples for org.hibernate.cfg Configuration buildSessionFactory
public SessionFactory buildSessionFactory() throws HibernateException
From source file:com.mycompany.controllers.PlayerStatisticsController.java
@GetMapping("/remove/{idSeason}") public ModelAndView removeStatitics(Model model, @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam, @PathVariable("idPlayer") String idPlayer, @PathVariable("idSeason") String idSeason) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); Query query = session.createQuery("from ZawodnikStatystyki where id_zawodnik=:id and id_sezon=:ids"); query.setParameter("id", idPlayer); query.setParameter("ids", idSeason); List<ZawodnikStatystyki> statistic = query.getResultList(); session.remove(statistic.get(0));/*ww w. ja v a2 s . c o m*/ t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/players/" + idPlayer + "/"); }
From source file:com.mycompany.controllers.PlayerStatisticsController.java
@GetMapping("/create/") public String createStatistics(PlayerStatisticsForm playerStatisticsForm, Model model, @PathVariable("idTeam") String idTeam, @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection, @PathVariable("idPlayer") String idPlayer) { model.addAttribute("Section", idSection); model.addAttribute("Club", idClub); model.addAttribute("Team", idTeam); model.addAttribute("Player", idPlayer); Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); List<Sezon> seasonList = session.createCriteria(Sezon.class).list(); System.out.println("" + seasonList.size()); model.addAttribute("seasonList", seasonList); t.commit();/*from w w w.ja va2 s . c om*/ session.close(); factory.close(); return "/player/create_playerstatistics_view"; }
From source file:com.mycompany.controllers.PlayerStatisticsController.java
@RequestMapping(value = "/create", method = RequestMethod.POST) public ModelAndView createstatistics(PlayerStatisticsForm playerStatisticsForm, Model model, @PathVariable("idTeam") String idTeam, @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection, @PathVariable("idPlayer") String idPlayer) { model.addAttribute("Section", idSection); model.addAttribute("Club", idClub); model.addAttribute("Team", idTeam); model.addAttribute("Player", idPlayer); Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); ZawodnikStatystyki playerStatistics = new ZawodnikStatystyki(); playerStatistics.setCzerwoneKartki(Integer.parseInt(playerStatisticsForm.getRedCards())); playerStatistics.setZolteKartki(Integer.parseInt(playerStatisticsForm.getYellowCards())); playerStatistics.setRozegraneMinuty(Integer.parseInt(playerStatisticsForm.getMinutesPlayed())); playerStatistics.setFaule(Integer.parseInt(playerStatisticsForm.getFaulsCommited())); playerStatistics.setStrzeloneBramki(Integer.parseInt(playerStatisticsForm.getScoredGoals())); playerStatistics.setStraconeBramki(Integer.parseInt(playerStatisticsForm.getLostGoals())); Query query = session.createQuery("from Sezon where rok=:rok"); query.setParameter("rok", Integer.parseInt(playerStatisticsForm.getSeason())); List<Sezon> seasonList = query.getResultList(); playerStatistics.setSezon(seasonList.get(0)); ZawodnikStatystykiPK zspk = new ZawodnikStatystykiPK(Integer.parseInt(idPlayer), seasonList.get(0).getIdSezon()); playerStatistics.setZawodnikStatystykiPK(zspk); session.persist(playerStatistics);//from ww w .jav a 2 s . c o m t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/players/" + idPlayer + "/"); }
From source file:com.mycompany.controllers.SectionController.java
@RequestMapping(value = "/", method = RequestMethod.GET) public String sectionPage(@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 Sekcja where Id_Klub=:id"); query.setParameter("id", idClub); List<Sekcja> sectionList = query.getResultList(); model.addAttribute("sectionList", sectionList); model.addAttribute("Club", idClub); session.close();/*from w ww .j a v a 2 s .c o m*/ return "/section/show_section_view"; }
From source file:com.mycompany.controllers.SectionController.java
@GetMapping("/remove/{idSection}") public ModelAndView removeSection(Model model, @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); Sekcja section = session.find(Sekcja.class, Integer.parseInt(idSection)); session.remove(section);/* ww w . jav a 2 s . c o m*/ t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/sections/"); }
From source file:com.mycompany.controllers.SectionController.java
@RequestMapping(value = "/create", method = RequestMethod.POST) public ModelAndView createsection(@Valid SectionForm sectionForm, @PathVariable("idClub") String idClub, Model model) {//from w w w . j av a 2s . c o m Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); Session session = factory.openSession(); Transaction t = session.beginTransaction(); Klub club = session.find(Klub.class, Integer.parseInt(idClub)); Sekcja section = new Sekcja(); section.setDyscyplina(sectionForm.getDiscipline()); section.setPlec(sectionForm.getSex()); section.setIdKlub(club); session.persist(section); t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + idClub + "/sections/"); }
From source file:com.mycompany.controllers.SectionController.java
@RequestMapping(value = "/edit/{idSection}", method = RequestMethod.GET) public String sectionEdit(SectionForm sectionForm, @PathVariable("idSection") String idSection, Model model) { Configuration cfg = new Configuration(); cfg.configure("hibernate.cfg.xml"); SessionFactory factory = cfg.buildSessionFactory(); //creating session object Session session = factory.openSession(); Sekcja section = session.find(Sekcja.class, Integer.parseInt(idSection)); model.addAttribute("section", section); session.close();//from ww w.ja v a 2 s . c om factory.close(); return "/section/edit_section_view"; }
From source file:com.mycompany.controllers.SectionController.java
@RequestMapping(value = "/edit/{idSection}", method = RequestMethod.POST) public ModelAndView sectionedit(@Valid SectionForm sectionForm, @PathVariable("idSection") String idSection, @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(); Sekcja section = session.find(Sekcja.class, Integer.parseInt(idSection)); section.setDyscyplina(sectionForm.getDiscipline()); section.setPlec(sectionForm.getSex()); session.update(section);// w ww . j a v a 2 s.c o m t.commit(); session.close(); factory.close(); return new ModelAndView("redirect:/club/" + section.getIdKlub() + "/sections/"); }
From source file:com.mycompany.controllers.StaffMemberController.java
@RequestMapping(value = "/", method = RequestMethod.GET) public String staffMemberPage(@PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam, 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 CzlonekSztabu where id_druzyna=:id"); query.setParameter("id", idTeam); List<CzlonekSztabu> membersList = query.getResultList(); session.close();/*from w w w . ja va 2 s. c o m*/ model.addAttribute("club", idClub); model.addAttribute("Section", idSection); model.addAttribute("Team", idTeam); model.addAttribute("memberList", membersList); return "/staffmember/show_staffmember_view"; }
From source file:com.mycompany.controllers.StaffMemberController.java
@RequestMapping(value = "/create", method = RequestMethod.POST) public ModelAndView createmember(@Valid StaffMemberForm staffMemberForm, @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam, 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(); Druzyna druzyna = session.find(Druzyna.class, Integer.parseInt(idTeam)); CzlonekSztabu member = new CzlonekSztabu(); member.setImie(staffMemberForm.getFirstName()); member.setNazwisko(staffMemberForm.getLastName()); member.setStanowisko(staffMemberForm.getPosition()); member.setPensja(staffMemberForm.getSalary()); member.setIdDruzyna(druzyna);/*from w w w . ja v a 2 s. c o m*/ session.persist(member); t.commit(); session.close(); factory.close(); model.addAttribute("club", idClub); model.addAttribute("Section", idSection); model.addAttribute("Team", idTeam); return new ModelAndView( "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/staffmembers/"); }