CRUD Example of Spring5 MVC with JdbcTemplate and MariaDB From Scratch

Sometime we waste our time to create a new project from scratch. Just clone this project. Run on your local machine. Smile and happy Coding.

Project Requirements

• Java 9
• Tomcat 9
• Maven 3.5
• Intellij Idea (Editor)

Set up MySQL

mysql -u root -p 
> CREATE USER 'regUsers'@'localhost' IDENTIFIED BY 'Reg5W0rd4PASS';
> GRANT ALL PRIVILEGES ON *.* TO 'regUsers'@'localhost';
> FLUSH PRIVILEGES;
>
> CREATE DATABASE test_db;

This is an example for your help. Its not mandatory to use it. Create database username and password as your own and keep safe.

Now we need to import schema to database.

mysql -u regUsers -p test_db < project/location/Spring5DummyProjJavaConfig/schema/schema-initial.sql

Run

Run with your editor. check 'project/location/Spring5DummyProjJavaConfig/schema/schema-initial.sql' for username and password.

-- THANK YOU