Advertisement
Guest User

Untitled

a guest
Oct 25th, 2014
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. public class Test extends SQLiteOpenHelper {
  2.  
  3. private static final String DATABASE_CREATE = "CREATE TABLE PLS (" +
  4. "id text, " +
  5. "nama text);";
  6.  
  7. public Test(Context context) {
  8. super(context, "ABC.db", null, 1);
  9. // TODO Auto-generated constructor stub
  10. }
  11.  
  12.  
  13. @Override
  14. public void onCreate(SQLiteDatabase db) {
  15. // TODO Auto-generated method stub
  16. db.execSQL(DATABASE_CREATE);
  17. db.execSQL("INSERT INTO PLS VALUES('1', 'dede');");
  18. }
  19.  
  20. @Override
  21. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  22. // TODO Auto-generated method stub
  23. db.execSQL("DROP TABLE IF EXISTS PLS");
  24. onCreate(db);
  25. }
  26.  
  27. public ArrayList<HashMap<String, String>> getUser() {
  28. ArrayList<HashMap<String, String>> wordList;
  29. wordList = new ArrayList<HashMap<String, String>>();
  30. String selectQuery = "SELECT id, nama FROM PLS";
  31. SQLiteDatabase database = this.getWritableDatabase();
  32. Cursor cursor = database.rawQuery(selectQuery, null);
  33. if (cursor.moveToFirst()) {
  34. do {
  35. HashMap<String, String> map = new HashMap<String, String>();
  36. map.put("id", cursor.getString(0));
  37. map.put("nama", cursor.getString(1));
  38. } while (cursor.moveToNext());
  39. }
  40. return wordList;
  41. }
  42.  
  43. public void addUser(String id, String nama) {
  44. SQLiteDatabase database = this.getWritableDatabase();
  45. ContentValues values = new ContentValues();
  46. values.put("id", id);
  47. values.put("nama", nama);
  48. database.insert("PLS", null, values);
  49. database.close();
  50. }
  51. }
  52.  
  53. controller = new Test(this);
  54. user = new ArrayList<HashMap<String,String>>();
  55. controller.addUser("1", "daniel");
  56.  
  57. user = controller.getUser();
  58.  
  59. for(int i=0; i<user.size(); i++){
  60. tempMenu = new HashMap<String, String>();
  61. tempMenu = user.get(i);
  62. i1.setText(tempMenu.get("id"));
  63. i2.setText(tempMenu.get("nama"));
  64. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement