Question

is due in 2 hours so i had to repost, sorry.

Create an application that allows you to manage a task list that’s stored in a database. using java and netbeans

Console:

Task List

COMMAND MENU

view - View pending tasks

history -View completed tasks

add -Add a task

complete -Complete a task

delete -Delete a task

exit -Exit program

Command: view

1. Buy toothbrush

2. Do homework

Command: complete

Number: 2

Command: add

Description: Pay bills

Command: view

1. Buy toothbrush

2. Pay bills

Command: history

1. Get bike fixed (DONE!)

2. Call your mom (DONE!

)3. Do homework (DONE!)

Command: exitBye!

Specifications

there is adatabase file (task_list.sqlite) that contains a table that stores the tasks.

Create a class named Task that you can use to store the data for a task.

Create a class named TaskDB that contains the data access methods necessary for this application.

The method for viewing tasks should only display pending tasks.

The method for completing a task should only mark a task as completed, not delete it from the database.

The method for viewing the history should only display completed tasks.

The method for deleting a task should only allow a completed task to be deleted.

Use prepared statements.Make sure to close the database connection, prepared statement, and result set after each database operation.

For a new task, make sure the user enters a non-empty string.

If the application encounters any exceptions, it should display them on the console.

Use packages to organize the classes for this application.

/////////////////////////////////////////////////////////////////////////////////////////////

Hints

Before you can mark a task as completed, you need to retrieve all pending tasks so you can get the task id for the selected task. Similarly, before you can delete a task, you need to retrieve all completed tasks so you can get the task id for the selected task.

Because the TaskID column in the Task table is generated automatically, you don’t include it in the column list when you add a row to the table. Also, the value of the Completed column for a new row should be 0.

https://gofile.io/?c=RsoU7E