This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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