Runner.java

package com.andyshon;

import org.apache.log4j.BasicConfigurator;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import java.sql.SQLException;
import java.util.Collection;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Set;

/**
 * Created by andys_000 on 02.10.2017.
 */
public class Runner {
    public static void main(String[] args) throws SQLException{

        //BasicConfigurator.configure();
        //Configuration cfg=new Configuration();
        //cfg.configure("hibernate.cfg.xml");//populates the data of the configuration file

        /*Route route_obj = new Route();
        route_obj.setName("Route 10");
        route_obj.setNumber(404);

        Bus bus_obj = new Bus();
        bus_obj.setNumber("numb_5");
        //bus_obj.setRoute_id(555);

        Driver driver_obj = new Driver();
        driver_obj.setAge(49);
        driver_obj.setName("Nikita");
        driver_obj.setSurname("Smirnov");*/



       /* Bus bus_obj = new Bus();
        //bus_obj.setId(2);
        bus_obj.setNumber("new_legacy");
        Driver driver_obj = new Driver();
        //driver_obj.setId(2);
        driver_obj.setName("andy");
        driver_obj.setSurname("shatula");
        driver_obj.setAge(19);
        Route route_obj = new Route();
        //route_obj.setId(2);
        route_obj.setName("Route 27");
        route_obj.setNumber(27);
        Factory.getInstance().getBusDAO().addBus(bus_obj);
        Factory.getInstance().getRouteDAO().addRoute(route_obj);
        Factory.getInstance().getDriverDAO().addDriver(driver_obj);*/


        /*// add drivers to bus
        Bus busD = Factory.getInstance().getBusDAO().getBusById(1);
        Set<Driver> driversSet = new HashSet<Driver>();
        Driver dr1 = new Driver();
        dr1.setName("driver1");
        dr1.setSurname("surname1");
        dr1.setAge(32);
        Driver dr2 = new Driver();
        dr2.setName("driver2");
        dr2.setSurname("surname2");
        dr2.setAge(33);
        driversSet.add(dr1);
        driversSet.add(dr2);
        busD.setDrivers(driversSet);*/


        // add all drivers to the second
        // all drivers can drive the second bus
        Driver dri1 = Factory.getInstance().getDriverDAO().getDriverById(1);
        Driver dri2 = Factory.getInstance().getDriverDAO().getDriverById(2);
        Driver dri3 = Factory.getInstance().getDriverDAO().getDriverById(3);
        Driver dri4 = Factory.getInstance().getDriverDAO().getDriverById(4);
        Driver dri5 = Factory.getInstance().getDriverDAO().getDriverById(5);
        Set<Driver> drSet = new HashSet<Driver>();
        drSet.add(dri1);
        drSet.add(dri2);
        drSet.add(dri3);
        drSet.add(dri4);
        drSet.add(dri5);
        Bus bus1 = Factory.getInstance().getBusDAO().getBusById(2);
        bus1.setDrivers(drSet);
        Factory.getInstance().getBusDAO().updateBus(bus1.getId(), bus1);


        // update bus number
        Bus bus2 = Factory.getInstance().getBusDAO().getBusById(2);
        bus2.setNumber("new-number2");
        Factory.getInstance().getBusDAO().updateBus(bus2.getId(), bus2);


        // get busses by drivers
        System.out.println("~~~~~Get busses by drivers~~~~~");
        Collection all_drivers = Factory.getInstance().getDriverDAO().getAllDrivers();
        Iterator iter = all_drivers.iterator();
        while (iter.hasNext()){
            Driver dr = (Driver) iter.next();
            System.out.println("driver id:"+dr.getId() + " \tdriver name:"+dr.getName() + " \tdriver surname:"+dr.getSurname()+
                    " \tdriver age:"+dr.getAge());
            Collection bussesByDriver = Factory.getInstance().getBusDAO().getBussesByDriver(dr);
            Iterator iter2 = bussesByDriver.iterator();
            while (iter2.hasNext()){
                Bus bus = (Bus) iter2.next();
                System.out.println("bus id:"+bus.getId() + " \t\tbus number:"+bus.getNumber());
            }
        }

        // show all busses
        // Get drivers by busses
        System.out.println("~~~~~Get drivers by busses~~~~~");
        Collection all_busses = Factory.getInstance().getBusDAO().getAllBusses();
        Iterator iteratorr = all_busses.iterator();
        System.out.println("~~~All BUSSES~~~");
        while (iteratorr.hasNext()){
            Bus bus = (Bus) iteratorr.next();
            System.out.println("Buss id: " + bus.getId() +  " bus number: " + bus.getNumber() + " route id: " + bus.getRoute_id());
            Collection driversByBusses = Factory.getInstance().getDriverDAO().getDriversByBus(bus);
            Iterator iter2 = driversByBusses.iterator();
            while (iter2.hasNext()){
                Driver driver = (Driver) iter2.next();
                System.out.println("driver id:"+driver.getId() + " \tdriver name:"+driver.getName() +
                        " \tdriver surname:"+driver.getSurname() + " \tdriver age:"+driver.getAge());
            }
        }

        // get driver by id
        Driver driver2 = Factory.getInstance().getDriverDAO().getDriverById(2);
        System.out.println("Водитель с id=2");
        System.out.println("id:" + driver2.getId());
        System.out.println("name:" + driver2.getName());
        System.out.println("surname:" + driver2.getSurname());
        System.out.println("age:" + driver2.getAge());

        // get busses by driver
        Collection busses2 = Factory.getInstance().getBusDAO().getBussesByDriver(driver2);
        Iterator iterator1 = busses2.iterator();
        System.out.println("Сколько автобусов водит этот водитель:"+busses2.size()+":");
        while (iterator1.hasNext()){
            Bus bus = (Bus) iterator1.next();
            System.out.println("bus id=" + bus.getId() + " number=" + bus.getNumber());
        }


        Collection busses = Factory.getInstance().getBusDAO().getAllBusses();
        Iterator iterator = busses.iterator();
        System.out.println("========Все автобусы=========");
        while (iterator.hasNext()) {
            Bus bus = (Bus) iterator.next();
            Collection drivers = Factory.getInstance().getDriverDAO().getDriversByBus(bus);
            Iterator iterator2 = drivers.iterator();
            System.out.println("Автобус № " + bus.getNumber());
            while (iterator2.hasNext()) {
                Driver driver = (Driver) iterator2.next();
                System.out.println("Водитель, имя: " + driver.getName() + "   Фамилия: " + driver.getSurname());
            }
        }

        /*Collection routes = Factory.getInstance().getRouteDAO().getAllRoutes();
        Iterator iterator = routes.iterator();
        System.out.println("========Все маршруты=========");
        while (iterator.hasNext()) {
            Route route = (Route) iterator.next();
            System.out.println("Маршрут: " + route.getName() + "  Номер маршрута: " + route.getNumber());
            Collection busses = Factory.getInstance().getBusDAO().getBussesByRoute(route);
            Iterator iterator2 = busses.iterator();
            while (iterator2.hasNext()) {
                Bus bus = (Bus) iterator2.next();
                System.out.println("Автобус № " + bus.getNumber() + "dd");
            }
        }*/

















        //Factory.getInstance().getBusDAO().addBus(bus_obj);
        //Factory.getInstance().getDriverDAO().addDriver(driver_obj);
        //Factory.getInstance().getRouteDAO().addRoute(route_obj);
        //System.out.println("3 objects successfully saved");


        /*//creating seession factory object
        SessionFactory factory=cfg.buildSessionFactory();
        //creating session object
        Session session=factory.openSession();
        //creating transaction object
        Transaction t=session.beginTransaction();

        session.saveOrUpdate(bus_obj);
        session.saveOrUpdate(route_obj);
        session.saveOrUpdate(driver_obj);
        session.getTransaction().commit();  // when commit is called it will save all 3 objects
        //t.commit();
        session.close();*/


        /*Collection busses = Factory.getInstance().getBusDAO().getAllBusses();
        Iterator iterator = busses.iterator();
        System.out.println("========Все автобусы=========");
        while (iterator.hasNext()) {
            Bus bus = (Bus) iterator.next();
            //Collection drivers = Factory.getInstance().getDriverDAO().getDriversByBus(bus);
            //Iterator iterator2 = drivers.iterator();
            System.out.println("id:" + bus.getId() + "\tАвтобус № " + bus.getNumber());
            *//*while (iterator2.hasNext()) {
                Driver driver = (Driver) iterator2.next();
                System.out.println("Имя : " + driver.getName() + "   Фамилия: " + driver.getSurname());
            }*//*
        }*/
    }
}