Changeset 6739

Timestamp:

2004-02-05T12:06:56+13:00 (20 years ago)

Author:

cs025

Message:

Added date support.

Location:

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database

Files:

• GS3SQLAction.java (modified) (2 diffs)
• GS3SQLInsert.java (modified) (2 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database/GS3SQLAction.java

@@ -3 +3 @@
 import java.util.List;
 import java.util.ArrayList;
+import java.util.Calendar;
+import java.util.GregorianCalendar;
 
 public class GS3SQLAction
@@ -22 +24 @@
   }
 
-  public void addDate(String field, java.sql.Date date)
-  {
+  public void addDate(String field, java.sql.Timestamp date)
+  { this.values.add(new GS3SQLValue(field, getDateString(date)));
+  }
+
+  public static String getDateString(java.sql.Timestamp date)
+  { StringBuffer reply = new StringBuffer();
+    Calendar calendar = new GregorianCalendar();
+    calendar.setTime(date);
+
+    reply.append(Integer.toString(calendar.get(Calendar.YEAR)));
+    reply.append("-");
+    reply.append(Integer.toString(calendar.get(Calendar.MONTH)+1));
+    reply.append("-");
+    reply.append(Integer.toString(calendar.get(Calendar.DAY_OF_MONTH)));
+    reply.append(" ");
+    reply.append(Integer.toString(calendar.get(Calendar.HOUR_OF_DAY)));
+    reply.append(":");
+    reply.append(Integer.toString(calendar.get(Calendar.MINUTE)));
+    reply.append(":");
+    reply.append(Integer.toString(calendar.get(Calendar.SECOND)));
+
+    return reply.toString();
   }
   

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/database/GS3SQLInsert.java

@@ -30 +30 @@
       reply.append(", ");
     if (value.getType() == null ||
+        value.getType().equals(GS3SQLField.DATETIME_TYPE) ||
         value.getType().equals(GS3SQLField.VARCHAR_TYPE))
     {
@@ -36 +37 @@
         reply.append(value.value);
     if (value.getType() == null ||
+        value.getType().equals(GS3SQLField.DATETIME_TYPE) ||
         value.getType().equals(GS3SQLField.VARCHAR_TYPE))
     {