Searching a database table for specific information

In this recipe, we will be learning how searching is performed in a database table to fetch the desired information. We assume that a user has forgotten their password. So, you will be prompted to enter the database name, table name, and email address of the user whose password is required. If any user with the email address supplied exists in the database table, then the password of that user will be searched for, accessed, and displayed on the screen.

How to do it…

Follow these steps to find out how data can be searched for in a database table in SQLite:

1. Let's create an application based on the Dialog without Buttons template.
2. Add five QLabel widgets, four QLineEdit widgets, and one QPushButton widget to the form by dragging and dropping five Label widgets, four Line Edit widgets, and one Push Button widget on the form.
3. Set the text property of the first three Label widgets to Enter database name, Enter table name, and Email Address.
4. Delete...