Joining tables from database and calculation,database values & calculation wants to save in db table
posted 4 years ago
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.