Example usage for org.hibernate.cfg Configuration configure

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

Introduction

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

Prototype

@Deprecated
public Configuration configure(org.w3c.dom.Document document) throws HibernateException 

Source Link

Usage

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

@RequestMapping(value = "/", method = RequestMethod.GET)
public String showPlayers(@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();
    Query query = session.createQuery("from Zawodnik where id_druzyna=:id");
    query.setParameter("id", idTeam);
    List<Zawodnik> playerList = query.getResultList();
    model.addAttribute("playersList", playerList);
    model.addAttribute("Club", idClub);
    model.addAttribute("Team", idTeam);
    model.addAttribute("Section", idSection);
    session.close();// www  .  j  a  va 2 s  .c o  m
    return "player/show_player_view";
}

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

@GetMapping("/remove/{idPlayer}")
public ModelAndView removePlayer(Model model, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam,
        @PathVariable("idPlayer") String idPlayer) {
    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.openSession();
    Transaction t = session.beginTransaction();
    Zawodnik player = session.find(Zawodnik.class, Integer.parseInt(idPlayer));
    session.remove(player);/*w  ww  .  j a va  2  s.c  o  m*/
    t.commit();
    session.close();
    factory.close();
    return new ModelAndView(
            "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/players/");
}

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

@RequestMapping(value = "/create", method = RequestMethod.POST)
public ModelAndView createplayer(@Valid PlayerForm playerForm, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam, Model model)
        throws ParseException {
    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));

    Zawodnik player = new Zawodnik();
    player.setImie(playerForm.getName());

    String year = playerForm.getYear();
    String day = playerForm.getDay();
    String month = playerForm.getMonth();

    DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
    StringBuilder s = new StringBuilder(year);
    s.append("-");
    s.append(month);//w  w w.  j ava  2  s  .  com
    s.append("-");
    s.append(day);
    Date myDate = formatter.parse(s.toString());
    java.sql.Date sqlDate = new java.sql.Date(myDate.getTime());
    player.setDataUrodzenia(sqlDate);
    player.setNazwisko(playerForm.getLastname());
    player.setWaga(Integer.parseInt(playerForm.getWeight()));
    player.setWzrost(Integer.parseInt(playerForm.getHeight()));
    player.setIdDruzyna(team);
    session.persist(player);
    t.commit();
    session.close();
    factory.close();
    return new ModelAndView(
            "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/players/");
}

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

@RequestMapping(value = "/edit/{idPlayer}", method = RequestMethod.POST)
public ModelAndView editteam(@Valid PlayerForm playerForm, @PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam, Model model,
        @PathVariable("idPlayer") String idPlayer) throws ParseException {
    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.openSession();
    Transaction t = session.beginTransaction();

    Zawodnik player = session.find(Zawodnik.class, Integer.parseInt(idPlayer));
    player.setImie(playerForm.getName());
    player.setNazwisko(playerForm.getLastname());
    String year = playerForm.getYear();
    String day = playerForm.getDay();
    String month = playerForm.getMonth();
    player.setWaga(Integer.parseInt(playerForm.getWeight()));
    player.setWzrost(Integer.parseInt(playerForm.getHeight()));
    DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
    StringBuilder s = new StringBuilder(year);
    s.append("-");
    s.append(month);//from w ww .j a v  a 2  s.c o m
    s.append("-");
    s.append(day);
    Date myDate = formatter.parse(s.toString());
    java.sql.Date sqlDate = new java.sql.Date(myDate.getTime());
    player.setDataUrodzenia(sqlDate);
    t.commit();
    session.close();
    return new ModelAndView(
            "redirect:/club/" + idClub + "/sections/" + idSection + "/teams/" + idTeam + "/players/");

}

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

@RequestMapping(value = "/", method = RequestMethod.GET)
public String showPlayerStatistics(@PathVariable("idClub") String idClub,
        @PathVariable("idSection") String idSection, @PathVariable("idTeam") String idTeam,
        @PathVariable("idPlayer") String idPlayer, Model model) {

    Configuration cfg = new Configuration();
    cfg.configure("hibernate.cfg.xml");
    SessionFactory factory = cfg.buildSessionFactory();
    Session session = factory.openSession();
    Query query = session.createQuery("from ZawodnikStatystyki where id_zawodnik=:id");
    query.setParameter("id", idPlayer);
    List<ZawodnikStatystyki> statisticsList = query.getResultList();
    Zawodnik player = session.find(Zawodnik.class, Integer.parseInt(idPlayer));
    model.addAttribute("statisticsList", statisticsList);
    model.addAttribute("Club", idClub);
    model.addAttribute("Team", idTeam);
    model.addAttribute("Section", idSection);
    model.addAttribute("Player", player);
    session.close();/*  w ww  .  ja  va2  s  .  c  om*/
    factory.close();
    return "player/show_concreteplayer_view";
}

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

@RequestMapping(value = "/edit/{idSeason}", method = RequestMethod.POST)
public ModelAndView editPlayerStatistics(@Valid PlayerStatisticsForm playerStatisticsForm,
        @PathVariable("idClub") String idClub, @PathVariable("idSection") String idSection,
        @PathVariable("idTeam") String idTeam, Model model, @PathVariable("idPlayer") String idPlayer,
        @PathVariable("idSeason") String idSeason) throws ParseException {
    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();
    statistic.get(0).setCzerwoneKartki(Integer.parseInt(playerStatisticsForm.getRedCards()));
    statistic.get(0).setZolteKartki(Integer.parseInt(playerStatisticsForm.getYellowCards()));
    statistic.get(0).setRozegraneMinuty(Integer.parseInt(playerStatisticsForm.getMinutesPlayed()));
    statistic.get(0).setFaule(Integer.parseInt(playerStatisticsForm.getFaulsCommited()));
    statistic.get(0).setStrzeloneBramki(Integer.parseInt(playerStatisticsForm.getScoredGoals()));
    statistic.get(0).setStraconeBramki(Integer.parseInt(playerStatisticsForm.getLostGoals()));

    session.persist(statistic.get(0));//from ww w .  j a va  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.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));/*from   w w  w .java  2s  .c om*/

    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 ww  .  ja va 2 s.  c  o m*/
    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  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/" + 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();//  www.  j a v a 2s .  c om
    return "/section/show_section_view";

}