Transcript JAVA Implementation of the Database for Unitarian

JAVA Implementation
of the Database for Unitarian
Universalist Church (UUC)
By Stacey Doyle, Patrick Heisel, Rebecca Reed, and
Jennifer St. Germain
Members of the Team
 Analyst/Documentation: Rebecca Reed and Stacey Doyle
 System architect: Jennifer St. Germain
 Programmer Engineer: Patrick Heisel
Database and
User Requirements
 would facilitate easier input, access, and retrieval of
documents on the part of the church staff
 church staff can access documents by person, event, or
document
 will be the church’s archivist, the church administrator, the
administrative assistants, and the oral history committee
 users did not have extensive technical experience
Wireframes
 the search down to two functions: the user can search
documents by document function, or they can search
documents by person
1.
2.
3.
4.
Search page
Result page
Add/Remove New Document
Add/Remove Owners
Wireframe 2
Procedures:
1. Search for person or event first
1. Match with person or description
2. Grab all matches from intermediate table
3. Use the intermediate table list to get actual list of
documents
4. Output list of documents with information
JAVA Objects
Person {PersonID int =>
person_document table
FirstName string
Initial char
LastName string
PersonDesc string
Document {DocID - int
DocName - string
DocDate - string
DocLocation - string
DocType – string
ContaintIn- string
Owners--array of person/objects
Methods
 doGet() – The input form
 doPost() – The results page
 Connect()
 Connect to Database
 findOwners(int docid)
 Finds a list of people associated with a document
 Stores them in an ArrayList of Person objects
Methods Cont.
 findDocumentsByPerson(String term)
 Finds documents with People who match term
 Called findOwners() to populate Document owners list
 Stores and returns Document objects in ArrayList
 findDocumentsByDescription(String term)
 Finds documents with descriptions matching term
 Calls findOwners() to populate Document owners list
 Stores and returns Document objects in ArrayList
JAVA Implementation
Let’s See the DEMO!