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...