Hey guys,
I am developing a simple
JSP web application where i need to display the customer details for the whole year in this format.
http://www.imagechicken.com/uploads/1250760495076437000.jpg
See the above image. But now my problem is i am completely out of idea in doing this. Coz i am having two tables and need to retrieve the necessary data's from those table in order to display the report like the above format.
Here is my code to achieve this...
* the
iapplicationno is the primary key of the
icustomer table and
foreign key of
txioninstall table.
* a single customer can have more than one entry in
txioninstall table,according to the month and year he paid.
* i just need to display the details of customer like in the picture(please see the link), so first i retrieve the aplplication no from icustomer table and look for relevant entry in txioninstall table, and i am able to get the data's but i dont know how to do this. I am having 12 fields representing 12 months and unable to print the value in it.
Please guys shed some light on this issue.. I am very thankful if you'd help me guys...