jars/gss-lib-2.2/sample/SpreadSheet_Usage/src/com/prasanta/sample/WorkSheetSample.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.table.Record;\r
  11 \r
  12 /**\r
  13  * Demonstrates WorkSheet handling Add/Delete\r
  14  * Add/Update/Delete Records into WorkSheet\r
  15  * Retrieve record from WorkSheet\r
  16  * \r
  17  * @author Prasanta Paul\r
  18  *\r
  19  */\r
  20 public class WorkSheetSample {\r
  21         \r
  22         public static void main(String[] args){\r
  23                 \r
  24                 // Enable/Disable Logging\r
  25                 // by default it will be enabled\r
  26                 Log.enableLog();\r
  27                 \r
  28                 // Create SpreadSheet Factory\r
  29                 SpreadSheetFactory spf = SpreadSheetFactory.getInstance(args[0], args[1]);\r
  30                 \r
  31                 // Get All SpreadSheets\r
  32                 //ArrayList<SpreadSheet> spreadSheets = spf.getAllSpreadSheets();\r
  33                 \r
  34                 // Get selected SpreadSheet- whose name contains "Pras"\r
  35                 ArrayList<SpreadSheet> spreadSheets = spf.getSpreadSheet("Pras", false);\r
  36                 \r
  37                 if(spreadSheets == null || spreadSheets.size() == 0){\r
  38                         System.out.println("No SpreadSheet Exists!");\r
  39                         return;\r
  40                 }\r
  41                 \r
  42                 System.out.println("Number of SpreadSheets: "+ spreadSheets.size());\r
  43                 \r
  44                 SpreadSheet sp = spreadSheets.get(0);\r
  45                 \r
  46                 // Add an WorkSheet\r
  47                 //sp.addWorkSheet("testWork1", new String[]{"date", "item", "price"});\r
  48                 //sp.addWorkSheet("tabWork2", new String[]{"date", "item", "price", "person"});\r
  49                 \r
  50                 // Get all WorkSheets\r
  51                 // ArrayList<WorkSheet> wks = sp.getAllWorkSheets();\r
  52                 \r
  53                 // Get selected WorkSheet\r
  54                 ArrayList<WorkSheet> wks = sp.getWorkSheet("test", false);\r
  55                 \r
  56                 if(wks == null || wks.size() == 0){\r
  57                         System.out.println("No WorkSheet exists!!");\r
  58                         return;\r
  59                 }\r
  60                 \r
  61                 System.out.println("Number of WorkSheets: "+ wks.size());\r
  62                 \r
  63                 WorkSheet wk = null;\r
  64                 /*for(int i=0; i<wks.size(); i++){\r
  65                         \r
  66                          * Search for WorkSheet having name "tab_*"\r
  67                          \r
  68                         if(wks.get(i).getTitle().startsWith("tab_")){\r
  69                                 wk = wks.get(i);\r
  70                                 break;\r
  71                         }\r
  72                 }*/\r
  73                 wk = wks.get(0);\r
  74                 \r
  75                 System.out.println("wk="+ wk.getTitle());\r
  76 \r
  77                 HashMap<String, String> rs = new HashMap<String, String>();\r
  78                 rs.put("date", "1st Jan 2011");\r
  79                 rs.put("item", "Item3");\r
  80                 rs.put("price", "250");\r
  81                 wk.addRecord(sp.getKey(), rs);\r
  82                 \r
  83                 /*\r
  84                  * WorkSheet Record Handling\r
  85                  */\r
  86                 // Get Data\r
  87                 ArrayList<Record> records = wk.getRecords(sp.getKey());\r
  88                 \r
  89                 if(records == null || records.size() == 0){\r
  90                         System.out.println("No Record exists!!");\r
  91                         return;\r
  92                 }\r
  93                 \r
  94                 System.out.println("Number of Records: "+ records.size());\r
  95                 \r
  96                 // Display Record\r
  97                 for(int i=0; i<records.size(); i++){\r
  98                         Record r = records.get(i);\r
  99                         HashMap<String, String> data = r.getData();\r
 100                         System.out.println("Data: "+ data);\r
 101                 }\r
 102                 \r
 103                 // Delete Record\r
 104                 //wk.deleteRecord(records.get(0));\r
 105                 \r
 106                 // Update Record\r
 107                 //Record toUpdate = records.get(0);\r
 108                 \r
 109                 //toUpdate.addData("Name", "Update_Name");\r
 110                 //wk.updateRecord(toUpdate);\r
 111         }\r
 112         \r
 113 }\r