Remote Database connection MYSQL

Hi All,

We are working on CE 7.1.

We have a requirement of getting list of employee list from MYSQL database.we have done the fallowing steps:

1) Deployed MySQL compatable driver through java tenet

2) Deployed datasource(say mydatasource) successfully.

3) I tested this data source with TEST_DS command and it was fine.

Now i want to develop webservice which returns the list of employees from the MYSQL database.

Can you plz send me the sample code of accessing this datasource and getting connection to that in a java class .

Thanks

Sampath.G