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");
}