jars/gss-lib-2.2/sample/SpreadSheet_Usage/src/com/prasanta/sample/ConditionalDataRetrieve.java

   1 package com.prasanta.sample;\r
   2 \r
   3 import java.util.ArrayList;\r
   4 import java.util.HashMap;\r
   5 \r
   6 import com.pras.Log;\r
   7 import com.pras.SpreadSheet;\r
   8 import com.pras.SpreadSheetFactory;\r
   9 import com.pras.WorkSheet;\r
  10 import com.pras.conn.HttpConHandler;\r
  11 import com.pras.table.Record;\r
  12 \r
  13 /**\r
  14  * Demonstrates how to handle Data/Records using this Lib. \r
  15  * Conditional Data Retrieval and Record Add/Edit/Delete  \r
  16  * @author Prasanta Paul\r
  17  *\r
  18  */\r
  19 public class ConditionalDataRetrieve {\r
  20 \r
  21         public static void main(String[] args){\r
  22                 String TAG = "ConditionalDataRetrieve";\r
  23                 // Enable/Disable Log\r
  24                 Log.enableLog();\r
  25                 \r
  26                 // Create SpreadSheet Factory instance\r
  27                 SpreadSheetFactory spf = SpreadSheetFactory.getInstance(args[0], args[1]);\r
  28                 \r
  29                 // Get all SpreadSheets\r
  30                 ArrayList<SpreadSheet> spreadSheets = spf.getAllSpreadSheets();\r
  31                 \r
  32                 if(spreadSheets == null && spreadSheets.size() == 0){\r
  33                         Log.p(TAG, "No SpreadSheet Exists");\r
  34                         return;\r
  35                 }\r
  36                 \r
  37                 SpreadSheet s = spreadSheets.get(0);\r
  38                 \r
  39                 System.out.println("SpreadSheet: "+ s.getTitle());\r
  40                 \r
  41                 // Create WorkSheet\r
  42                 s.addWorkSheet("tab_work_sample", new String[]{"Name", "Age", "Exp", "Country"});\r
  43                 \r
  44                 // Get List of All WorkSheets\r
  45                 ArrayList<WorkSheet> wks = s.getAllWorkSheets();\r
  46                 WorkSheet wk = wks.get(0);\r
  47                 \r
  48                 // Add Record\r
  49                 HashMap<String, String> record = new HashMap<String, String>();\r
  50                 \r
  51                 record.put("Name", "Santosh");\r
  52                 record.put("Age", "25");\r
  53                 record.put("Exp", "10");\r
  54                 record.put("Country", "India");\r
  55                 \r
  56                 wk.addRecord(s.getKey(), record);\r
  57                 \r
  58                 // Conditional Data Read\r
  59                 // Read Data from WorkSheet, where Age < 30 and Order by "Name" column \r
  60                 // Please follow- http://code.google.com/apis/spreadsheets/data/3.0/reference.html#RecordParameters\r
  61                 ArrayList<Record> records = wk.getRecords(s.getKey(), false, HttpConHandler.encode("\"Age\"") + "<" + HttpConHandler.encode("30"), "column:Name");\r
  62                 \r
  63                 if(records == null || records.size() == 0){\r
  64                         System.out.println("No matching data");\r
  65                         return;\r
  66                 }\r
  67                 \r
  68                 // Display Record\r
  69                 for(int i=0; i<records.size(); i++){\r
  70                         Record r = records.get(i);\r
  71                         HashMap<String, String> data = r.getData();\r
  72                         System.out.println("Data: "+ data);\r
  73                         \r
  74                         // Delete Record\r
  75                         //wk.deleteRecord(r);\r
  76                 }\r
  77                 \r
  78                 // Delete WorkSheet\r
  79                 s.deleteWorkSheet(wk);\r
  80         }\r
  81 }\r