JMTrain - Java course manager

Description

Application allow to management courses. Program allow edit personal users data and add enrollments for courses. The application is secure - sends confirmation via email after registration and encrypts passwords. Database writes data use algorithm MD5.

Changelog

• 0.0.4 - add better README.MD, fix bugs with names. Clear start page.
• 0.0.5 - update README.MD, fix bugs with configuration, update dependencies, add configuration xml file

Requirements

Software

• IDE
  • IntelliJ IDEA Ultimate - EAP
• Java
  • Oracle JDK (better option on Windows)
  • OpenJDK (better option on Linux)
• Database engine:
  • MySQL Server.
  • MariaDB part of XAMPP.
• Tomcat - HTTP server for Java
• Maven integrated with your IDE.

Maven dependencies

• junit-jupiter-api 5.8.2
• mysql-connector-java 8.0.29
• javax.servlet-api 4.0.1
• commons-logging 1.2
• spring-beans 5.3.20
• spring-core 5.3.20
• spring-jdbc 5.3.20
• spring-tx 5.3.20
• taglib-standard-impl 1.2.5
• taglib-standard-spec 1.2.5
• junit 4.13.2
• javax.mail-api 1.6.2

Deployment guide

General information

1. Download and unpack JDK from Oracle (Windows x64 Compressed Archive)
2. Add Java to the PATH on Windows 10 - HELP
3. Clone repository using GIT or download zip archive.
4. Open project in your favourite IDE or compile class from command line.

Open project using IntelliJ IDEA

1. IntelliJ IDEA Ultimate - EAP
2. Clone project from GitHub - HELP

Configuration application server using IntelliJ IDEA

1. Download and unpack Tomcat from Apache Foundation.
2. Setting up Tomcat - Details
   • Uncompressed the folder anywhere you want
   • Click on Run -> Edit Configurations… -> Search on the left for Tomcat Server and select Local
   • Click on Run -> Edit Configurations… Click on the + sign
   • On server card in input VM Options and write: -Djava.net.preferIPv4Stack=true
   • Select Tomcat Server Local -> Go to Deployment tab
   • Click on the + sign, select artifact you want to add to the server.
3. Try running application, you should see web page. In next step you must config database.

Add database and config connection

1. Create specific user for via MySQL console.

   CREATE USER 'jmtrain_user'@'localhost' IDENTIFIED BY 'jmtrain_pass';

2. Configure credentials for created user.

   GRANT ALL PRIVILEGES ON * . * TO 'jmtrain_user'@'localhost';

3. Quit with console and log in again (password: jmtrain_pass):

   mysql -u jmtrain_user -p

4. Create database and use it.

   CREATE DATABASE JMTrainDB CHARACTER SET utf8mb4 COLLATE utf8mb4_polish_ci;
   USE JMTrainDB;

5. Create tables use SQL file CREATE.SQL.

6. Insert sample use SQL file INSERT.SQL.

   • passwords are encrypted MD5 Hash Generator
     When you are want log in check user id and password in users_passwords file.
   • all profiles are default active

7. Add profile and active it used gmail account:

   • mail: mailbox.jmtrain@gmail.com
   • password: Pangeon66#

See more by reviewing the class code:

• EmailSender

• TokenProvider

• Less secure apps & your Google Account Google on May 2022 update security policy

  • Solution on Stack Overflow -> here

Database structure

Author

• Kamil Cecherz as pangeon

License