Download - ClientER Progress Presentation
ClientER Progress PresentationOmar JamalStéphane LeeMarcel Sauvé
Client Description
•Company CEO’s named Alexandra Russell and France Landry
•French tutoring and camp services•They need a way to manage their client
data!•http://www.frenchsolutions.ca/
Program Description•Company needs a program, we need to
program!
•Therefore, we create an application named ClientER
Client database for services and income Designed specifically for FrenchSolutions Helps company convenience and efficiency
Program Features•The database will include several
features:1. Mass mailing services2. Tax return print table3. Encryption for security4. Compression for storage5. Network updating for easy access6. All basic database table options
View, add, delete, edit, print, search, save
Task DivisionOur company is formed of three
individuals:
•Marcel Network, compression and encryption
•Omar GUI pages; login screen, registration, and emergency data
•Stéphane Database GUI and functions, and company relations
Let’s begin on what we’ve accomplished…
Login Page GUI•Contains hashing
for password security
•Only one main account, as requested by FrenchSolutions
•Logo design
Menu GUI•Includes quick
access options•Adds to database
memory, which is already loaded into Vector of Vectors from main file
Database GUI
Database GUI (cont…)•Add and removes columns•Edits data and saves it to file•Filter for quick easy search•Sorting, which can be used for mass
mailing•Column order does not affect data•Allows backup
Encryption and Network•Encryption used on database files•Server application manages database
updates•Allows for communication between server
application and client (useful for multiple registrations)
Past Problems and Solutions - Omar•Problem #1: The login name and password
was stored as regular strings, which is unsafe.
•Solution #1: SHA method is used.
• Problem #2: Adding a new client by taking from JTextFields directly is inefficient.
•Solution #2: Made a new class ‘Client’ to hold all information of each individual client.
Past Problems and Solutions - Stéphane•Problem #1: The database would not load
properly from file.•Solution #1: A program called XVII was
used to debug the file. RandomAccessFile class was used to read and write.
•Problem #2: The table was difficult to make by using a series of JTextFields.
•Solution #2: The Jtable class was used.
Past Problems and Solutions - Marcel•Problem #1: Custom encryption is easily
breakable.•Solution #1: Use Java Crypto classes.
•Problem #2: Multi-Threading caused massive computer breakdowns.
•Solution #2: Do not use multi-threads
Current Problems
•Network issues with server connection (Java crashing)
•Mass mailing is difficult to implement using email server
•Camp registrations based on date should be implemented
To do’s•Connecting all ClientER work together•Emergency contact pane•Financial database linked to clients, and
printing•Complete file updating on the network•Fixing all bugs•Client documentation/paperwork•Adding all of their clients to the database
Demos•We will now demo the program ClientER.
▫1. The login and menu pages▫2. The database functions▫3. The network abilities