When it comes to deleting entries in a database.... I don't..... I normally have a field called 'delete' and when I do the insert into database that field is given a 'N' value... and of course when i delete the entry it is updated to 'Y'.... of course the queries to the table must have a 'WHERE 'delete' = 'N'' to display the data.
public int deleteRecord(String mName, String mSurname)
I assume that there fields corresponding to the above variables in the database....
I also notice that there is no connection to the database....or is the host, password and username entered elsewhere
Before you can query the db.... you need to connect to the db
With the assumptions I made above, the code to delete would be.... also when doing a query I like to put as many criteria as i can in to narrow the search, and by putting LIMIT 1.... will only change 1 row.
"DELETE FROM People WHERE mName = 'mName' AND mSurname = 'mSurname', LIMIT 1"