Skip to content

🏠 Addrook | Simple address book simulator with SQLite JDBC and GUI

License

Notifications You must be signed in to change notification settings

mhaidarhanif/addrook

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Addrook

Important Notes

This version has both database and array based version. A new JAR file can be obtained by building a JAR artifact with correspond manifest and library, this can be done easilty through any JAR building method such as IntelliJ IDEA JAR builder. Since the GUI layout and components are only using provided Java standard library, this project can be develop anywhere. No client server but SQLite JDBC library is needed as the database version is using SQLite. Therefore, for debugging purpose SQL command code file is included in source.

Every main class is postnamed with App and located in main.gui package:

  • Array: AddrookArrayApp.java
  • Database: AddrookSimpleDBApp.java
  • Improved Database: AddrookDBApp.java

The simple database version is so simple, it just works to insert, browse, and find. It's only using one single database file and create addressbook.db automatically when it doesn't exists.

The array version is more advanced and did a better job handling the data because the required data is still a few, though it's harder to maintain. But in advantage, the storage footprint file is smaller in byte size. Its original base code acknowledgment is stated in each its Java source file header comment. Most code consists from several different sources then improved for specific purpose. This one will be continued to develop toward the real database version.

Identification

Title:  Addrook
Ver:    1.0
Desc:   Simple address book simulator with basic features

Class:  SMTI06
NPM:    54411850
Name:   M Haidar Hanif

ID:     Task Six
Docs:   Java™ How to Program, Seventh Edition & OOAD_Example
Chap:   2 & 3. Software Engineering Case Study
Page:   63 - 522 & 1215 - *
Date:   April 2013

Objectives

  • Address Book
  • UML Diagrams
  • Person Database
  • SQL Queries
  • GUI Application

Project Structure

addrook
├── src
├── lib
├── out
├── diagrams
├── .idea
├── .git
├── addrook.iml
├── README.mkd
├── LICENSE
└── .gitignore

Learning Step

  1. Object-Oriented Programming
  2. Java Programming Language
  3. Unified Modeling Language Diagram
  4. GUI Application with Swing
  5. SQL Database with SQLite

Requirements

  1. The software to be designed is a program that can be used to maintain an address book. An address book holds a collection of entries, each recording a person's first and last names, address, city, state, zip, and phone number.
  2. It must be possible to add a new person to an address book, to edit existing information about a person (except the person's name), and to delete a person. It must be possible to sort the entries in the address book alphabetically by last name (with ties broken by first name if necessary), or by ZIP code (with ties broken by name if necessary). It must be possible to print out all the entries in the address book in "mailing label" format.
  3. It must be possible to create a new address book, to open a disk file containing an existing address book to close an address book, and to save an address book to a disk file, using standard New, Open, Close, Save and Save As ... File menu options. The program's File menu will also have a Quit option to allow closing all open address books and terminating the program.
  4. The initial requirements call for the program to only be able to work with a single address book at a time; therefore, if the user chooses the New or Open menu option, any current address book will be closed before creating/opening a new one. A later extension might allow for multiple address books to be open, each with its own window which can be closed separately, with closing the last open window resulting in terminating the program. In this case, New and Open will result in creating a new window, without affecting the current window.
  5. The program will keep track of whether any changes have been made to an address book since it was last saved, and will offer the user the opportunity to save changes when an address book is closed either explicitly or as a result of choosing to create/open another or to quit the program.
  6. The program will keep track of the file that the current address book was read from or most recently saved to, will display the file's name as the title of the main window, and will use that file when executing the Save option. When a New address book is initially created, its window will be titled "Untitled", and a Save operation will be converted to Save As ... - i.e. the user will be required to specify a file.

Resource

Some source code released under MIT License and available in GitHub repository.

Graphics released under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported.

About

🏠 Addrook | Simple address book simulator with SQLite JDBC and GUI

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages