Example of RevisionDAO

/**
 * @author Sajmon
 */

package DTOs;

import OraclDAOFactory.OracleDAOFactory;
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 RevisionDAO {

    private final String SELECT_ALL = "SELECT * FROM Revision";


    public RevisionDAO() {

    }


    public List<RevisionDTO> getAll() {

        List<RevisionDTO> data = new ArrayList<RevisionDTO>();
        RevisionDTO member;

        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            con = getOracleDatabaseConnection();
            ps = con.prepareStatement(SELECT_ALL);
            rs = ps.executeQuery();
            while (rs.next()) {
                member = new RevisionDTO();
                member.setISBN(rs.getString(1));
                member.setYear(rs.getInt(2));
                member.setCover(rs.getInt(3));
                member.setPages(rs.getInt(4));
                member.setLanguage(rs.getString(5));
                member.setTranslator(rs.getString(6));
                member.setBook(new BookDTO());
                member.getBook().setId(rs.getInt(7));
                data.add(member);
            }
            System.out.println("Revision imported successfully.");
            return data;
        }
        catch (SQLException ex) {
            Logger.getLogger(RevisionDAO.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
}