3. Preparing the database

For the connection to the database use either the mysql cli terminal or the Adminer container on http://localhost:8080

Connection using Adminer container

User root (default password R00tPa33w0rd!)

User testuser (default password T3stUs3r!)

SQL lines for root

SET NAMES utf8;

CREATE USER `testuser` IDENTIFIED BY 'T3stUs3r!';
CREATE DATABASE `testdb`;
GRANT ALL PRIVILEGES ON `testdb`.* TO `testuser`@`%`;

SQL lines for testuser

SET NAMES utf8;

USE `testdb`;

DROP TABLE IF EXISTS `people`;
CREATE TABLE `people` (
  `name` VARCHAR(40) NOT NULL,
  `surname` VARCHAR(60) NOT NULL,
  `age` TINYINT UNSIGNED NOT NULL,
  `created` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `updated` DATETIME ON UPDATE CURRENT_TIMESTAMP,
  `remark` VARCHAR(80),
  `id` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
);

INSERT INTO `people` (`name`, `surname`, `age`) VALUES ('Robin', 'Shark', 35);
INSERT INTO `people` (`name`, `surname`, `age`) VALUES ('Linda', 'Morwin', 28);
INSERT INTO `people` (`name`, `surname`, `age`) VALUES ('Patrick', 'Woody', 51);
INSERT INTO `people` (`name`, `surname`, `age`) VALUES ('Aneta', 'White', 17);
INSERT INTO `people` (`name`, `surname`, `age`) VALUES ('Roger', 'Hover', 29);

DROP FUNCTION IF EXISTS `factorial`;
DELIMITER $$
CREATE FUNCTION `factorial`(`n` INT) RETURNS INT DETERMINISTIC
BEGIN
  DECLARE `result` INT DEFAULT 1;
  DECLARE `ijk` INT DEFAULT 2;
  IF `n` < 0 THEN
    RETURN -1;
  END IF;
  IF `n` < 2 THEN
    RETURN `result`;
  END IF;
  WHILE `ijk` <= `n` DO
    SET `result` = `result` * `ijk`;
    SET `ijk` = `ijk` + 1;
  END WHILE;
  RETURN `result`;
END$$
DELIMITER ;

DROP PROCEDURE IF EXISTS `add_and_subtract`;
DELIMITER $$
CREATE PROCEDURE `add_and_subtract`(`a` INT, `b` INT, OUT `x` INT, OUT `y` INT)
BEGIN
  SET `x` = `a` + `b`;
  SET `y` = `a` - `b`;
END$$
DELIMITER ;

optional SQL check lines for testuser

SET NAMES utf8;

USE `testdb`;

SELECT * FROM `people`;

SELECT count(*) FROM `people`;
SELECT count(*) FROM `people` WHERE `id`!=1;

SELECT `factorial`(2);
SELECT `factorial`(3);
SELECT `factorial`(4);

CALL `add_and_subtract`(12, 5, @env_var_x, @env_var_y);
SELECT @env_var_x, @env_var_y;

4. The Java client source code

• install Java JDK on your computer
• set the OS environment %JAVA_HOME% variable (must exist "%JAVA_HOME%\bin\java.exe")

4.1. Apache Maven

• install Apache Maven on your computer
• add the Maven directory (where the batch mvn.cmd locates) to the OS environment %PATH% variable

The subdirectory java-maven contains prepared Windows batches:

• 01-build.cmd - cleans, compiles and builds the Maven project
• 02-run.cmd - runs the built Java archive (JAR)
• 03-clean.cmd - cleans the Maven project

4.2. Gradle Build Tool

• install Gradle Build Tool on your computer
• add the Gradle directory (where the batch gradle.bat locates) to the OS environment %PATH% variable

The subdirectory java-gradle contains prepared Windows batches:

• 01-build.cmd - cleans, compiles and builds the Gradle project
• 02-run.cmd - runs the built Java archive (JAR)
• 03-clean.cmd - cleans the Gradle project

5. The .NET C# client source code

• use the csc.exe .NET C# compiler that is the part of Microsoft .NET Framework (part of OS)
• install MySQL Connector/NET on your computer
• check the right MySql.Data.dll from MySQL Connector/NET in the csharp\bin directory

The subdirectory csharp contains prepared Windows batches:

• 01-compile.cmd - compiles the source code (contains the path definition to the csc.exe compiler)
• 02-run.cmd - runs the Windows executable
• 03-clean.cmd - deletes the Windows executable

6. The PHP client source code

• install PHP on your computer
• set the OS environment %PHP_HOME% variable (must exist "%PHP_HOME%\php.exe")

To the php.ini in the PHP directory %PHP_HOME% add lines

[PHP]
extension_dir = "ext"
extension=pdo_mysql

[Date]
date.timezone = Europe/Prague

The subdirectory php contains prepared Windows batch:

• 01-run.cmd - runs the code through the PHP interpreter

Versions

Now in August 2020 I have the computer with Windows 10 Pro 64bit, 12GB RAM and available 50GB free HDD space

To do (my plans to the future)