I need a JAVA - JDBC professional for a mini console application

  • Posted:
  • Proposals: 4
  • Remote
  • #699606
  • Awarded
Stratos B.
Sako A.Nemshek S.Ankit F. have already sent a proposal.
  • 0

Description

Experience Level: Entry
General information for the business: a console application - phonebook
Description of every module: Write a Console Application which displays a Menu and enables the User to create, read, update
and delete Contacts. Each Contact should have a Name, a Surname and an Email. The application
should also allow the User to assign multiple Tel. to a particular Contact. The Contact Manager Class
(See Appendix) should contain a main() method to place any code related to the Menu and
operations to be undertaken. It should also contain four methods; selectContact(),
insertContact(), updateContact() and deleteContact(). These methods will be
responsible to Select, Insert, Update and Delete Contacts in the Database by using the JDBC API.
Apart from the aforementioned functionality, the Contact Manager can implement any operations
deemed fit for its purpose.

The Contact:
The Contact Class should represent a Contact stored in the Database. The Contact
class should include the Contact Id, Contact Name, Contact Surname, Contact Email together with
the Contact Tel. Nos. The Contact class should implement a Getter and a Setter method for the
Contact Id, Contact Name, Contact Surname, Contact Email variables while a Getter for the Contact
Tel. Nos. variable. The addTelNo() and deleteTelNo() will take care of adding and deleting Tel. Nos.
related to a particular Contact.

Menu
1. Add Contact
2. Edit Contact
3. Delete Contact
4. Show Contacts
5. Search Contacts
6. Exit
Description of requirements/functionality: Write a Console Application which displays a Menu and enables the User to create, read, update
and delete Contacts. Each Contact should have a Name, a Surname and an Email. The application
should also allow the User to assign multiple Tel. to a particular Contact. The Contact Manager Class
(See Appendix) should contain a main() method to place any code related to the Menu and
operations to be undertaken. It should also contain four methods; selectContact(),
insertContact(), updateContact() and deleteContact(). These methods will be
responsible to Select, Insert, Update and Delete Contacts in the Database by using the JDBC API.
Apart from the aforementioned functionality, the Contact Manager can implement any operations
deemed fit for its purpose.

The Contact:
The Contact Class should represent a Contact stored in the Database. The Contact
class should include the Contact Id, Contact Name, Contact Surname, Contact Email together with
the Contact Tel. Nos. The Contact class should implement a Getter and a Setter method for the
Contact Id, Contact Name, Contact Surname, Contact Email variables while a Getter for the Contact
Tel. Nos. variable. The addTelNo() and deleteTelNo() will take care of adding and deleting Tel. Nos.
related to a particular Contact.

Menu
1. Add Contact
2. Edit Contact
3. Delete Contact
4. Show Contacts
5. Search Contacts
6. Exit
Extra notes:

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.