Imprimir consulta na tela

public void consultar() throws FileNotFoundException {
     ArrayList resultado = new ArrayList();
     
     try {
     	    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cn = DriverManager.getConnection(Conexao.CONEXAO);
            st = cn.createStatement();

            String query = "SELECT * FROM ALUNO;";
            rs = st.executeQuery(query);

            while(rs.next()) {
			        resultado.add( //colocando tudo que encontrar na arraylist
			        rs.getString(1) + " | " +
				rs.getString(6) + " | " +
				rs.getString(8)
                                );								
			}

             for(int i; i<resultado.size(); i++) { //esse for pode ser aonde voce quiser, dependendo da onde for instanciada a arraylist voce pode usar ela onde achar melhor
             
             //aki vc vai colokando na jtextfield ou jtextarea com o metodo suaarraylist.get(i);
             //mais nao esqueca de converter para string com o metodo .toString();, pois os elementos da arraylist sao objetos

             }

           cn.close();           

        } catch (Exception e) {
        }
	}	
}

import java.awt.BorderLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;

public class FrameHistorico extends JFrame{

	PanelHistorico ph;
	
	public FrameHistorico(Object cf){
		setTitle("Histórico");
		this.add(ph = new PanelHistorico(this, cf));
		this.setLocationRelativeTo(null);
		this.add(ph);
		this.setLayout(null);
		this.setContentPane(ph);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		this.setVisible(true);
		this.setResizable(false);
		this.pack();
	}
	
	public void fechaJanela(){
		this.setVisible(false);
		this.dispose();
	}
	
	public class PanelHistorico extends JPanel implements ActionListener{
		
		JFrame frame;
		Object c;
		JTextArea ta;
		JButton voltar;
		JScrollPane scrollPane;
		Vector <String> historico = new Vector <String> (1,1);
		
		public PanelHistorico(JFrame f, Object cof){
			c = cof;
			frame = f;
			
			 ta = new JTextArea(7,30);
			 ta.setEditable(false);
			 
			 this.preencheArea();
			 
			 voltar = new JButton("Voltar");
			 voltar.addActionListener(this);
			 
			 scrollPane = new JScrollPane(ta);
			 

	        JPanel buttonPanel = new JPanel();
	        JPanel buttonPanel2 = new JPanel();
	        
	        buttonPanel.setLayout(new GridLayout());
	        buttonPanel2.setLayout(new GridLayout(5,5));
	        
	        
	        buttonPanel.add(scrollPane);
	        buttonPanel2.add(voltar);

	        
	        add(buttonPanel, BorderLayout.PAGE_START);
	        
	        add(buttonPanel2, BorderLayout.CENTER);
		}

		public void preencheArea(){
			historico = c.getHistorico();
			for(int i = 0; i < historico.size(); i++){
				ta.append(historico.get(i)+"\n");
			}
		}
		
		public void actionPerformed(ActionEvent e) {
			
			if(e.getSource() == voltar){
				FramePrincipal fp = new FramePrincipal(c);
				this.setVisible(false);
				this.fecha();
			}
			
		}
		
		public void fecha(){
			frame.dispose();
		}
			
		}

	}