STUDY OF JAVA SERVER

DB

CREATION OF THE DB WITH COMMAND LINE

Commands used:

\sql # Executes SQL statement or switches to SQL processing mode when no statement is given.
\connect root@localhost:3306 # Connecting with db 

CREATE DATABASE IF NOT EXISTS nations;
show databases;
use nations;
\source C:\your_path\nation_tables.sql
show tables;

nation_tables.sql

CREATE TABLE nation ( 
    iso_code VARCHAR(3) NOT NULL,
    name VARCHAR(50) NOT NULL,
    capital VARCHAR(50) NOT NULL,
    population INT,
    PRIMARY KEY (iso_code)
);

CREATE TABLE continent (
    id INT AUTO_INCREMENT NOT NULL,
    name VARCHAR(50) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE products (
    id INT AUTO_INCREMENT NOT NULL,
    country_id VARCHAR(3) NOT NULL,
    name VARCHAR(50) NOT NULL,
    PRIMARY KEY (id),
    FOREIGN KEY (country_id) REFERENCES nation(iso_code)
);

populating_database.sql

INSERT INTO nation (iso_code, name, capital, population) VALUES ("ITA","Italy","Rome", 60360000);
INSERT INTO continent (name) VALUES ("Europe");
INSERT INTO products (country_id, name) VALUES ("ITA","Pizza");

Spring boot

-Create a project following screenshots saved in /spring boot project

-add in src/main/resources/application.properties file

spring.datasource.url=jdbc:mysql://localhost:3306/nations
spring.datasource.username=root
spring.datasource.password=yourpassword

Spring MVC eclipse 2021

• Be sure to have eclipse (useful for example to be able to see tomcat servers in servers section)
• It's more easy install tomcat server directly from eclipse indicating a directory where download the server files.
• to resolve 404 problem try to go to stackoverflow question n 11227395, where explains to add "Maven dependency" in the deployment assembly
• If is not present run on server option transform the project going on properties / project facets and add option dynamic web module.

tutorial links

mvc hello world done following this video tutorial in italian https://www.youtube.com/watch?v=JZXFDHmGopA&t=468s and this tutorial https://crunchify.com/simplest-spring-mvc-hello-world-example-tutorial-spring-model-view-controller-tips/