to-do-list-app-jdbc's Introduction

To-do list app in Java with JDBC

A To-Do List app using java. User can create account, login, add tasks, change or delete tasks, change password and delete account. It connects to app database (MySQL) with JDBC (Java Database Connectivity) through the Java code. JDBC is one of the standard APIs for database connectivity, using it we can easily run our query, statement, and also fetch data from the database. I have used Swing (GUI widget toolkit for Java) for this app.

Requirements

JDK
MySQL
Maven

IDE Used

IntelliJ IDEA

How to run

Ubuntu

Using an IDE

* Install mysql-server : sudo apt-get install mysql-server
* git clone this project
* Open your IDE and import the project.
* Make sure IDE recognizes the project as a Maven project and downloads the necessary dependencies.
* Locate the main class of the project.
* Right-click on the main class and select "Run" or "Run As" > "Java Application" (options may vary depending on IDE).
* The project will now run.

You dont need to create any database or tables as database and tables will created by app. But if you want to create initial user_info tables to fill some values follow this steps:

* Start mysql : sudo mysql -u root -p ( password - root)
* To create database : CREATE DATABASE to_do_list_app;
* Connect to database : connect to_do_list_app;
* Create user_info table : CREATE TABLE user_info( user_id varchar(20), user_password varchar(20), PRIMARY KEY (user_id));
* Now that table is created, you can fill some values which you want initially using mySQL commands.Same can also be done by using GUI.