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.