db创建较简语法示例

...............
public static final String TABLE_NAME = "notes";
public static final String CONTENT = "content";
public static final String ID = "_id";
public static final String TIME = "time";
.............
//在 onCreate()中建表
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE"+TABLE_NAME+"("
+ID+"INTEGER PRIMARY KEY AUTOINCEREAMENT,"+CONTENT+"TEXT NOT NULL,"+TIME+"TEXT NOT NULL");

}


posted @ 2016-05-26 15:08  gentspy  阅读(174)  评论(0编辑  收藏  举报