Index: src/main/java/com/example/cookbook/controller/VrabotenController.java
===================================================================
--- src/main/java/com/example/cookbook/controller/VrabotenController.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/controller/VrabotenController.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -0,0 +1,35 @@
+package com.example.cookbook.controller;
+
+
+import com.example.cookbook.model.Naracka;
+import com.example.cookbook.service.NarackiService;
+import org.springframework.stereotype.Controller;
+import org.springframework.ui.Model;
+import org.springframework.web.bind.annotation.GetMapping;
+
+import java.sql.SQLException;
+import java.util.List;
+
+@Controller
+public class VrabotenController {
+
+    private final NarackiService narcakiService;
+
+    public VrabotenController(NarackiService narcakiService) {
+        this.narcakiService = narcakiService;
+    }
+
+
+    @GetMapping("/naracki")
+    public String getNaracki(Model model){
+
+        List<Naracka> naracki = null;
+        try {
+            naracki = narcakiService.listAll();
+        } catch (SQLException e) {
+            return "redirect:/error-page/SQL%20Exception";
+        }
+        model.addAttribute("naracki", naracki);
+        return "naracki";
+    }
+}
Index: src/main/java/com/example/cookbook/dbConfig/DB.java
===================================================================
--- src/main/java/com/example/cookbook/dbConfig/DB.java	(revision d4d8fb910efb9952fb7c668392de16325221a0e1)
+++ src/main/java/com/example/cookbook/dbConfig/DB.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -15,4 +15,6 @@
 //    private static final String SSH_PASSWORD = "b6cd27a3";
 
+
+    //Remote database parameters
     private static final String DB_URL = "jdbc:postgresql://localhost:9999/db_202324z_va_prj_cbdb";
     private static final String DB_USERNAME = "db_202324z_va_prj_cbdb_owner";
@@ -20,4 +22,5 @@
 
 
+    //Local database parameters
     private static final String LDB_URL = "jdbc:postgresql://localhost:5432/cbdb";
     private static final String LDB_USERNAME = "postgres";
Index: src/main/java/com/example/cookbook/model/Naracka.java
===================================================================
--- src/main/java/com/example/cookbook/model/Naracka.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/model/Naracka.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -0,0 +1,39 @@
+package com.example.cookbook.model;
+
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
+
+public class Naracka {
+
+    private LocalDateTime vreme;
+
+    private String telefon;
+
+    public Naracka() {
+    }
+
+    public LocalDateTime getVreme() {
+        return vreme;
+    }
+
+    public void setVreme(LocalDateTime vreme) {
+        this.vreme = vreme;
+    }
+
+    public String getTelefon() {
+        return telefon;
+    }
+
+    public void setTelefon(String telefon) {
+        this.telefon = telefon;
+    }
+
+    public Naracka(LocalDateTime vreme, String telefon) {
+        this.vreme = vreme;
+        this.telefon = telefon;
+    }
+    public String getDataFormatirana(){
+        return vreme.format(DateTimeFormatter.ofPattern("yyyy-MMM-dd HH:mm"));
+    }
+
+}
Index: src/main/java/com/example/cookbook/repository/NarackiRepository.java
===================================================================
--- src/main/java/com/example/cookbook/repository/NarackiRepository.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/repository/NarackiRepository.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -0,0 +1,41 @@
+package com.example.cookbook.repository;
+
+
+import com.example.cookbook.dbConfig.DB;
+import com.example.cookbook.model.Naracka;
+import org.springframework.stereotype.Repository;
+
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.time.LocalDateTime;
+import java.util.ArrayList;
+import java.util.List;
+
+@Repository
+public class NarackiRepository {
+
+
+    public List<Naracka> findAll() throws SQLException {
+
+        Connection connection = DB.getConnection();
+        Statement stm = connection.createStatement();
+        String query = "select vreme, telefon from naracki;";
+
+        ResultSet result = stm.executeQuery(query);
+        List<Naracka> naracki = new ArrayList<>();
+
+        while (result.next()){
+            Naracka naracka = new Naracka();
+            naracka.setVreme(result.getObject("vreme", LocalDateTime.class));
+            naracka.setTelefon(result.getString("telefon"));
+            naracki.add(naracka);
+        }
+
+        DB.closeConnection();
+        result.close();
+        stm.close();
+        return naracki;
+    }
+}
Index: src/main/java/com/example/cookbook/service/NarackiService.java
===================================================================
--- src/main/java/com/example/cookbook/service/NarackiService.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/service/NarackiService.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -0,0 +1,11 @@
+package com.example.cookbook.service;
+
+import com.example.cookbook.model.Naracka;
+
+import java.sql.SQLException;
+import java.util.List;
+
+public interface NarackiService {
+
+    List<Naracka> listAll() throws SQLException;
+}
Index: src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java
===================================================================
--- src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
+++ src/main/java/com/example/cookbook/service/impl/NarackiServiceImpl.java	(revision cab1b7da3889db5614d47f4ee4b44ac338108290)
@@ -0,0 +1,25 @@
+package com.example.cookbook.service.impl;
+
+
+import com.example.cookbook.model.Naracka;
+import com.example.cookbook.repository.NarackiRepository;
+import com.example.cookbook.service.NarackiService;
+import org.springframework.stereotype.Service;
+
+import java.sql.SQLException;
+import java.util.List;
+
+@Service
+public class NarackiServiceImpl implements NarackiService {
+
+    private final NarackiRepository narackiRepository;
+
+    public NarackiServiceImpl(NarackiRepository narackiRepository) {
+        this.narackiRepository = narackiRepository;
+    }
+
+    @Override
+    public List<Naracka> listAll() throws SQLException {
+        return narackiRepository.findAll();
+    }
+}
