Changeset 501396e for src/main/java/com/example/cookbook/repository/SostojkiRespository.java

Timestamp:

02/03/24 15:58:58 (9 months ago)

Author:

Blazho <aleksandar.blazhevski@…>

Branches:

master

Children:

aea04dd

Parents:

3e572eb

Message:

added missing files

File:

• src/main/java/com/example/cookbook/repository/SostojkiRespository.java (modified) (1 diff)

src/main/java/com/example/cookbook/repository/SostojkiRespository.java

@@ -1 @@
-package com.example.cookbook.repository;public class SostojkiRespository {
+package com.example.cookbook.repository;
+
+
+import com.example.cookbook.dbConfig.DB;
+import com.example.cookbook.model.Slika;
+import com.example.cookbook.model.Sostojka;
+import org.springframework.stereotype.Repository;
+
+import java.nio.charset.StandardCharsets;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.List;
+
+@Repository
+public class SostojkiRespository {
+
+
+    public List<Sostojka> findAllByRId(Long rId) throws SQLException {
+        Connection connection = DB.getConnection();
+
+        String query = "select s.s_id, s_naziv\n" +
+                "from sodrzi\n" +
+                "    left join sostojki s on\n" +
+                "        sodrzi.s_id = s.s_id\n" +
+                "where rec_id = ?";
+
+        PreparedStatement prepStm = connection.prepareStatement(query);
+        prepStm.setLong(1, rId);
+
+        ResultSet result = prepStm.executeQuery();
+        List<Sostojka> sostojki = new ArrayList<>();
+
+        while (result.next()){
+            Sostojka sostojka = new Sostojka();
+            sostojka.setsId(result.getLong("s_id"));
+            sostojka.setsNaziv(result.getString("s_naziv"));
+            sostojki.add(sostojka);
+        }
+
+        result.close();
+        prepStm.close();
+        DB.closeConnection();
+
+        return sostojki;
+    }
 }