Java - Cargar varios registros en un Jtextarea (Jframe)

st = reg1.createStatement();

ResultSet result= st.executeQuery(sql);

if (result.next()){

    String descripcion = result.getString(1);

    descripcion2.setText(descripcion);

}

st = reg1.createStatement();

public void cargarTabla(JTable tabla, String sql) {

    Connection cn = null;

    PreparedStatement pst = null;

    ResultSet rs;

    List<String[]> rows = null;

    String[] columnas = null;

    try {

        cn = connect();

        pst = cn.prepareStatement(sql);

        rs = pst.executeQuery();

        int cols = rs.getMetaData().getColumnCount();

        columnas = new String[cols];

        for (int i = 0; i < columnas.length; i++) {

            columnas[i] = rs.getMetaData().getColumnName(i + 1);

        }

        String[] row;

        rows = new ArrayList();

        while (rs.next()) {

            row = new String[cols];

            for (int i = 0; i < row.length; i++) {

                row[i] = rs.getString(i + 1);

            }

            rows.add(row);

        }

    } catch (SQLException ex) {

        ex.printStackTrace(System.out);

    } finally {

        try {

            if (pst != null && !pst.isClosed()) {

                pst.close();

            }

            if (cn != null && !cn.isClosed()) {

                cn.close();

            }

        } catch (SQLException ex) {

            ex.printStackTrace(System.out);

        }

    }

    if (rows != null && !rows.isEmpty() && columnas != null) {

        String[][] data = new String[rows.size()][columnas.length];

        for (int i = 0; i < data.length; i++) {

            data[i] = rows.get(i);

        }

        tabla.setModel(new DefaultTableModel(data, columnas));

    }

}

con = new conecta();

Connection reg1 = con.getConnection();

DefaultTableModel model = new DefaultTableModel();

TableColumnModel columnModel = tabla.getColumnModel();

String busque = "";

tabla.setModel(model);

String sql = "select tickets from empresa";

//String[] dato= new String[4];

Statement st;

model.addColumn("Tickets ");

columnModel.getColumn(0).setPreferredWidth(50);

tabla.setRowHeight(700);

// tabla.setRowHeight(23);

try {

    st = reg1.createStatement();

    ResultSet result= st.executeQuery(sql);

    while (result.next()){

        Object[] fila = new Object[1];

        for (int i = 0; i < 1; i++) {

            fila[i]=result.getObject(i+1);

        }

        model.addRow(fila);

    }

} catch (SQLException ex) {

    Logger.getLogger(interfaz.class.getName()).log(Level.SEVERE, null, ex);

}

public void metodo() {

    con = new conecta();

    Connection reg1 = con.getConnection();

    DefaultTableModel model = new DefaultTableModel();

    TableColumnModel columnModel = tabla.getColumnModel();

    String busque = "";

    tabla.setModel(model);

    String sql = "select tickets from empresa";

    //String[] dato= new String[4];

    Statement st;

    model.addColumn("Tickets ");

    columnModel.getColumn(0).setPreferredWidth(50);

    tabla.setRowHeight(700);

    // tabla.setRowHeight(23);

    try {

        st = reg1.createStatement();

        ResultSet result = st.executeQuery(sql);

        while (result.next()) {

            Object[] fila = new Object[1];

            for (int index = 0; index < 1; index++) {

                fila[index] = result.getObject(index + 1);

            }

            model.addRow(fila);

        }

    } catch (SQLException ex) {

        Logger.getLogger(interfaz.class.getName()).log(Level.SEVERE, null, ex);

    }

}

public void metodo() {

    cargarTabla(tabla, "select tickets as Tickets from empresa");

    TableColumnModel columnModel = tabla.getColumnModel();

    columnModel.getColumn(0).setPreferredWidth(50);

    tabla.setRowHeight(700);

}

public void cargarTabla(JTable tabla, String sql) {

    conecta con = new conecta();

    Connection cn = null;

    PreparedStatement pst = null;

    ResultSet rs;

    List<String[]> rows = null;

    String[] columnas = null;

    try {

        cn = con.getConnection();

        pst = cn.prepareStatement(sql);

        rs = pst.executeQuery();

        int cols = rs.getMetaData().getColumnCount();

        columnas = new String[cols];

        for (int i = 0; i < columnas.length; i++) {

            columnas[i] = rs.getMetaData().getColumnName(i + 1);

        }

        String[] row;

        rows = new ArrayList();

        while (rs.next()) {

            row = new String[cols];

            for (int i = 0; i < row.length; i++) {

                row[i] = rs.getString(i + 1);

            }

            rows.add(row);

        }

    } catch (SQLException ex) {

        ex.printStackTrace(System.out);

    } finally {

        try {

            if (pst != null && !pst.isClosed()) {

                pst.close();

            }

            if (cn != null && !cn.isClosed()) {

                cn.close();

            }

        } catch (SQLException ex) {

            ex.printStackTrace(System.out);

        }

    }

    if (rows != null && !rows.isEmpty() && columnas != null) {

        String[][] data = new String[rows.size()][columnas.length];

        for (int i = 0; i < data.length; i++) {

            data[i] = rows.get(i);

        }

        tabla.setModel(new DefaultTableModel(data, columnas));

    }

}

package graficos;

import java.awt.BorderLayout;

import javax.swing.JFrame;

import javax.swing.*;

public class PruebaJTextArea {

	public static void main(String[] args) {

		MarcoPruebaJTextArea m = new MarcoPruebaJTextArea();

		m.setVisible(true);

	}

}

class MarcoPruebaJTextArea extends JFrame{

	public MarcoPruebaJTextArea() {

		setSize(600, 400);

		setLocationRelativeTo(null);

		setLayout(new BorderLayout());

		JTextArea jta = new JTextArea();

		jta.setLineWrap(true);

		String[] col = {"Enero", "Febrero", "Marzo", "Abril", "Mayo"};

		int[][] data = new int[5][5];

		for(int i=0; i<data.length; i++) {

			for(int j=0; j<data.length; j++) {

				data[i][j] = i*j;

			}

		}

		for(int i=0; i<data.length; i++) {

			jta.setText(jta.getText()+col[i] + ":");

			for(int j=0; j<data.length; j++) {

				jta.setText(jta.getText() + "  " + data[i][j]);

			}

			jta.setText(jta.getText()+"\n");

		}

		add(jta, BorderLayout.CENTER);

	}

}

//Prueba este codigo quizas te ayude y te de una idea