Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void llenadocombobox2() {
- Connection conn=null;
- try {
- ObservableList<String> listacombonombre= FXCollections.observableArrayList();
- String consulta = "select nombre from entidad";
- conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");
- PreparedStatement ps =conn.prepareStatement(consulta);
- ResultSet rs = ps.executeQuery();
- while ( rs.next() )
- {
- listacombonombre.add(rs.getString("nombre"));
- }
- entidad.setItems(listacombonombre);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- public void llenadocombobox3() {
- String DatoCombo2= entidad.getSelectionModel().getSelectedItem();
- Connection conn=null;
- try {
- ObservableList<String> listacombonit= FXCollections.observableArrayList();
- String consulta = "select nit from entidad where nombre='"+DatoCombo2+"'";
- conn = DriverManager.getConnection("jdbc:sqlserver://DESKTOP-4JA6SFR:1433;databaseName=GLOSASNINO", "sa", "123");
- PreparedStatement ps =conn.prepareStatement(consulta);
- ResultSet rs = ps.executeQuery();
- while ( rs.next() )
- {
- listacombonit.add(rs.getString("nit"));
- }
- nit.setItems(listacombonit);
- } catch (SQLException e) {
- e.printStackTrace();
- }
- llenadocombobox2();
- }
- ObservableList<String> listacombonombre= FXCollections.observableArrayList();
- patrones.getItems().addAll("XML Clientes -> MMAA_RfcReceptor_Folio+Serie_sociedad(RfcEmisor)_Importe",
- "XML Proveedores -> MMAA_RfcEmisor_Folio+Serie+_sociedad(RfcReceptor)_Importe",
- "XML Complementos -> COPAPRO_MMAA_RfcEmisor_sociedad(RfcReceptor)_Importe",
- "XML SAT -> revisar"
- );
Add Comment
Please, Sign In to add comment