WebApp Bank Account Manager

Webapp-Bank-Account-Manager

Aplikasi Web Sederhana tempat Anda dapat membuat dan mengontrol akun keuangan seperti berdasarkan peran pengguna atau admin.

Teknologi bekas:

• JDK 10

• Apache Tomcat 9

• Musim Semi 5: Musim Semi MVC, Keamanan Musim Semi

• Mysql 8

• Hibernate 5.3.0

• Maven

• Web: JSP, Bootstrap 4, JQuery

Aplikasi ini di Heroku: https://webapp-account-manager.herokuapp.com/

Tangkapan layar:

Tabel untuk membuat:

 CREATE TABLE ` app_user ` (
  ` id ` bigint ( 20 ) NOT NULL AUTO_INCREMENT,
  ` sso_id ` varchar ( 30 ) NOT NULL ,
  ` password ` varchar ( 100 ) NOT NULL ,
  ` first_name ` varchar ( 30 ) NOT NULL ,
  ` last_name ` varchar ( 30 ) NOT NULL ,
  ` email ` varchar ( 30 ) NOT NULL ,
  PRIMARY KEY ( ` id ` ),
  UNIQUE KEY ` sso_id ` ( ` sso_id ` )
);

create table USER_PROFILE (
  id BIGINT NOT NULL ,
  type VARCHAR ( 30 ) NOT NULL ,
  PRIMARY KEY (id),
  UNIQUE (type)
);

INSERT INTO USER_PROFILE(id, type)
VALUES ( 1 , ' USER ' );
INSERT INTO USER_PROFILE(id, type)
VALUES ( 2 , ' ADMIN ' );

CREATE TABLE ` app_user_user_profile ` (
  ` user_id ` bigint ( 20 ) NOT NULL ,
  ` user_profile_id ` bigint ( 20 ) NOT NULL ,
  PRIMARY KEY ( ` user_id ` , ` user_profile_id ` ),
  KEY ` FK_USER_PROFILE ` ( ` user_profile_id ` ),
  CONSTRAINT ` FK_APP_USER ` FOREIGN KEY ( ` user_id ` ) REFERENCES ` app_user ` ( ` id ` ),
  CONSTRAINT ` FK_USER_PROFILE ` FOREIGN KEY ( ` user_profile_id ` ) REFERENCES ` user_profile ` ( ` id ` )
);

CREATE TABLE ` persistent_logins ` (
  ` username ` varchar ( 64 ) NOT NULL ,
  ` series ` varchar ( 64 ) NOT NULL ,
  ` token ` varchar ( 64 ) NOT NULL ,
  ` last_used ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
  PRIMARY KEY ( ` series ` )
);

CREATE TABLE ` user_account ` (
  ` user_id ` bigint ( 20 ) NOT NULL ,
  ` id ` bigint ( 20 ) NOT NULL AUTO_INCREMENT,
  ` account_number ` bigint ( 20 ) NOT NULL ,
  ` amount ` decimal ( 10 , 2 ) NOT NULL ,
  ` date_time ` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  PRIMARY KEY ( ` id ` ),
  KEY ` amount_user ` ( ` user_id ` ),
  CONSTRAINT ` amount_user ` FOREIGN KEY ( ` user_id ` ) REFERENCES ` app_user ` ( ` id ` ) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE TABLE ` user_avatar ` (
  ` id ` bigint ( 20 ) NOT NULL AUTO_INCREMENT,
  ` user_id ` bigint ( 20 ) NOT NULL ,
  ` name ` varchar ( 100 ) NOT NULL ,
  ` type ` varchar ( 100 ) NOT NULL ,
  ` content ` longblob NOT NULL ,
  PRIMARY KEY ( ` id ` ),
  KEY ` avatar_user ` ( ` user_id ` ),
  CONSTRAINT ` avatar_user ` FOREIGN KEY ( ` user_id ` ) REFERENCES ` app_user ` ( ` id ` ) ON DELETE CASCADE ON UPDATE CASCADE
);