Skip to content

Task manager console application built with JDK 11.0.12, MySQL & MySQL connector.

License

Notifications You must be signed in to change notification settings

eduardocruzpalacios/tasks-manager-java-mysql-connector

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Tasks Manager

Task manager console application built with JDK 11.0.12, MySQL & MySQL connector: JDBC Driver for MySQL (Connector/J).

Functionality

Tasks

  • Create one
  • Read and print all
  • Delete one
  • Update one

Architecture

package purpose
model model for objects (attributes, constructors, getters, setters & .toString())
dao methods to communicate with data source and perform the tasks demanded by the business logic
service interfaces with business-logic-oriented methods along with the classes implementing them
controller the flow of the application
view information showed to users and requested from them
utility methods for frequently needs

Data Structure

data structure
Task int id, String title, String content, boolean isCompleted, LocalDateTime dateCreated

Data Source

MySQL database.

SQL statements to create the database and table along with CRUD queries are provided.

Testing

  • Unit tests are made with JUnit 5
  • Only model classes are tested

Libs

  • Log4j-api-2.7.jar
  • Log4j-core-2.7.jar