private void cargarModelo() {
Conexion cn = new Conexion();
PreparedStatement pst;
ResultSet rs = null;
//DefaultTableModel modelo = new DefaultTableModel();
DefaultTableModel modelo = null;
//modelo.addColumn("Id ");
//modelo.addColumn("Nombre ");
//modelo.addColumn("id Productos ");
//tabla.setModel(modelo);
try {
pst = cn.con.prepareStatement(txtentrada.getText());
rs = pst.executeQuery();
String com = "SERVICIOS";
String com1 = "EMPRESA";
String com2 = "ALIMENTOS";
String com3 = "ANIMALES";
String com4 = "CLIENTES";
String guar;
guar = txtentrada.getText();
boolean resul = guar.contains(com);
boolean resul1 = guar.contains(com1);
boolean resul2, resul3, resul4, resul5, resul6, resul7, resul8, resul9, resul10, resul11, resul12, resul13, resul14, resul15, resul16, resul17, resul18, resul19;
resul2 = guar.contains(com2);
resul3 = guar.contains(com3);
/**
*
* ******************************* TABLA ***************************
*
*/
//String[] datos = new String[150];
//while (rs.next()) {
// if (resul) {
// datos[0] = rs.getString(1);
// datos[1] = rs.getString(2);
// }
// if (resul1) {
// datos[0] = rs.getString(1);
// datos[1] = rs.getString(2);
// datos[2] = rs.getString(3);
// }
// if (resul3) {
// datos[0] = rs.getString(1);
// datos[1] = rs.getString(2);
// datos[2] = rs.getString(3);
// datos[3] = rs.getString(4);
// datos[4] = rs.getString(5);
// datos[5] = rs.getString(6);
// }
// if (resul3) {
// datos[0] = rs.getString(1);
// datos[1] = rs.getString(2);
// datos[2] = rs.getString(3);
// datos[3] = rs.getString(4);
// datos[4] = rs.getString(5);
// datos[5] = rs.getString(6);
// }
// /* datos[0] = rs.getString(1);
// datos[1] = rs.getString(2);
// /datos[2] = res.getString(3);
// */
// modelo.addRow(datos);
// tabla.setModel(modelo);
// String[] vacio = datos;
//}
int columnas = rs.getMetaData().getColumnCount();
List<String[]> results = new ArrayList();
while(rs.next()){
String [] row = new String[columnas];
for (int i = 0; i < row.length; i++) {
row[i] = rs.getString(i+1);
}
results.add(row);
}
String [] columnNames = new String[columnas];
for (int i = 0; i < columnNames.length; i++) {
columnNames[i] = rs.getMetaData().getColumnName(i+1);
}
String [][] data = new String[results.size()][columnas];
for (int i = 0; i < data.length; i++) {
data[i] = results.get(i);
}
tabla.setModel(new DefaultTableModel(data, columnNames));
} catch (SQLException ex) {
Logger.getLogger(Conex.class.getName()).log(Level.SEVERE, null, ex);
}
}