Example usage for org.hibernate.cfg Configuration buildSessionFactory

List of usage examples for org.hibernate.cfg Configuration buildSessionFactory

Introduction

In this page you can find the example usage for org.hibernate.cfg Configuration buildSessionFactory.

Prototype

public SessionFactory buildSessionFactory() throws HibernateException 

Source Link

Document

Create a SessionFactory using the properties and mappings in this configuration.

Usage

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/");

}