Changeset d4d8fb9 for src/main/java/com/example/cookbook/repository/KomentariRepository.java

Timestamp:

02/03/24 18:08:44 (9 months ago)

Author:

Blazho <aleksandar.blazhevski@…>

Branches:

master

Children:

cab1b7d

Parents:

aea04dd

Message:

Posetitelot komentira i dava ocena za recept(https://develop.finki.ukim.mk/projects/cbdb/wiki/useCase11)

File:

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

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

@@ -6 +6 @@
 import org.springframework.stereotype.Repository;
 
-import java.sql.Connection;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.SQLException;
+import java.sql.*;
 import java.time.LocalDateTime;
 import java.util.ArrayList;
@@ -48 +45 @@
         return komentari;
     }
+
+    public void save(Komentar komentar) throws SQLException {
+        Connection connection = DB.getConnection();
+
+        String query = "insert into komentari (kom_data, telefon, rec_id, ocena, text) values \n" +
+                "        (?, ?, ?, ?, ?);";
+
+        PreparedStatement prepStm = connection.prepareStatement(query);
+        prepStm.setObject(1, komentar.getKomData());
+        prepStm.setString(2, komentar.getTelefon());
+        prepStm.setLong(3, komentar.getRecId());
+        prepStm.setInt(4, komentar.getOcena());
+        prepStm.setString(5, komentar.getText());
+
+        prepStm.executeUpdate();
+
+        prepStm.close();
+        DB.closeConnection();
+    }
 }