Changeset 501396e for src/main/java/com/example/cookbook/repository/SlikiZaReceptRepository.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/SlikiZaReceptRepository.java (modified) (1 diff)

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

@@ -1 @@
-package com.example.cookbook.repository;public class SlikiZaReceptRepository {
+package com.example.cookbook.repository;
+
+import com.example.cookbook.dbConfig.DB;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Slika;
+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 SlikiZaReceptRepository {
+
+    public List<Slika> findAllForRecipe(Long recId) throws SQLException {
+        Connection connection = DB.getConnection();
+
+        String query = "select * from sliki s where s.rec_id = ? order by s.reden_broj asc";
+        PreparedStatement prepStm = connection.prepareStatement(query);
+        prepStm.setLong(1, recId);
+
+        ResultSet result = prepStm.executeQuery();
+        List<Slika> sliki = new ArrayList<>();
+
+        while (result.next()){
+            Slika slika = new Slika();
+            slika.setRecId(result.getLong("rec_id"));
+            slika.setRedenBroj(result.getInt("reden_broj"));
+            slika.setPic(new String(result.getBytes("slika"), StandardCharsets.UTF_8));
+            sliki.add(slika);
+        }
+
+        result.close();
+        prepStm.close();
+        DB.closeConnection();
+
+        return sliki;
+    }
 }