Ver Mensaje Individual
  #7 (permalink)  
Antiguo 17/02/2010, 20:45
zetaaster
 
Fecha de Ingreso: febrero-2010
Mensajes: 6
Antigüedad: 14 años, 2 meses
Puntos: 0
Respuesta: Como Refrescar jTable1 netbeans 6.8

Una disculpa por tantas molestias pablo pero me fato codigo, pense que cabria en dos mensajes pero bueno ahora si pongo el final del codigo.

jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.Grou pLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, jPanel1Layout.createSequentialGroup()
.addGap(42, 42, 42)
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 257, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.Component Placement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(txtidalumno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.Component Placement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2)
.addComponent(txtnombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(12, 12, 12)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(txtlicenciatura, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.Component Placement.UNRELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(txtcuatrimestre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(26, 26, 26)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(btneliminar)
.addComponent(btnmodificar)
.addComponent(btnnuevo))
.addGap(37, 37, 37)
.addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
.addComponent(btnaceptar)
.addComponent(btncancelar))
.addGap(46, 46, 46))
);

javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout .Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_S IZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout .Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);

bindingGroup.bind();

pack();
}// </editor-fold>

private void txtidalumnoActionPerformed(java.awt.event.ActionEv ent evt) {
// TODO add your handling code here:
}

private void btnmodificarActionPerformed(java.awt.event.ActionE vent evt) {

habilitar ();
estado='M';
desBotones();



// TODO add your handling code here:
}

private void btnaceptarActionPerformed(java.awt.event.ActionEve nt evt) {




String id=txtidalumno.getText();
String nom=txtnombre.getText();
String cua=txtcuatrimestre.getText();
String lic=txtlicenciatura.getText();









switch(estado){



case 'N':
try {
cn=new Conexion();


Statement stmt=cn.getConnection().createStatement();
stmt.executeUpdate( "insert into alumno values('"+id +"','"+nom +"','"+cua+"','"+lic+"')");


ResultSet rs = stmt.executeQuery("SELECT * FROM ALUMNO;");
tabla.setModel(new DefaultTableModel());
DefaultTableModel modelo = new DefaultTableModel();
JTable tabla = new JTable(modelo );



modelo.addColumn("IdAlumno");
modelo.addColumn("Nombre");
modelo.addColumn("Licenciatura");
modelo.addColumn("Cuatrimestre");

while (rs.next())
{

Object [] fila = new Object[4];

for (int i=0;i<4;i++)
fila[i] = rs.getObject(i+1);

modelo.addRow(fila);
tabla.setModel(modelo);
}

ResultSetMetaData metaDatos = rs.getMetaData();


int numeroColumnas = metaDatos.getColumnCount();


Object[] etiquetas = new Object[numeroColumnas];

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

etiquetas[i] = metaDatos.getColumnLabel(i + 1);
}

stmt.close();
cn.Desconectar();
}


catch(Exception e2){
System.out.println(e2);

}
break;

case 'M':
try {
cn=new Conexion();


Statement stmt=cn.getConnection().createStatement();
stmt.executeUpdate( "update alumno set idalumno='"+id +"',nombre='"+nom+"',cuatrimestre='"+cua +"'where idalumno='"+id);
stmt.close();
cn.Desconectar();
} catch(Exception e){
System.out.println(e);

}
break;

case 'B':
try {
cn=new Conexion();


Statement stmt=cn.getConnection().createStatement();
stmt.executeUpdate( "delete from alumno where idalumno='"+id +"'");
stmt.close();
cn.Desconectar();
} catch(Exception e){
System.out.println(e);

}
break;





}


// TODO add your handling code here:
}

private void btnnuevoActionPerformed(java.awt.event.ActionEvent evt) {

habilitar();
estado='N';
desBotones();

// TODO add your handling code here:
}

private void btneliminarActionPerformed(java.awt.event.ActionEv ent evt) {

habilitar();
estado='B';
desBotones();

// TODO add your handling code here:
}

private void btncancelarActionPerformed(java.awt.event.ActionEv ent evt) {

deshabilitar();

habBotones();

// TODO add your handling code here:
}

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {

int fila=jTable1.rowAtPoint(evt.getPoint());
txtidalumno.setText((String)jTable1.getValueAt(fil a, 0));
txtnombre.setText((String)jTable1.getValueAt(fila, 1));
txtlicenciatura.setText((String)jTable1.getValueAt (fila, 2));
txtcuatrimestre.setText((String)jTable1.getValueAt (fila, 3));






// TODO add your handling code here:
}

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Alumno1().setVisible(true);
}
});
}

// Variables declaration - do not modify
private java.util.List<pruebas.Alumno> alumnoList;
private javax.persistence.Query alumnoQuery;
private javax.swing.JButton btnaceptar;
private javax.swing.JButton btncancelar;
private javax.swing.JButton btneliminar;
private javax.swing.JButton btnmodificar;
private javax.swing.JButton btnnuevo;
private javax.persistence.EntityManager escuelaPUEntityManager;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField txtcuatrimestre;
private javax.swing.JTextField txtidalumno;
private javax.swing.JTextField txtlicenciatura;
private javax.swing.JTextField txtnombre;
private org.jdesktop.beansbinding.BindingGroup bindingGroup;
// End of variables declaration

}