Merge branch 'master' of https://github.com/cs0320-2021/term-project-cohwille-jmccaul3-mfoiani-rhunt2master

1 files changed, 3 insertions, 3 deletions

diff --git a/src/main/java/edu/brown/cs/student/term/DatabaseQuerier.java b/src/main/java/edu/brown/cs/student/term/DatabaseQuerier.java
index 53c8cdc..2a9af65 100644
--- a/src/main/java/edu/brown/cs/student/term/DatabaseQuerier.java
+++ b/src/main/java/edu/brown/cs/student/term/DatabaseQuerier.java
@@ -125,16 +125,16 @@ public class DatabaseQuerier {
     return trades;
   }
 
-  public List<Trade> getAllTradesByHolder(String person, Date startDate, Date endDate) {
+  public List<Trade> getAllTradesByHolder(Integer holder_id, Date startDate, Date endDate) {
     LinkedList<Trade> trades = new LinkedList<>();
 
     try {
       PreparedStatement prep;
       prep =
-          conn.prepareStatement("SELECT * FROM \'trades\' WHERE holder_name= ? "
+          conn.prepareStatement("SELECT * FROM \'trades\' WHERE holder_id = ?"
               + " AND trade_timestamp BETWEEN ? AND ?"
               + "order by trade_timestamp asc;");
-      prep.setString(1, person);
+      prep.setInt(1, holder_id);
       prep.setDate(2, startDate);
       prep.setDate(3, endDate);
       ResultSet rs = prep.executeQuery();