13. JDBC

Main steps

• Set up database
• Implement activity
• Extra exercise
• Error solution
• Extra exercises
• Additional info
  • In English
  • In Latvian

Set up database

1. If necessary, change values of user, password and database variables in TeacherManager.java class and  key values of src/resources/appplication.properties configuration file

2. Create new database user, by executing following commands in terminal (each line one by one!):

   $xcontext.get("mysqllogin")
   CREATE USER 'uXX'@'localhost' IDENTIFIED BY 'uXX';
   FLUSH PRIVILEGES;
   exit

   where XX is your given number.

3. Create structure of the database, by executing following commands in terminal:

   cd ~/workspace/JTM/src/main/java/jtm/activity13/
   $xcontext.get("mysqllogin")
   create database databaseXX;
   GRANT ALL ON databaseXX.* TO 'uXX'@'localhost';
   FLUSH PRIVILEGES;
   exit
   mysql -uuXX -puXX databaseXX < database.sql

   where XX is your given number.

Implement activity

1. Investigate jtm.activity13 package
2. Implement class TeacherManager to pass unit tests

Extra exercise

• Extra exercise 7: JPA

Error solution

1. To check that server is running:

   ss -ntlp|grep 3306

   should return:

   LISTEN    0         151              127.0.0.1:3306             0.0.0.0:*
   LISTEN    0         70               127.0.0.1:33060            0.0.0.0:*

2. Check, that you can log into server, run MySQL console:

   mysql -uuXX -puXX

   Then, inside MySQL console:

   show databases;

   should return list of databases.

   exit

Extra exercises

• Extra 8. JPA

Additional info

In English

• DBeaver tool
• JDBC tutorial (PDF file)

In Latvian

• MySQL datubāze
• Datu bāzu tehnoloģijas