I am trying to built an application using JSP and MYSQL.
The problem is as follows.
"signup" table - Schema as
CompanyID: Username: Password
int varchar :Varchar
1 :A: :xxx
1 :B: :xxxx
2 :c: :xxxx
3 :d: :xxxx
"Participants" Table - schema as
Companyid :Empname : EmpLastName
int : Varchar : varchar
1 :ABC1 : XYZ1
1 :ABC2 :XYZ2
2 :ABD1 : XYY1
2 :ABD2 :XYY2
... ... ...
The signup page should accept username and password and validate against Signup table, upon validation the user should be taken to a page where they can List Participants only from his own company.
(The user should only see employees from his own company)
For example - User A,or Use B companyID = 1 when signs in , he should only see employees ABC1, ABC2
Like wise when Use A , CompanyID = 1 enters a participant, they should automaticaly enter companyID as 1 in the particiant table along with Empname and EmplastName
Any idea on how this is achieved will be appreciated. Sessions ?
I am helping a Charity Orgnaization to develop this and above is a simplified example of their problem.
Options to use only MYSQL and tomcat and JSP.
Any info will be truely appreciated.
Thanks,