Advertisement
kusha45

Sqlitedatabase

Jan 2nd, 2012
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. //Create Query :
  2.  
  3. private static final String CREATE_SIMPLENOTE = "create table calSimpleNote (_id integer PRIMERY KEY, Cal_Id TEXT , User_ID INTEGER , Cal_Date TEXT , Note TEXT,Involvers TEXT, "+
  4. "DeleteReason TEXT ,Create_Date TEXT ,Changed_date TEXT,EmailInvolvers TEXT,"+
  5. "RemindSameDay INTEGER, RemindAllDay INTEGER,RemindBeforeDays INTEGER );";
  6.  
  7. @Override
  8. public void onCreate(SQLiteDatabase db)
  9. {
  10. db.execSQL(CREATE_SIMPLENOTE);
  11. }
  12. //Insert Query
  13.  
  14. public long insertCalSimpleNote(String noteId,int userId,String cal_date,String note,String Involved,String DeleteReason,String Create_Date,
  15. String Changed_date,String emailInvolvers,int remindSameday,int remindAllday,int remindBeforeday){
  16.  
  17. ContentValues initialValues = new ContentValues();
  18.  
  19. initialValues.put("Cal_Id", noteId);
  20. initialValues.put("User_ID", userId);
  21. initialValues.put("Cal_Date", cal_date);
  22. initialValues.put("Note", note);
  23. initialValues.put("Involvers", Involved);
  24. initialValues.put("DeleteReason", DeleteReason);
  25. initialValues.put("Create_Date", Create_Date);
  26. initialValues.put("Changed_date", Changed_date);
  27. initialValues.put("EmailInvolvers", emailInvolvers);
  28. initialValues.put("RemindSameDay", remindSameday);
  29. initialValues.put("RemindAllDay", remindAllday);
  30. initialValues.put("RemindBeforeDays", remindBeforeday);
  31.  
  32. return db.insert("calSimpleNote", null, initialValues);
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement