c5TD25Za

1package com.adi.aplikasisqlite.helper;
2
3import android.content.Context;
4import android.database.Cursor;
5import android.database.sqlite.SQLiteDatabase;
6import android.database.sqlite.SQLiteOpenHelper;
7import android.util.Log;
8
9import java.util.ArrayList;
10import java.util.HashMap;
11
12public class DbHelper extends SQLiteOpenHelper {
13    private static final int DATABASE_VERSION = 2;
14
15    static final String DATABASE_NAME = "digitaltalent.db";
16    public static final String TABLE_SQLite = "sqlite";
17
18    public static final String COLUMN_ID = "id";
19    public static final String COLUMN_NAME = "name";
20    public static final String COLUMN_ADDRESS = "address";
21
22    public DbHelper(Context context){
23        super(context, DATABASE_NAME, null, DATABASE_VERSION);
24
25    }
26    @Override
27    public void onCreate(SQLiteDatabase db){
28        final String SQL_CREATE_MOVIE_TABLE = "CREATE TABLE " +TABLE_SQLite + " (" +
29                COLUMN_ID + " INTEGER PRIMARY KEY autoincrement, " +
30                COLUMN_NAME + " TEXT NOT NULL, " +
31                COLUMN_ADDRESS + " TEXT NOT NULL" +
32                " )";
33        db.execSQL(SQL_CREATE_MOVIE_TABLE);
34    }
35    @Override
36    public  void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
37        db.execSQL("DROP TABLE IF EXISTS " + TABLE_SQLite);
38        onCreate(db);
39    }
40    public ArrayList<HashMap<String, String>> getAllData(){
41        ArrayList<HashMap<String, String>> wordList;
42        wordList=new ArrayList<HashMap<String, String>>();
43        String selectQuery="SELECT * FROM " +TABLE_SQLite;
44        SQLiteDatabase database=this.getWritableDatabase();
45        Cursor cursor=database.rawQuery(selectQuery, null);
46        if (cursor.moveToFirst()){
47            do {
48                HashMap<String, String> map=new HashMap<String, String>();
49                map.put(COLUMN_ID, cursor.getString(0));
50                map.put(COLUMN_NAME, cursor.getString(1));
51                map.put(COLUMN_ADDRESS, cursor.getString(2));
52                wordList.add(map);
53            }while (cursor.moveToNext());
54        }
55        Log.e("select sqlite", "" + wordList);
56
57        database.close();
58        return  wordList;
59    }
60    public void insert(String name, String address){
61        SQLiteDatabase database=this.getWritableDatabase();
62        String queryValues = "INSERT INTO " + TABLE_SQLite + " (name, address) " +
63                "VALUES (' " + name + "', '" + address + "')";
64        Log.e("insert sqlite ","" + queryValues);
65        database.execSQL(queryValues);
66        database.close();
67    }
68    public void update(int id, String name, String address){
69        SQLiteDatabase database=this.getWritableDatabase();
70        String updateQuery= "UPDATE " + TABLE_SQLite + " SET "
71                + COLUMN_NAME + "='" + name + "', "
72                + COLUMN_ADDRESS +"='" + address + "'"
73                + " WHERE " + COLUMN_ID + "=" + "'" + id + "'";
74        Log.e("update sqlite ", updateQuery);
75        database.execSQL(updateQuery);
76        database.close();
77    }
78    public void delete(int id){
79        SQLiteDatabase database=this.getWritableDatabase();
80
81        String updateQuery= "DELETE FROM " + TABLE_SQLite + " WHERE " + COLUMN_ID + "=" + "'" + id + "'";
82        Log.e("update sqlite ", updateQuery);
83        database.execSQL(updateQuery);
84        database.close();
85    }
86}