PMb0zuKt

1package com.examlemenu.acer.sigsekolahku;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8
9import java.util.ArrayList;
10
11public class Database extends SQLiteOpenHelper {
12    private static final int DATABASE_VERSION = 1;
13    private static final String DATABASE_NAME = "sigsekolah";
14    private SQLiteDatabase DB;
15    public Database (Context context){
16        super(context, DATABASE_NAME, null, DATABASE_VERSION);
17    }
18
19    @Override
20    public void onCreate(SQLiteDatabase db) {creaTabel (db);}
21
22    @Override
23    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}
24    public void openWriteble(){this.DB = getWritableDatabase();}
25    public void openReadtable(){this.DB = getReadableDatabase();}
26    public void close(){this.DB.close();}
27
28    public void creaTabel(SQLiteDatabase db){
29        String sekolahsma = "CREATE TABLE IF NOT EXISTS sma (id INTEGER PRIMARY KEY, nisn TEXT, nama TEXT, akreditasi TEXT, alamat TEXT, keterangan TEXT)";
30        db.execSQL(sekolahsma);
31    }
32
33    public long insertsma(int id, String nisn, String nama, String akreditasi, String alamat, String keterangan){
34        ContentValues values = new ContentValues();
35        values.put("id", id);
36        values.put("nisn", nisn);
37        values.put("nama", nama);
38        values.put("akreditasi", akreditasi);
39        values.put("alamat", alamat);
40        values.put("keterangan", keterangan);
41        return DB.insert("sma", null, values);
42    }
43
44    public int updatesma(int id, String nisn, String nama, String akreditasi, String alamat, String keterangan) {
45        ContentValues values = new ContentValues();
46        values.put("id", id);
47        values.put("nisn", nisn);
48        values.put("nama", nama);
49        values.put("akreditasi", akreditasi);
50        values.put("alamat", alamat);
51        values.put("keterangan", keterangan);
52        return DB.update("sma", values, "id = " + id, null);
53    }
54
55
56    public int deletesma(int id){return DB.delete("sma", "id = " + id, null);}
57
58
59    public ArrayList<String> getsmalist(){
60        SQLiteDatabase db = this.getWritableDatabase();
61        Cursor cursor = db.rawQuery("SELECT * from sma", null);
62        ArrayList<String> List = new ArrayList<>();
63        cursor.moveToFirst();
64        for (int i = 0; i < cursor.getCount(); i++){
65            List.add(cursor.getString(cursor.getColumnIndex("nama")));
66            cursor.moveToNext();
67        }
68        return List;
69    }
70}