阅读背景:

如何在Logcat中显示SQLite表

来源:互联网 

Database Helper

public class DatabaseHelper extends SQLiteOpenHelper {

// Table Name
public static final String TABLE_NAME = "Contacts";

// Table columns
public static final String ID = "ID";
public static final String Contact_Name = "Contact_Name";
public static final String Phone_Number = "Phone_Number";
public static final String Favourites = "Favourites";

// Database Information
static final String DB_NAME = "MessagePlus_Contacts";

// database version
static final int DB_VERSION = 1;

// Creating table query
private static final String CREATE_TABLE = "Create Table " + TABLE_NAME + "(" + ID
        + " INTEGER PRIMARY KEY AUTOINCREMENT, " + Contact_Name + " TEXT NOT NULL, " + Phone_Number + " INT NOT NULL, " + Favourites + " Boolean NOT NULL);";

private static final String Show_Table = "Select * From " + TABLE_NAME;

public DatabaseHelper(Context context) {
    super(context, DB_NAME, null, DB_VERSION);
}

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

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
    onCreate(db);
}

public void showData(SQLiteDatabase db){db.execSQL(Show_Table);}

public void insertData(String contactName, String phoneNumber,String favourites) {

    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();

    values.put(DatabaseHelper.Contact_Name, contactName);
    values.put(DatabaseHelper.Phone_Number, phoneNumber);
    values.put(DatabaseHelper.Favourites, favourites);

    db.insert(DatabaseHelper.TABLE_NAME, null, values);
    // close db connection
    db.close();
}

public int addToFavourites(String favourites) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(DatabaseHelper.Favourites, favourites);

    // updating row
    return db.update(DatabaseHelper.TABLE_NAME, values, DatabaseHelper.Phone_Number + " = ?", new String[]{favourites});
}



public int getCount() {
    String countQuery = "SELECT * FROM " + DatabaseHelper.TABLE_NAME;
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery(countQuery, null);

    int count = cursor.getCount();
    cursor.close();

    // return count
    return count;
}
public class DatabaseHelper e



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: