01

SUBMITTED BY: Guest

DATE: Nov. 10, 2013, 4:07 p.m.

FORMAT: Text only

SIZE: 5.6 kB

Raw Download

HITS: 4212

Report
  3. public void onCreate(SQLiteDatabase db) {
  4. String CREATE_Order_Inner_TABLE = "CREATE TABLE " + TABLE_Order_Inner_Table + "("
  5. + Order_id + " AUTO_INCREMENT,"
  6. + Order_Date + " TEXT,"
  7. + Order_Time + " TEXT,"
  8. + Order_Total_Price + " TEXT"
  9. + ")";
  13. db.execSQL(CREATE_Order_Inner_TABLE);
  14. }
  17. // Creating Tables
  18. public void onCreate_previous_order(SQLiteDatabase db) {
  20. }
  22. // Upgrading database
  23. @Override
  24. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  25. // Drop older table if existed
  26. db.execSQL("DROP TABLE IF EXISTS " + TABLE_Order_Inner_Table);
  28. // Create tables again
  29. onCreate(db);
  30. }
  32. /**
  33. * Storing user details in database
  34. * */
  35. public int addInnerOrder(String Date, String time, String totalprice) {
  36. SQLiteDatabase db = this.getWritableDatabase();
  38. ContentValues values = new ContentValues();
  40. values.put(Order_Date, Date); // Name
  41. values.put(Order_Time, time); // Email
  42. values.put(Order_Total_Price,totalprice ); // Email
  45. // Inserting Row
  46. int id = (int) db.insert(TABLE_Order_Inner_Table, null, values);
  48. db.close(); // Closing database connection
  49. return id;
  50. }
  53. /**
  54. * Getting user data from database
  55. * */
  56. public ArrayList<HashMap<String, Object>> getHistroyDetails(){
  57. HashMap<String,String> user = new HashMap<String,String>();
  58. String selectQuery = "SELECT * FROM " + TABLE_Order_Inner_Table;
  60. SQLiteDatabase db = this.getReadableDatabase();
  61. Cursor cursor = db.rawQuery(selectQuery, null);
  62. // Move to first row
  63. cursor.moveToFirst();
  64. // if(cursor.getCount() > 0){
  65. while(!cursor.isAfterLast())
  66. {
  67. HashMap<String, Object> map = new HashMap<String, Object>();
  68. DataHolderHistroy obj=new DataHolderHistroy();
  69. android.util.Log.i("cursor.getInt(cursor.getColumnIndex(Order_id))"," "+ cursor.getInt(cursor.getColumnIndex(Order_id)));
  70. obj.setData(cursor.getInt(cursor.getColumnIndex(Order_id)),cursor.getString(cursor.getColumnIndex(Order_Date)),cursor.getString(cursor.getColumnIndex(Order_Total_Price)),cursor.getString(cursor.getColumnIndex(Order_Time)));
  72. android.util.Log.i("cursor.getInt(22222222222"," "+ cursor.getString(cursor.getColumnIndex(Order_id)));
  73. android.util.Log.i("cursor.gets(getStringgetString", cursor.getString(cursor.getColumnIndex(Order_Date)));
  75. map.put(ITEMTITLEOrder, obj);
  76. // adding HashList to ArrayList
  77. OrdersList.add(map);
  80. cursor.moveToNext();
  83. // }
  86. }
  87. cursor.close();
  88. db.close();
  89. // return user
  90. return OrdersList;
  91. }
  98. public class DataHolderHistroy
  100. {
  101. int Id;
  102. String Date;
  103. String totalPrice;
  104. String time;
  106. public void setData(int id,String date,String totalprice, String time)
  107. {
  108. this.Id=id;
  109. this.Date=date;
  110. this.totalPrice=totalprice;
  111. this.time=time;
  112. }
  114. public int Get_id()
  115. {return Id;}
  116. public String GetDate()
  117. {return Date;}
  118. public String Getprice()
  119. {return totalPrice;}
  120. public String Gettime()
  121. {return time;}
  124. }
  129. }
  131. 10-01 17:03:49.820: I/cursor.getInt(cursor.getColumnIndex(Order_id))(23142): 0
  132. 10-01 17:03:49.820: I/cursor.getInt(22222222222(23142): null
  133. 10-01 17:03:49.820: I/cursor.gets(getStringgetString(23142): 01-Oct-2013
  135. DataHolderHistroy obj=new DataHolderHistroy();
  136. android.util.Log.i("cursor.getInt(cursor.getColumnIndex(Order_id))"," "+ cursor.getInt(cursor.getColumnIndex(Order_id)));
  137. obj.setData(cursor.getInt(cursor.getColumnIndex(Order_id)),
  139. cursor.getString(cursor.getColumnIndex(Order_Date)),cursor.getString(cursor.getColumnIndex(Order_Total_Price)),cursor.getString(cursor.getColumnIndex(Order_Time)));
  141. android.util.Log.i
  143. ("cursor.getInt(22222222222"," "+ cursor.getString(cursor.getColumnIndex(Order_id)));
  144. android.util.Log.i("cursor.gets(getStringgetString", cursor.getString(cursor.getColumnIndex(Order_Date)));
  146. android.util.Log.i("cursor.getInt(22222222222"," "+ cursor.getInt(cursor.getColumnIndex(Order_id)));
comments powered by Disqus