5/12/2023 0 Comments Sqlite query androidPrivate ListView.OnItemClickListener listContentOnItemClickListener String data2 = inputContent2.getText().toString() īutton.OnClickListener buttonDeleteAllOnClickListener String data1 = inputContent1.getText().toString() New SimpleCursorAdapter(AndroidSQLite.this, R.layout.row, cursor, from, to) īutton.OnClickListener buttonAddOnClickListener Public SQLiteAdapter openToRead() throws + KEY_ID + " integer primary key autoincrement, " "create table " + MYDATABASE_TABLE + " (" ![]() Private static final String SCRIPT_CREATE_DATABASE = create table MY_DATABASE (ID integer primary key, Content text not null) Public static final String KEY_CONTENT2 = "Content2" Public static final String KEY_CONTENT1 = "Content1" Public static final String KEY_ID = "_id" Public static final int MYDATABASE_VERSION = 1 ![]() Public static final String MYDATABASE_TABLE = "MY_TABLE" Public static final String MYDATABASE_NAME = "MY_DATABASE" Modify SQLiteAdapter.java to add method queueAll_SortBy_CONTENT1(), simple call sqLiteDatabase.query(MYDATABASE_TABLE, columns, null, null, null, null, KEY_CONTENT1) indirectly. Modify main.xml to add two key, sortbyDefault and sortby1. Modify to have option to quary order by default, adn to quary order by KEY_CONTENT1. Work on last exercise, " Edit row in SQLite database using SQLiteDatabase.update()".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |