Search This Blog

Friday, September 22, 2017

Tạo sqlite update

package com.minhnhut027.vgirls.vgirls.ConTroller;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/** * Created by cntt on 9/22/17. */
public class SQLITE extends SQLiteOpenHelper {

    // tao table    public static final String TABLE_IMAGE = "Image" ;
    public static final String CREATE_TABLE_IMAGE = "CREATE TABLE "            + TABLE_IMAGE + "(" +
            "id" + " TEXT NOT NULL," +
            "like" + " TEXT NOT NULL )";


    // them mac dinh
    // xoa    public static final String DROP_TABLE_IMAGE = "DROP TABLE IF EXIST  "+ TABLE_IMAGE             ;

    public SQLITE(Context context) {
        super(context, "SQLite.sqlite", null, 1);
    }

    @Override    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_TABLE_IMAGE);

        // tao data mac dinh            }


    public Cursor SQLite_GetData(String sql) {
        SQLiteDatabase db = getWritableDatabase();
        Cursor c = db.rawQuery(sql, null);
        return c;
    }
    public void SQL_QueryData(String sql) {
        SQLiteDatabase db = getWritableDatabase();
        db.execSQL(sql);
    }
    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        db.execSQL(DROP_TABLE_IMAGE);

        this.onCreate(db);
    }
}

No comments:

Post a Comment