API tools faq
paste
Advertisement
Guest User

MySQLiteHelper

a guest
Oct 30th, 2015
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.25 KB | None | 0 0
raw download clone embed print report
  1. package db_pkg;
  2.  
  3. import java.io.UTFDataFormatException;
  4.  
  5. import android.content.ContentValues;
  6. import android.content.Context;
  7. import android.database.Cursor;
  8. import android.database.sqlite.SQLiteDatabase;
  9. import android.database.sqlite.SQLiteDatabase.CursorFactory;
  10. import android.database.sqlite.SQLiteOpenHelper;
  11. import android.provider.BaseColumns;
  12. import android.util.Log;
  13.  
  14. public class MySQLiteHelper
  15. {
  16. public static final String DB_NAME = "mu_dbname";
  17. public static final String TASKS_TABLE = "passwords";
  18. public static final int DB_VER = 1;
  19.  
  20. public static final String TASK_ID = "_id";
  21. public static final String TASK_WEB = "web";
  22. public static final String TASK_USER = "user";
  23. public static final String TASK_PASSWORD = "password";
  24. // public static final String TASK_LAT = "lat";
  25. // public static final String TASK_LNG = "lng";
  26. private static final String SCRIPT_CREATE_DB = "create table "
  27. + TASKS_TABLE + "(" + BaseColumns._ID
  28. + " integer primary key autoincrement, " + TASK_WEB
  29. + " text not null, " + TASK_USER + " text not null, "
  30. + TASK_PASSWORD + " text not null" + ");";
  31.  
  32. private Context context;
  33. private MyDBHelper myDBHelper;
  34.  
  35. public MySQLiteHelper(Context context)
  36. {
  37. this.context = context;
  38. this.myDBHelper = new MyDBHelper(this.context);
  39.  
  40. }
  41.  
  42. public void addTaskItem(addPassword item)
  43. {
  44. SQLiteDatabase database = myDBHelper.getWritableDatabase();
  45. ContentValues values = new ContentValues();
  46. values.put(TASK_WEB, item.getWebsite());
  47. values.put(TASK_USER, item.getUsername());
  48. values.put(TASK_PASSWORD, item.getPassword());
  49. database.insert(TASKS_TABLE, null, values);
  50. database.close();
  51. }
  52.  
  53. public boolean updateItemById(int taskID, addPassword item)
  54. {
  55. SQLiteDatabase database = myDBHelper.getWritableDatabase();
  56. ContentValues values = new ContentValues();
  57. values.put(TASK_WEB, item.getWebsite());
  58. values.put(TASK_USER, item.getUsername());
  59. values.put(TASK_PASSWORD, item.getPassword());
  60. boolean b = database.update(TASKS_TABLE, values,
  61. TASK_ID + "=" + taskID, null) > 0;
  62. database.close();
  63. return b;
  64.  
  65. }
  66.  
  67. public boolean deleteTaskItemById(int taskID)
  68. {
  69. SQLiteDatabase database = myDBHelper.getWritableDatabase();
  70. boolean b = database.delete(TASKS_TABLE, TASK_ID + "=" + taskID, null) > 0;
  71. return b;
  72. }
  73.  
  74. public Cursor getCursorALL()
  75. {
  76. Cursor cursor;
  77. SQLiteDatabase database = myDBHelper.getReadableDatabase();
  78. cursor = database.query(TASKS_TABLE,
  79. new String[] { TASK_ID,TASK_WEB,TASK_USER,TASK_PASSWORD},
  80. null,null, null, null, null);
  81. return cursor;
  82. }
  83. //testing Debugging
  84. public void printAllCursorDB()
  85. {
  86. Cursor cursor=getCursorALL();
  87.  
  88. cursor.moveToFirst();
  89. while(!cursor.isAfterLast())
  90. {
  91. StringBuffer st=new StringBuffer();
  92. st.append("ID:"+cursor.getString(0));
  93. st.append(" Text:"+cursor.getString(1));
  94. st.append(" Phone:"+cursor.getString(2));
  95. st.append(" Priority:"+cursor.getString(3));
  96. Log.d("MyTasksDBMngr", st.toString());
  97.  
  98. cursor.moveToNext();
  99.  
  100. }
  101. cursor.close();
  102. }
  103.  
  104. private class MyDBHelper extends SQLiteOpenHelper
  105. {
  106.  
  107. public MyDBHelper(Context context)
  108. {
  109. super(context, DB_NAME, null, DB_VER);
  110. Log.i("MyDBHelper", "Constructor");
  111. }
  112.  
  113. @Override
  114. public void onCreate(SQLiteDatabase db)
  115. {
  116. String sqlst = String.format("drop table if exists %s;",
  117. TASKS_TABLE);// משפט למחיקת הטבלה
  118. db.execSQL(sqlst);
  119. db.execSQL(SCRIPT_CREATE_DB);
  120. Log.i("MyDBHelper", "onCreate");
  121.  
  122. }
  123.  
  124. @Override
  125. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  126. {
  127. onCreate(db);
  128.  
  129. }
  130.  
  131. }
  132.  
  133. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!