EXPANSIVE SYSTEM

This project provides the basic functionality that can be customized by subclassing and using pre-built classes

DEMO COURAGE PROJECT

FUNCTIONAL

• CRUD data through RESTful
• Read, write multiple file as json api
• Other: email, jwt, customize-display, etc...
  • Send email, management random code same as cookies (key:value, age).
  • Authentication and decentralization between client and server through json web token (jwt).
  • Statistic account with Chart JS (regTime, quantity, relationships...).
  • Customize display on web-app (navbar > setting)
  • ACCESS data: AWAIT, LOCK (soft-delete), PRIVATE, PROTECTED, PUBLIC
  • Connect to the rdbms (SQL Server) and CRUD through jdbc.

TECHNOLOGIES USED

• RDBMS (Sql Server 2014+)
• Java (v17+), Spring-boot(v3.0.x)
  • Libraries SEE: jpa, web, jdbc, lombok, tomcat, thymeleaf, security, oauth2-client, oauth2-resource-server, email, devtool.
  • Source server configuration: application.yml
    • mssql: username : password default "sa" : "your mssql server's password"
    • email: username : password
• Javascript (ES6)
  • Frameworks: AngularJS(v1.8), Bootstrap(v5.1)
  • Libraries: AngularJS(router, cookies), ChartJS(v4.3.2)
• FRONTEND: HTML5 - CSS3
  • font-awesome-v6.4.0
  • bootstrap-v5.1.3

ACCOUNTS

USERNAME	PASSWORD	ROLES	IS ACTIVE
admin	123	ADMIN, STAFF, USER	✔
staff	123	STAFF	✔
user1	123	USER	✔
user2	123	default:[USER]	❌
partner	123	PARTNER	✔

SETUP COURAGE PROJECT

SCRIPTS DATABASE FILE

1. File scripts create database: open mssql_base_super.sql
   
2. File scripts insert database: open mssql_data_super.sql

DEPLOYMENT

• Requirements
  • SQL Server 2014 or later sqlcmd -?
  • JDK 17 or later java -version
  • Maven 3.x.x mvn -v
  • If you use Git git -v
• Guide
  1. git clone https://github.com/studev1922/courage.git or download courage-main.zip and extract file
  2. Point to the project cd [...path to the project]/courage
  3. Execute database
     • Create database sqlcmd -f 65001 -i assets/mssql_base_super.sql
     • Insert database sqlcmd -f 65001 -i assets/mssql_data_super.sql
  4. Start server with maven mvn clean spring-boot:run -X
  5. Start courage/client/index.html with Live Server or copy all files in courage/client and paste to courage/src/main/resources/static : robocopy client src/main/resources/static /e or courage/src/main/webapp : robocopy client src/main/webapp /e
  6. Open client and server
     • Open link With Live Server http://127.0.0.1:5500/client/index.html
     • Open link With static or webapp http://localhost:8080/index.html
     • localhost
       • http://127.0.0.1:5500 or http://localhost:5500
       • http://localhost:8080 or http://127.0.0.1:8080
       • path /server or /client or /index.html

ABBREVIATE

• execute two files in mssql(SQL Server)

  • create database
  • insert data into database

• check jdk version and maven version

  • Java: java -version
  • Maven: mvn -v

• start server in

  1. Main java: Application.java
  2. Maven run: mvn clean spring-boot:run

• open app on

  1. mvn: http://localhost:8080/index
  2. mvn: http://localhost:8080/server
  3. run as Live Server or any... http://127.0.0.1:5500/client/index.html