searching and fetching data

You have to develop a basic app to fetch all products from table. Table names should be Product and database name is ProductDB.

View must consist of HTML Table to display all records having following fields:

1. Product Name

2. Product Price

3. Product Type

4. Product Description

Develop view, Model and controller classes. Also write code to fetch this data from database and display to end user in html table. Create a dropdown to search product on the basis of Product type. Also apply pagination functionally and show only five record per page.