13. JDBC

General steps

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

Review topic

1. Review presentation JDBC

   Practical exercise

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!):

   mysql -ustudent -pStudent007
   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/
   mysql -ustudent -pStudent007
   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
• TCP/IP pamati
• Detalizēti par SQL
• Datu bāzu tehnoloģijas