I dont think here anyone will take the assignments
What have you written till now or thought of writing? Let us know that first.
Even if not in Struts, are you aware of retrieving the data from the database and display it? If your answer is NO to this question, please read about JDBC and the way you can interact with database and how you can get the values from the database. As this is the basic for any database related operations in your application.
Then you can think of displaying it in JSP and through Struts.
First of all you should not connect to database direct from Struts actions. This should be done in the model layer. The model layer can be built outside the struts framework so the best place to ask this type of question is in the JDBC forum, or check the Hibernate ORM framework.
When I googled "database connection in struts" I got a lot of hits. Haven't read them but please try google for this first