Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Joining tables from database and calculation,database values & calculation wants to save in db table

 
P Arunkumar
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I have some doute but i can't say this is database related question or java related question. I am having so much confusion please if i post this question in wrong please please send it to correct place.


I am having 3 tables in database example one is employee , attence, salary from this three table i wants to take each column(ie) from employee.id, attendence.adate, attendence.pdate and salary.amount then by using this iwants to do calculation to generate a payslip for all the employees. How iam having the calculation in struts2.

Now my concept is iam having one jsp page in that iam having one field month that was in drop down and year also drop down, after selecting the two fields iam having one button generate pay slip. once i clicked the button employeeid ,adate,pdate,salary wants to take from that tables and this calculation also wants to do for all the employees at a time and it wants to store in database seperate table.


please guide me, no one not there to traine me in my office iam developing alone please guide me what i wants to do for this.

Now iwants in simple galculation like after clicking generate button month, year,employeeid ,adate,pdate,salary wants to take from that tables and the calculation now is salary divided by pdate the value want sto save in database table.


I tried to do this concept but still iam not getting clear idea, so please guid eme to solve my issue.please solve my issue as soon as possible.

Thanks in advance.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you show us some code you've tried to write? Not all of it, just the part you are having trouble with.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic