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