Back to project page bnote.
The source code is released under:
MIT License
If you think the Android project bnote listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
package com.rd.bnote; //from w w w. jav a2 s .co m import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class DBHelper extends SQLiteOpenHelper { public static final String DATABASE_NAME = "note.db"; public static final String DATABASE_TABLE = "note"; public static final int DATABASE_VERSION = 1; public static final String DATABASE_TABLE_DROP = "DROP TABLE IF EXISTS " + DATABASE_TABLE; public static final String DATABASE_TABLE_CREATE = "CREATE TABLE " + DATABASE_TABLE + "(" + "_id INTEGER PRIMARY KEY AUTOINCREMENT," + "pub_date INTEGER NOT NULL DEFAULT (strftime('%s','now') * 1000)," + "snap TEXT NOT NULL DEFAULT ''," + "content TEXT NOT NULL DEFAULT ''" + ");"; public DBHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { db.execSQL(DATABASE_TABLE_CREATE); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL(DATABASE_TABLE_DROP); onCreate(db); } }