• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

UPDATE multiple records in mysql from javafx after checkout in cart

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am having a cart page where users can checkout after purchasing the products/medicines. I am having a button named checkout on that page. After clicking that button "CheckOut" I want to update multiple records in MySQL from JavaFX after clicking that button. I want the quantity of each item/medicine in the tableView to decreased according to the quantity purchased. I have tried putting the query in for loop I tried to selectAll from the table view. I will provide the code I wrote and a screenshot from the JavaFX tableView with the buttons. Any help is appreciated. Thanks for your time and cooperation from now.




CART.PNG
[Thumbnail for CART.PNG]
 
Evildoers! Eat my justice! And this tiny ad's justice too!
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic