@FXML
    private JFXTextField jfautocom;

    private DatabaseHandler datahandler;

final ObservableList<String> auto =FXCollections.observableArrayList();

    @Override
    public void initialize(URL url, ResourceBundle rb) {
        datahandler = DatabaseHandler.getInstance();

    }

@FXML
    private void autocomp(MouseEvent event)
{ String testName = jfautocom.getText();
        TextFields.bindAutoCompletion(jfautocom, auto);

        try {

            String quy = "SELECT `name` FROM `vendor`";
            ResultSet resultset = datahandler.execQuery(quy);
            while (resultset.next()) {
                testName = resultset.getString("name");
            }

             jfautocom.setText(testName);
                auto.add(testName);

        } catch (SQLException ex) {
            Logger.getLogger(AutocomtestController.class.getName()).log(Level.SEVERE, null, ex);
        }
}