install docker
docker pull postgres
docker run --name Practic-JDBC -e POSTGRES_PASSWORD=password -d -p 5432:5432 postgres
Welcome to DB application
Please select your option
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
1
Connection is succesfull!
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
2
Data:
User #1, Name: Petr, Surname: Petrovi4, salary: 1
User #2, Name: Ghenadii, Surname: Bukin, salary: 100
User #5, Name: Ghenadii, Surname: Bukin, salary: 100
User #6, Name: Ghenadii, Surname: Bukin, salary: 100
User #7, Name: Ghenadii, Surname: Bukin, salary: 100
User #8, Name: Ghenadii, Surname: Bukin, salary: 100
User #9, Name: Ghenadii, Surname: Bukin, salary: 100
User #10, Name: sdds, Surname: sdds, salary: 12
User #11, Name: Ghenadii, Surname: Bukin, salary: 100
User #12, Name: Ghenadii, Surname: Bukin, salary: 100
User #13, Name: Ghenadii, Surname: Bukin, salary: 100
User #14, Name: Ghenadii, Surname: Bukin, salary: 100
User #15, Name: Ghenadii, Surname: Bukin, salary: 100
User #16, Name: Ghenadii, Surname: Bukin, salary: 100
User #17, Name: Ghenadii, Surname: Bukin, salary: 100
User #18, Name: primo, Surname: elprimo, salary: 12
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
3
Enter your id:
4
User by id 4, not found
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
4
Enter next fields of your new user
Enter your name
sta5on
Enter your surname
sta5on4ik
Enter salary
9999
User is added
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
3
Enter your id:
19
User #19, Name: sta5on, Surname: sta5on4ik, salary: 9999
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
5
Enter next fields of your new user
Enter user id
19
Check your user now:
User #19, Name: sta5on, Surname: sta5on4ik, salary: 9999
If you want to change something, enter new values, and repeat old
Enter user`s name
stas
Enter user`s surname
sta5on
Enter user`s salary
9
User with id 19, is succesfully updated
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
6
Enter user`s id to delete:
19
User 19 is deleted
1 - Check connection to database
2 - Print whole table "Users"
3 - Print field by id
4 - Add new user
5 - Update user by id
6 - Delete user by id
0 - Exit from application
0