Java (IntelliJ IDEA)
May 2022
Assess JDBC and Java Networks skills
Implement a Multi Client–Server application using the TCP protocol
Server replies with the number of albums for that particular artist, until the user types ‘stop'
The SQL query is an inner join executed on the database
For this project, use the ’Music’ database
Import music_create.sql first and then import music_data.sql
\i '/your_path/music_create.sql'
\i '/your_path/music_data.sql'
Once imported the tables, you can list them by performing the
following command in PostgreSQL:
\dt
To kill a port, click stop 'server' in compiler or run fuser -k 8080/tcp (replace 8080 with your port number) in the terminal
Use fuser 8080/tcp to check if the port is running in your computer.