Advertisement
Guest User

Untitled

a guest
Dec 27th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.96 KB | None | 0 0
  1. private void BuscarNomActionPerformed(java.awt.event.ActionEvent evt) {
  2. String[] titulos = {"NOMBRE","# REPORTE","GRUPO","SISTEMA","FECHA","MOTIVO","SUSPENSION"};
  3. String[] registro = new String[7];
  4.  
  5. DriverManager.registerDriver(new com.mysql.jdbc.Driver());
  6. Connection unaConexion = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/umaya", "root", "");
  7. java.sql.Statement instruccionSQL = unaConexion.createStatement();
  8.  
  9. String Nomb=Nombre.getText();
  10.  
  11. modelo = new DefaultTableModel(null, titulos);
  12.  
  13. Conexion mysql = new Conexion();
  14. Connection cn = mysql.Conectar();
  15. Statement st;
  16.  
  17. sSQL = "SELECT nombre,numero_reporte,gradoygrupo,sistema,fecha,motivo,suspension FROM generaldb WHERE nombre LIKE '%"+Nomb+"%'";
  18.  
  19.  
  20.  
  21. String cadena;
  22. Integer co=0;
  23.  
  24. try {
  25.  
  26. st = cn.createStatement();
  27. ResultSet rs = st.executeQuery(sSQL);
  28.  
  29. while (rs.next()) {
  30. String cow = rs.getString("nombre");
  31. //INGRESO EL RESULTADO A MI TABLA
  32. registro[0] = rs.getString("nombre");
  33. registro[1] = rs.getString("numero_reporte");
  34. registro[2] = rs.getString("gradoygrupo");
  35. registro[3] = rs.getString("sistema");
  36. registro[4] = rs.getString("fecha");
  37. registro[5] = rs.getString("motivo");
  38. registro[6] = rs.getString("suspension");
  39.  
  40. modelo.addRow(registro);
  41. }
  42. Tabla.setModel(modelo);
  43. }
  44. catch (SQLException ex)
  45. {
  46. JOptionPane.showMessageDialog(null, "no se ingreso a la base de datos ");
  47. }
  48.  
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement