Changeset ee27685 for src/main/java/com/example/cookbook/repository/NarackiRepository.java

Timestamp:

02/04/24 17:12:57 (9 months ago)

Author:

Blazho <aleksandar.blazhevski@…>

Branches:

master

Children:

a226bc3

Parents:

cab1b7d

Message:

Added order items page

File:

• src/main/java/com/example/cookbook/repository/NarackiRepository.java (modified) (2 diffs)

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

@@ -4 +4 @@
 import com.example.cookbook.dbConfig.DB;
 import com.example.cookbook.model.Naracka;
+import com.example.cookbook.model.Recept;
+import com.example.cookbook.model.Stavka;
 import org.springframework.stereotype.Repository;
 
-import java.sql.Connection;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.sql.Statement;
+import java.sql.*;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
@@ -39 +38 @@
         return naracki;
     }
+
+    public List<Stavka> findByTelAndVreme(String telefon, LocalDateTime vreme) throws SQLException {
+
+        Connection connection = DB.getConnection();
+        String query = "select sk.vreme, sk.telefon, r.rec_ime, nacin from so_koi sk\n" +
+                "        left join recepti r on r.rec_id = sk.rec_id\n" +
+                "where vreme = ? and telefon = ?;";
+        PreparedStatement prepStm = connection.prepareStatement(query);
+
+        prepStm.setObject(1, vreme);
+        prepStm.setString(2, telefon);
+
+        ResultSet result = prepStm.executeQuery();
+        List<Stavka> stavki = new ArrayList<>();
+        while (result.next()){
+            Stavka stavka = new Stavka();
+            stavka.setRecIme(result.getString("rec_ime"));
+            stavka.setTelefon(result.getString("telefon"));
+            stavka.setNacin(result.getString("nacin"));
+            stavka.setVreme(result.getObject("vreme", LocalDateTime.class));
+            stavki.add(stavka);
+        }
+        DB.closeConnection();
+        result.close();
+        prepStm.close();
+        return stavki;
+    }
 }