Skip to content

Java GUI program with connection to MySQL database.

License

Notifications You must be signed in to change notification settings

aelodev/NABO-Bank

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NABO Bank

Logo

Description

NABO Bank is a simple banking application where you can deposit, transfer, see the history of your transactions. It is a simple project to practice the concepts of Java Swing GUI, connection with Database and writing files.

Features

  • Deposit money
  • Transfer money
  • See the history of transactions
  • Save the history of transactions in a file

Technologies

Static Badge

MySQL

Git

IntelliJ IDEA

How to use

  1. Create a MySQL database named banco in XAMMP
  2. Create a table with the following structure, it will be used to store the users of the application:
CREATE TABLE users (
    id INT PRIMARY KEY,
    usuario VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL,
    nombre VARCHAR(255) NOT NULL,
    apellidos VARCHAR(255) NOT NULL,
    saldo DOUBLE DEFAULT 0
);

/*
 Insert a user
 */

INSERT INTO users (id, usuario, password, nombre, apellidos, saldo)
VALUES (1, 'username', 'password', 'First Name', 'Last Name', 100.0);
  1. Create a table history with the following structure:
   CREATE TABLE historial (
    id INT PRIMARY KEY,
    accion VARCHAR(255) NOT NULL,
    usuario VARCHAR(255) NOT NULL,
    cantidad VARCHAR(255) NOT NULL,
    fecha DATE NOT NULL,
    usuario_id INT NOT NULL
   );
  1. Clone the repository
  2. Open the project in your IDE
  3. Run the project
  4. Log in with the user you created in the database
  5. Try the features

Screenshots

Login

General

Transfer

History

Deposit

Export

License

This project is licensed under the GPL 3.0 License - see the LICENSE file for details.

Developed by

This project was developed by Alejandro Lucena, aka aelodev.

About

Java GUI program with connection to MySQL database.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages