Guest User

Untitled

a guest
Nov 25th, 2018
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  1. public void llenadocombobox2() {
  2. Connection conn=null;
  3. try {
  4. ObservableList<String> listacombonombre= FXCollections.observableArrayList();
  5. String consulta = "select nombre from entidad";
  6. conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");
  7. PreparedStatement ps =conn.prepareStatement(consulta);
  8. ResultSet rs = ps.executeQuery();
  9. while ( rs.next() )
  10. {
  11. listacombonombre.add(rs.getString("nombre"));
  12. }
  13. entidad.setItems(listacombonombre);
  14. } catch (SQLException e) {
  15. e.printStackTrace();
  16. }
  17. }
  18.  
  19.  
  20. public void llenadocombobox3() {
  21. String DatoCombo2= entidad.getSelectionModel().getSelectedItem();
  22. Connection conn=null;
  23. try {
  24. ObservableList<String> listacombonit= FXCollections.observableArrayList();
  25. String consulta = "select nit from entidad where nombre='"+DatoCombo2+"'";
  26. conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");
  27. PreparedStatement ps =conn.prepareStatement(consulta);
  28. ResultSet rs = ps.executeQuery();
  29. while ( rs.next() )
  30. {
  31. listacombonit.add(rs.getString("nit"));
  32. }
  33.  
  34. nit.setItems(listacombonit);
  35.  
  36. } catch (SQLException e) {
  37. e.printStackTrace();
  38. }
  39. llenadocombobox2();
  40. }
  41.  
  42. ObservableList<String> listacombonombre= FXCollections.observableArrayList();
  43.  
  44. patrones.getItems().addAll("XML Clientes -> MMAA_RfcReceptor_Folio+Serie_sociedad(RfcEmisor)_Importe",
  45. "XML Proveedores -> MMAA_RfcEmisor_Folio+Serie+_sociedad(RfcReceptor)_Importe",
  46. "XML Complementos -> COPAPRO_MMAA_RfcEmisor_sociedad(RfcReceptor)_Importe",
  47. "XML SAT -> revisar"
  48. );
Add Comment
Please, Sign In to add comment