Example usage for org.hibernate.cfg Configuration Configuration

Introduction

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

Prototype

public Configuration()

Source Link

Usage

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.  j a  v  a 2  s .co  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);/*  ww  w  .  j a  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/");

}

From source file:com.mycompany.controllers.StaffMemberController.java

@GetMapping("/edit/{idMember}")
public String editStaffMember(StaffMemberForm staffMemberForm, Model model,
        @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection,
        @PathVariable("idTeam") String idTeam, @PathVariable("idMember") String idMember) {
    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();

    //creating session object  
    Session session = factory.openSession();

    CzlonekSztabu member = session.find(CzlonekSztabu.class, Integer.parseInt(idMember));

    model.addAttribute("club", idClub);
    model.addAttribute("Section", idSection);
    model.addAttribute("Team", idTeam);
    model.addAttribute("member", member);

    session.close();/*from  ww w.  j  a va2 s  .c  o m*/
    factory.close();
    return "/staffmember/edit_staffmember_view";
}

From source file:com.mycompany.controllers.StaffMemberController.java

@PostMapping("/edit/{idMember}")
@ResponseBody/* w ww.j av  a 2 s .co m*/
public ModelAndView editStaffMember(@Valid StaffMemberForm staffMemberForm, BindingResult result, Model model,
        @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection,
        @PathVariable("idTeam") String idTeam, @PathVariable("idMember") String idMember) throws IOException {
    if (result.hasErrors()) {
        return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam
                + "/staffmembers/edit/" + idMember);
    }

    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.openSession();
    Transaction t = session.beginTransaction();

    CzlonekSztabu member = session.find(CzlonekSztabu.class, Integer.parseInt(idMember));
    member.setImie(staffMemberForm.getFirstName());
    member.setNazwisko(staffMemberForm.getLastName());
    member.setStanowisko(staffMemberForm.getPosition());
    member.setPensja(staffMemberForm.getSalary());

    session.update(member);
    t.commit();
    session.close();
    factory.close();

    return new ModelAndView(
            "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/staffmembers/");

}

From source file:com.mycompany.controllers.StaffMemberController.java

@GetMapping("/remove/{idMember}")
public ModelAndView removeStaffMember(Model model, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam,
        @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();

    CzlonekSztabu member = session.find(CzlonekSztabu.class, Integer.parseInt(idMember));
    session.remove(member);//from w w  w  .j a  v  a  2  s .co  m
    t.commit();

    session.close();
    factory.close();

    return new ModelAndView(
            "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/staffmembers/");
}

From source file:com.mycompany.controllers.TeamController.java

@RequestMapping(value = "/", method = RequestMethod.GET)
public String showTeams(@PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection,
        Model model) {//from   w  w w.j  a va  2 s  .  c om

    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.openSession();
    Query query = session.createQuery("from Druzyna where id_sekcja=:id");
    query.setParameter("id", idSection);
    List<Druzyna> teamList = query.getResultList();
    model.addAttribute("Section", idSection);
    model.addAttribute("teamList", teamList);
    model.addAttribute("Club", idClub);
    session.close();
    return "/team/show_team_view";

}

From source file:com.mycompany.controllers.TeamController.java

@GetMapping("/remove/{idTeam}")
public ModelAndView removeTeam(Model model, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam) {
    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();

    Session session = factory.openSession();
    Transaction t = session.beginTransaction();

    Druzyna team = session.find(Druzyna.class, Integer.parseInt(idTeam));
    session.remove(team);//from   w  w w  .j a  v  a 2  s .  c om
    t.commit();
    session.close();
    factory.close();
    return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/");
}

From source file:com.mycompany.controllers.TeamController.java

@GetMapping("/create")
public String createTeam(TeamForm teamForm, Model model, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection) {
    model.addAttribute("Section", idSection);
    model.addAttribute("Club", idClub);

    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    //creating session object  
    Session session = factory.openSession();
    List<Liga> leagueList = session.createCriteria(Liga.class).list();

    model.addAttribute("leagueList", leagueList);

    session.close();//  ww w .  jav  a  2s  . c  o m
    return "/team/create_team_view";
}

From source file:com.mycompany.controllers.TeamController.java

@RequestMapping(value = "/create", method = RequestMethod.POST)
public ModelAndView createteam(@Valid TeamForm teamForm, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, Model model) {
    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));

    Druzyna team = new Druzyna();
    team.setNazwa(teamForm.getName());/*  w ww  .j  av a  2s.  c o  m*/
    team.setIdSekcja(section);

    Query query = session.createQuery("from Liga where nazwa=:name");
    query.setParameter("name", teamForm.getLeague());
    List<Liga> leagueList = query.getResultList();
    if (!leagueList.isEmpty())
        team.setIdLiga(leagueList.get(0));

    session.persist(team);
    t.commit();
    session.close();
    factory.close();
    return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/");
}

From source file:com.mycompany.controllers.TeamController.java

@RequestMapping(value = "/edit/{idTeam}", method = RequestMethod.POST)
public ModelAndView editteam(@Valid TeamForm teamForm, @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();
    Session session = factory.openSession();
    Transaction t = session.beginTransaction();

    Druzyna team = session.find(Druzyna.class, Integer.parseInt(idTeam));
    team.setNazwa(teamForm.getName());//from   ww w. j ava  2 s . c  o m
    session.update(team);

    t.commit();
    session.close();
    return new ModelAndView("redirect:/club/" + idClub + "/sections/" + idSection + "/teams/");
}