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 YZ2
2 :ABD1 : XYY1
2 :ABD2 YY2
... ... ...


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,