UAS_DataBaseHelper.java

package com.example.uas_ade;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;


public class DatabaseHelper extends SQLiteOpenHelper {

    //nama database

    public static final String DATABASE_NAME = "ti1.db";

    //nama table

    public static final String TABLE_NAME = "obat";

    //versi database

    private static final int DATABASE_VERSION = 1;

    //table field

    public static final String COL_1 = "id";

    public static final String COL_2 = "kode";

    public static final String COL_3 = "obat";

    public static final String COL_4 = "jenis";

    public static final String COL_5 = "indikasi";

    public static final String COL_6 = "tanggal";

    public static final String COL_7 = "harga";



    public DatabaseHelper(Context context) {

        super(context, DATABASE_NAME, null, DATABASE_VERSION);

        SQLiteDatabase db = this.getWritableDatabase();

    }


    @Override

    public void onCreate(SQLiteDatabase db) {

        db.execSQL("create table obat(id integer primary key autoincrement," +

                "kode text ," +

                "obat text ," +

                "jenis text ," +

                "indikasi text ," +

                "tanggal text ," +

                "harga text );");

    }


    @Override

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);

        onCreate(db);

    }


    //metode untuk tambah data

    public boolean insertData(String kode, String obat, String jenis, String indikasi, String tanggal, String harga) {

        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues contentValues = new ContentValues();

        contentValues.put(COL_2, kode);

        contentValues.put(COL_3, obat);

        contentValues.put(COL_4, jenis);

        contentValues.put(COL_5, indikasi);

        contentValues.put(COL_6, tanggal);

        contentValues.put(COL_7, harga);


        long result = db.insert(TABLE_NAME, null, contentValues);

        if (result == -1)

            return false;

        else

            return true;

    }


    //metode untuk mengambil data

    public Cursor getAllData() {

        SQLiteDatabase db = this.getWritableDatabase();

        Cursor res = db.rawQuery("select * from obat", null);

        return res;

    }


    //metode untuk merubah data

    public boolean updateData(String id, String kode, String obat, String jenis, String indikasi, String tanggal, String harga) {

        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues contentValues = new ContentValues();

        contentValues.put(COL_1, id);

        contentValues.put(COL_2, kode);

        contentValues.put(COL_3, obat);

        contentValues.put(COL_4, jenis);

        contentValues.put(COL_5, indikasi);

        contentValues.put(COL_6, tanggal);

        contentValues.put(COL_7, harga);

        db.update(TABLE_NAME, contentValues, "id = ?", new String[]{id});

        return true;

    }


    //metode untuk menghapus data

    public int deleteData(String id) {

        SQLiteDatabase db = this.getWritableDatabase();

        return db.delete(TABLE_NAME, "id = ?", new String[]{id});

    }

}