public ArrayList<LineaAerea> getLineasAereas() throws SQLException{
        Statement stm = getConnection().createStatement();
        String sql = "SELECT * FROM operad WHERE ciata IS NOT NULL ";
        ArrayList<LineaAerea> lineas = new ArrayList();
        ResultSet rs = stm.executeQuery(sql);
        while (rs.next()) {
            LineaAerea la = new LineaAerea();
            la.setCodigo(rs.getString("codigo").trim());
            la.setNombre(rs.getString("nombre").trim());
            la.setcIata(rs.getString("ciata").trim());
            System.out.println(la);
            lineas.add(la);
        }
        return lineas;
    }