lololol

/**
 * @author Sajmon
 */

package OraclDAO;

import DTOs.PobockaDTO;
import OraclDAOFactory.OracleDAOFactory;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;


public class OraclePobockaDAO implements Serializable {

    /** Database statements **/
    private final String INSERT_POBOCKA = "INSERT INTO Pobocka VALUES(?,?,?,?,?,?,?)";
    private final String SELECT_ALL = "SELECT * from Pobocka";
    /** Class attributes **/
    private String resultMsg;
    private List<PobockaDTO> listOfPobocky = null;


    public OraclePobockaDAO() {

    }


    public boolean vlozeniePobocky(PobockaDTO p) {

        return false;
    }

    public List<PobockaDTO> vratVsetkyPobocky() {

        listOfPobocky = new ArrayList<PobockaDTO>();
        PobockaDTO pobObj = null;

        PreparedStatement ps = null;
        ResultSet rs = null;
        Connection con = null;
        con = OracleDAOFactory.getOracleDatabaseConnection();
        try {
            ps = con.prepareStatement(this.SELECT_ALL);
            ps.clearParameters();
            rs = ps.executeQuery();
            while (rs.next()) {
                String name = rs.getString(2);
                System.out.println("Nazov: " + name);
                pobObj = new PobockaDTO();
                pobObj.setId(rs.getInt(1));
                pobObj.setNazov(rs.getString(2));
                pobObj.setAdresa(rs.getString(3));
                pobObj.setKraj(rs.getString(4));
                pobObj.setStat(rs.getString(5));
                pobObj.setRokZalozenia(rs.getInt(6));
                listOfPobocky.add(pobObj);
            }
            rs.close();
            ps.close();
            System.out.println("Pobocky nacitane do listu.\n\n");
            for (PobockaDTO item: listOfPobocky) {
                System.out.println(item.getId() + " " + item.getNazov() + " " + item.getAdresa() + " " + item.getKraj()
                        + " " + item.getStat() + " " + item.getRokZalozenia() + "\n");
            }
        }
        catch (SQLException ex) {
            Logger.getLogger(OraclePobockaDAO.class.getName()).log(Level.SEVERE, null, ex);
        }
        finally {
            if (con != null) {
                try {
                    con.close();
                }
                catch (SQLException ex) {
                    Logger.getLogger(OraclePobockaDAO.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
        return this.listOfPobocky;
    }



    public String getResultMsg() {
        return resultMsg;
    }

    public void setResultMsg(String resultMsg) {
        this.resultMsg = resultMsg;
    }
}



*****************************************************************************************************

/**
 * @author Sajmon
 */

package EJBs;

import DTOs.PobockaDTO;
import OraclDAO.OraclePobockaDAO;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import javax.annotation.PostConstruct;
import javax.ejb.Stateless;

@Stateless
public class PobockaEJB implements Serializable {

    private OraclePobockaDAO pobockaDAO = new OraclePobockaDAO();
    private List<PobockaDTO> pobocky = null;

    @PostConstruct
    private void init(){
        initializePobocky();
    }

    private void initializePobocky() {
        pobocky = pobockaDAO.vratVsetkyPobocky();
    }

    public List<PobockaDTO> getPobocky() {
        return this.pobocky;
    }
}

********************************************************************************************************


/**
 * @author Sajmon
 */

package OraclBeans;

import DTOs.PobockaDTO;
import EJBs.PobockaEJB;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;
import javax.ejb.EJB;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;


@ManagedBean(name="pobockaBean")
@ViewScoped
public class PobockaBean implements Serializable {

    @EJB
    PobockaEJB pobEJB; // injektovanie
    private List<PobockaDTO> pobocky = new ArrayList<PobockaDTO>();

    public PobockaBean() {

    }

    public List<PobockaDTO> getPobocky() {

        pobocky = pobEJB.getPobocky();
        return pobocky;
    }


    public void setPobocky(List<PobockaDTO> pobocky) {
        this.pobocky = pobocky;
    }
}