I have a Programming Project that i am working on that also has some SQL in it.

The project needs to keep a SQL database that holds information about a Project management system.

The database will hold information such as who is working on it, project number, project name, the charge per hour and things like that.

Im not looking for someone to do this for me, rather im trying to figure out how to do it.

I'm familiar with Java, but not very familiar with SQL. I know there is a library i need to use in order for this to work. Im just wondering how the SQL section of it will work with Java. Examples of code updating information in the database would be nice.

The program needs to be able to do the 5 things below.

1. Add new projects, employees, job titles.

2. Assign employees and leaders to projects.

3. Update working time of employees for projects

4. Compute wages for employees and projects costs

5. Update job titles (description, pay rate)