ccole/restfuljavaservice

CRUD application (Tomcat, Tomcat CORS filter, Microsoft JDBC, Jersey 2.23.2)

restfuljavaservice's Issues

Connect to Staff_Cred sql server db

• Download Microsoft JDBC Driver 6.0
• Decide between JDTS and Microsoft JDBC Driver
• Connect servlet to Staff_Cred db

Create Credential Object

Credentials represent licenses and certifications. They validate specialties.
The credential object consists of:

• int specialtyID
• string appInProcessExplanation
• string credentialNumber
• date credentialAcquired
• string issuingState
• string status

Create Credential Status Object

Credential status can be 'in process', 'expired', 'current', 'suspended
This object consists of

• int statusID
• string statusType
• string statusDescription

build a class which maps sql data types with java data types

to retrieve an entire row of the Staff table result set

Create Specialty Object

A specialty is the area of expertise of a staff member. A staff member can have many specialties. Credentials are associated with specialites and are used to validate the area of expertise. All specialties may not require credentials. The Specialty Object shall consist of:

1. int staffID
2. int specialtyID
3. string Specialty
4. string Description

Create Renewal Object

For each credential there can be a renewal. Each time that a credential is renewed a new expiriation date is entered. Each Credential can have many renewals.
The renewal object consists of

• int credentialID
• int credentialExpirationID
• date expirationDate