Skip to content

Latest commit

 

History

History
69 lines (44 loc) · 2.83 KB

README.md

File metadata and controls

69 lines (44 loc) · 2.83 KB
Raw

Bank Application - Java RESTful API

Description

An application for remote management of bank accounts. It was made using Java, Jakarta RESTful web services (JAX-RS API, Jersey implementation), MySQL (and JDBC API), IntelliJ IDEA Ultimate and Glassfish 6.2.4.

Tested using Mozilla Firefox and Postman.

This project was made during my Network programming course in University.

The application offers the following actions

  1. Create account
  2. Deposit amount
  3. Withdraw amount
  4. Transfer to another account
  5. Enable/Disable account
  6. View details of an account (XML/JSON)
  7. View details of all accounts (XML/JSON)
  8. Delete account

For simplicity, we assume that the user can execute the above actions to any account simply by knowing the Account ID. (i.e without requiring any kind of authentication).

Endpoints

  1. http://localhost:8080/BankApp-1.0-SNAPSHOT/ //main page

  2. http://localhost:8080/BankApp-1.0-SNAPSHOT/addAccount.html

  3. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/deposit/<aid>?amount=<amount>

  4. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/withdraw/<aid>?amount=<amount>

  5. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/transferBalance/<aid>?aid2=<aid>&amount=<amount>

  6. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/updateAccountStatus/<aid>/<status>

  7. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/allAccounts_json/<aid> http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/allAccounts_xml/<aid>

  8. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/allAccounts_json http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/allAccounts_xml

  9. http://localhost:8080/BankApp-1.0-SNAPSHOT/api/bankService/delete/<aid>

Where <aid> insert the appropriate account id, and <amount> insert the appropriate amount.

<status> is either activate or deactivate.

Database

The sql file creates the database bank_accs which contains the following table:

aid name surname contactPhone address accBalance activated
10 CHRIS TSOUCHLAKIS 6986868969 Street 42 100 1
11 MARKOS MARKOY 6985368422 Street 47 225 1
12 IWANNA IWANNOY 6976663345 Street 107 150 1
13 IWANNHS IWANNOY 6977775569 Street 107 10 1
14 GIWRGOS GIWRGOY 6966665544 Street 21 1000 1

The database also creates a user named 'TSOUCHLAKIS' with password '1234', with all privileges granted. This user is required for the JDBC API to connect with the database.

Requirements

  1. Glassfish (tested on version 6.2.4) or Tomcat
  2. MySQL installation
  3. JDBC API (included)
  4. JAX-RS API (included, also comes with Glassfish)