Add only 10 records using Java in Mysql

Question

I am making application in Java using Netbeans. I want that admin can only add 10 users record and after 10 users added in database the Admin not able to add more users(my idea is that buttons are disable after 10 users addition). I am using MySQL for record saving.

Answer 1

Fire a count query on your table. And use the resultset to restrict(validate, records<=10) before the app(client) enters a new value. Or put constraint in the schema design itself.