Using MySql create a Database with a table named NovelTitles that has the following attributes Novel Name, Author, Genre, Main Character and Rating/Review.
Create an HTML Form that allows the above attributes to be added/deleted to the data base by transmitting the form's input variables to a designated JSP program which adds these values to the database.
Verify the additions/deletions by manually displaying the database tables before and after additions.
Test and Document appropriately. Make sure that all data in fields are valid.
You will be using the MySql database.
1. Add a password field to the form and protect the database with a password, rejecting access if the password fails. Use POST method on form so password is not overtly exposed in the query string.
2. Use a radio button option on the form to allow the user to either insert or delete from the database.