public ArrayList<Politica> listAll(Connection c) throws SQLException {

        String sql = "SELECT * FROM M_POLIROLL ORDER BY VCCODRUTINA ASC ";
        ArrayList<Politica> results = new ArrayList();
        ResultSet result = null;
        PreparedStatement stm = null;
        try {
            stm = c.prepareStatement(sql);
            result = stm.executeQuery();

            while (result.next()) {
                Politica valueObject = new Politica();
                valueObject.setVccodrutina(result.getString("VCCODRUTINA"));
                valueObject.setLopcion(Boolean.parseBoolean(result.getString("LOPCION")) ? "Si" : "No");
                valueObject.setLgrabar(Boolean.parseBoolean(result.getString("LGRABAR")) ? "Si" : "No");
                valueObject.setLborrar(Boolean.parseBoolean(result.getString("LBORRAR")) ? "Si" : "No");
                valueObject.setLimprimir(Boolean.parseBoolean(result.getString("LIMPRIMIR")) ? "Si" : "No");
                valueObject.setLsimex(Boolean.parseBoolean(result.getString("LSIMEX")) ? "Si" : "No");

                results.add(valueObject);
            }
        } catch (SQLException ex) {
            Logger.getLogger(PoliticaDao.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            c.close();
            if (result != null) {
                result.close();
            }
            if (stm != null) {
                stm.close();
            }
        }
        return results;
    }