JavaFX Library Software #24 : Deleting Books from Context Menu
In this tutorial I have added option to delete book from the database by selecting from 'book list' window. I have created a context menu for the book list table so that the user can just select the book he wanted to delete and with just right click, can avail the delete option. A book entry cant be deleted from database if it is already issued to someone because of foreign key constraint failures. This is handled in the upcoming video. For deleting an entry from database, we can make use of DELETE sql command as follows DELETE FROM TABLE_NAME WHERE COLUMN_NAME = 'SOME_VALUE'; Github Page : https://github.com/afsalashyana/Library-Assistant - Genuine Coder http://www.genuinecoder.com/
In this tutorial I have added option to delete book from the database by selecting from 'book list' window. I have created a context menu for the book list table so that the user can just select the book he wanted to delete and with just right click, can avail the delete option. A book entry cant be deleted from database if it is already issued to someone because of foreign key constraint failures. This is handled in the upcoming video. For deleting an entry from database, we can make use of DELETE sql command as follows DELETE FROM TABLE_NAME WHERE COLUMN_NAME = 'SOME_VALUE'; Github Page : https://github.com/afsalashyana/Library-Assistant - Genuine Coder http://www.genuinecoder.com/