\u6b22\u8fce\u6765\u5230Android SQLite\u793a\u4f8b\u6559\u7a0b\u3002Android SQLite\u662f\u5b58\u50a8Android\u5e94\u7528\u7a0b\u5e8f\u6570\u636e\u7684\u9996\u9009\u65b9\u5f0f\u3002\u5bf9\u4e8e\u8bb8\u591a\u5e94\u7528\u7a0b\u5e8f\u6765\u8bf4\uff0c\u65e0\u8bba\u662f\u76f4\u63a5\u4f7f\u7528\u8fd8\u662f\u901a\u8fc7\u7b2c\u4e09\u65b9\u5c01\u88c5\uff0cSQLite\u90fd\u662f\u5e94\u7528\u7a0b\u5e8f\u7684\u652f\u67f1\u3002\u4e0b\u9762\u662f\u6211\u4eec\u4eca\u5929\u5c06\u4f7f\u7528Android SQLite\u6570\u636e\u5e93\u521b\u5efa\u7684\u6700\u7ec8\u5e94\u7528\u7a0b\u5e8f\u3002<\/p>\n
<\/p>\n
SQLiteOpenHelper\u5c01\u88c5\u4e86\u8fd9\u4e9b\u903b\u8f91\uff0c\u6839\u636e\u6211\u4eec\u7684\u89c4\u8303\u521b\u5efa\u548c\u5347\u7ea7\u6570\u636e\u5e93\u3002\u4e3a\u6b64\uff0c\u6211\u4eec\u9700\u8981\u521b\u5efa\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684SQLiteOpenHelper\u5b50\u7c7b\uff0c\u81f3\u5c11\u5b9e\u73b0\u4ee5\u4e0b\u4e09\u4e2a\u65b9\u6cd5\u3002<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
onCreate(SQLiteDatabase db)\uff1a\u5f53\u6ca1\u6709\u6570\u636e\u5e93\u4e14\u5e94\u7528\u7a0b\u5e8f\u9700\u8981\u4e00\u4e2a\u65f6\u8c03\u7528\u6b64\u51fd\u6570\u3002\u5b83\u4f20\u9012\u7ed9\u6211\u4eec\u4e00\u4e2a\u6307\u5411\u65b0\u521b\u5efa\u7684\u6570\u636e\u5e93\u7684SQLiteDatabase\u5bf9\u8c61\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u5b83\u6765\u586b\u5145\u8868\u683c\u548c\u521d\u59cb\u6570\u636e\u3002<\/p>\n
onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)\uff1a\u5f53\u6211\u4eec\u9700\u8981\u7684\u6a21\u5f0f\u7248\u672c\u4e0e\u6570\u636e\u5e93\u7684\u6a21\u5f0f\u7248\u672c\u4e0d\u5339\u914d\u65f6\u8c03\u7528\u6b64\u51fd\u6570\u3002\u5b83\u4f20\u9012\u7ed9\u6211\u4eec\u4e00\u4e2aSQLiteDatabase\u5bf9\u8c61\u548c\u65e7\u7248\u672c\u53f7\u548c\u65b0\u7248\u672c\u53f7\u3002\u56e0\u6b64\uff0c\u6211\u4eec\u53ef\u4ee5\u627e\u51fa\u5c06\u6570\u636e\u5e93\u4ece\u65e7\u6a21\u5f0f\u8f6c\u6362\u4e3a\u65b0\u6a21\u5f0f\u7684\u6700\u4f73\u65b9\u6cd5\u3002<\/p>\n
\u6211\u4eec\u5b9a\u4e49\u4e86\u4e00\u4e2aDBManager\u7c7b\u6765\u6267\u884c\u6240\u6709\u6570\u636e\u5e93\u7684\u589e\u3001\u5220\u3001\u6539\u3001\u67e5\u64cd\u4f5c\u3002<\/p>\n
public DBManager open() throws SQLException {\r\n dbHelper = new DatabaseHelper(context);\r\n database = dbHelper.getWritableDatabase();\r\n return this;\r\n }\r\n<\/code><\/pre>\nDbHelper \u662f SQLiteOpenHelper \u7684\u5b50\u7c7b\u7684\u4e00\u4e2a\u5b9e\u4f8b\u3002\u4e3a\u4e86\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u4f1a\u8c03\u7528\u4e0b\u9762\u7684\u65b9\u6cd5\u3002<\/p>\n
public void close() {\r\n dbHelper.close();\r\n }\r\n<\/code><\/pre>\n\u5c06\u65b0\u8bb0\u5f55\u63d2\u5165Android SQLite\u6570\u636e\u5e93\u8868\u4e2d\u3002\u4ee5\u4e0b\u4ee3\u7801\u7247\u6bb5\u5c55\u793a\u4e86\u5982\u4f55\u5728Android SQLite\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u4e00\u6761\u65b0\u8bb0\u5f55\u3002<\/p>\npublic void insert(String name, String desc) {\r\n ContentValues contentValue = new ContentValues();\r\n contentValue.put(DatabaseHelper.SUBJECT, name);\r\n contentValue.put(DatabaseHelper.DESC, desc);\r\n database.insert(DatabaseHelper.TABLE_NAME, null, contentValue);\r\n }\r\n<\/code><\/pre>\nContent Values\u5728\u7ed9\u5b9a\u7684\u521d\u59cb\u5927\u5c0f\u4e0b\u521b\u5efa\u4e00\u4e2a\u7a7a\u503c\u96c6\u5408\u3002\u5f53\u6211\u4eec\u5f00\u59cb\u7f16\u7801\u90e8\u5206\u65f6\uff0c\u6211\u4eec\u5c06\u8ba8\u8bba\u5176\u4ed6\u5b9e\u4f8b\u503c\u3002<\/p>\n
\u5728Android SQLite\u6570\u636e\u5e93\u8868\u4e2d\u66f4\u65b0\u8bb0\u5f55\u4e0b\u9762\u7684\u4ee3\u7801\u7247\u6bb5\u5c55\u793a\u4e86\u5982\u4f55\u66f4\u65b0\u5355\u6761\u8bb0\u5f55\u3002<\/p>\npublic int update(long _id, String name, String desc) {\r\n ContentValues contentValues = new ContentValues();\r\n contentValues.put(DatabaseHelper.SUBJECT, name);\r\n contentValues.put(DatabaseHelper.DESC, desc);\r\n int i = database.update(DatabaseHelper.TABLE_NAME, contentValues, DatabaseHelper._ID + \" = \" + _id, null);\r\n return i;\r\n }\r\n<\/code><\/pre>\nAndroid SQLite – \u5220\u9664\u8bb0\u5f55\u6211\u4eec\u53ea\u9700\u8981\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u4f20\u9012\u8981\u5220\u9664\u7684\u8bb0\u5f55\u7684ID\u5373\u53ef\u3002<\/p>\npublic void delete(long _id) {\r\n database.delete(DatabaseHelper.TABLE_NAME, DatabaseHelper._ID + \"=\" + _id, null);\r\n }\r\n<\/code><\/pre>\n\u5b89\u5353SQLite\u6e38\u6807\u6e38\u6807\u8868\u793a\u67e5\u8be2\u7684\u6574\u4e2a\u7ed3\u679c\u96c6\u3002\u4e00\u65e6\u67e5\u8be2\u88ab\u83b7\u53d6\uff0c\u5c06\u4f1a\u8c03\u7528cursor.moveToFirst()\u3002\u8c03\u7528moveToFirst()\u4f1a\u505a\u4e24\u4ef6\u4e8b\u60c5\uff1a<\/p>\n\n- It allows us to test whether the query returned an empty set (by testing the return value)<\/li>\n
- It moves the cursor to the first result (when the set is not empty)<\/li>\n<\/ul>\n
\u4ee5\u4e0b\u4ee3\u7801\u7528\u4e8e\u83b7\u53d6\u6240\u6709\u7684\u8bb0\u5f55\u3002<\/p>\n
public Cursor fetch() {\r\n String[] columns = new String[] { DatabaseHelper._ID, DatabaseHelper.SUBJECT, DatabaseHelper.DESC };\r\n Cursor cursor = database.query(DatabaseHelper.TABLE_NAME, columns, null, null, null, null, null);\r\n if (cursor != null) {\r\n cursor.moveToFirst();\r\n }\r\n return cursor;\r\n }\r\n<\/code><\/pre>\n\u53e6\u4e00\u79cd\u4f7f\u7528\u5149\u6807\u7684\u65b9\u5f0f\u662f\u5c06\u5176\u5305\u88c5\u5728CursorAdapter\u4e2d\u3002\u5c31\u50cfArrayAdapter\u9002\u914d\u6570\u7ec4\u4e00\u6837\uff0cCursorAdapter\u9002\u914dCursor\u5bf9\u8c61\uff0c\u5c06\u5176\u6570\u636e\u63d0\u4f9b\u7ed9\u50cfListView\u8fd9\u6837\u7684AdapterView\u3002\u8ba9\u6211\u4eec\u8df3\u8f6c\u5230\u4f7f\u7528SQLite\u5b58\u50a8\u4e00\u4e9b\u6709\u610f\u4e49\u6570\u636e\u7684\u9879\u76ee\u4e2d\u3002<\/p>\n
Android SQLite\u4f8b\u5b50\u9879\u76ee\u7684\u67b6\u6784\u5728\u8fd9\u4e2a\u5e94\u7528\u4e2d\uff0c\u6211\u4eec\u5e0c\u671b\u521b\u5efa\u4e00\u4e2a\u8bb0\u5f55\u56fd\u5bb6\u540d\u79f0\u548c\u5176\u76f8\u5e94\u8d27\u5e01\u7684ListView\u5f62\u5f0f\u7684\u5217\u8868\u3002\u6211\u4eec\u6db5\u76d6\u4e86\u4e0a\u8ff0\u8ba8\u8bba\u7684\u6240\u6709\u529f\u80fd\u3002<\/p>\n\u5b89\u5353SQLite\u9879\u76ee\u4ee3\u7801<\/p>\n
\u8fd9\u662f\u6587\u7ae0\u300a\u5b89\u5353SQLite\u6570\u636e\u5e93\u793a\u4f8b\u6559\u7a0b\u300b\u7684\u7b2c2\u90e8\u5206\uff08\u51713\u90e8\u5206\uff09\u3002<\/p>\n
\u8fd9\u4e2a\u5e94\u7528\u7a0b\u5e8f\u75315\u4e2a\u7c7b\u7ec4\u6210\u3002\u6211\u4eec\u9996\u5148\u5b9a\u4e49DatabaseHelper\uff0c\u5b83\u662fSQLiteOpenHelper\u7684\u5b50\u7c7b\uff0c\u4ee3\u7801\u5982\u4e0b\uff1aDatabaseHelper.java<\/p>\n
package com.Olivia.sqlite;\r\n\r\nimport android.content.Context;\r\nimport android.database.sqlite.SQLiteDatabase;\r\nimport android.database.sqlite.SQLiteOpenHelper;\r\n\r\npublic class DatabaseHelper extends SQLiteOpenHelper {\r\n\r\n \/\/ \u8868\u540d\r\n public static final String TABLE_NAME = \"COUNTRIES\";\r\n\r\n \/\/ \u8868\u5217\r\n public static final String _ID = \"_id\";\r\n public static final String SUBJECT = \"subject\";\r\n public static final String DESC = \"description\";\r\n\r\n \/\/ \u6570\u636e\u5e93\u4fe1\u606f\r\n static final String DB_NAME = \"JOURNALDEV_COUNTRIES.DB\";\r\n\r\n \/\/ \u6570\u636e\u5e93\u7248\u672c\r\n static final int DB_VERSION = 1;\r\n\r\n \/\/ \u521b\u5efa\u8868\u67e5\u8be2\r\n private static final String CREATE_TABLE = \"create table \" + TABLE_NAME + \"(\" + _ID\r\n + \" INTEGER PRIMARY KEY AUTOINCREMENT, \" + SUBJECT + \" TEXT NOT NULL, \" + DESC + \" TEXT);\";\r\n\r\n public DatabaseHelper(Context context) {\r\n super(context, DB_NAME, null, DB_VERSION);\r\n }\r\n\r\n @Override\r\n public void onCreate(SQLiteDatabase db) {\r\n db.execSQL(CREATE_TABLE);\r\n }\r\n\r\n @Override\r\n public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r\n db.execSQL(\"DROP TABLE IF EXISTS \" + TABLE_NAME);\r\n onCreate(db);\r\n }\r\n}\r\n<\/code><\/pre>\n\u5982\u4e0a\u6240\u8ff0\uff0c\u9664\u4e86\u6784\u9020\u51fd\u6570\u4e4b\u5916\uff0c\u6211\u4eec\u5df2\u7ecf\u91cd\u5199\u4e86onCreate()\u548conUpgrade()\u65b9\u6cd5\u3002\u6211\u4eec\u4e3a\u6570\u636e\u5e93\u548c\u8868\u5206\u522b\u6307\u5b9a\u4e86\u540d\u79f0\u4e3aJOURNALDEV_COUNTRIES.DB\u548cCOUNTRIES\u3002\u6bcf\u5f53\u63d2\u5165\u65b0\u884c\u65f6\uff0c\u7d22\u5f15\u5217\u4f1a\u81ea\u52a8\u589e\u52a0\u3002\u56fd\u5bb6\u548c\u8d27\u5e01\u7684\u5217\u540d\u5206\u522b\u662f”subject”\u548c”description”\u3002DBManager\u7c7b\u662f\u521d\u59cb\u5316DatabaseHelper\u5e76\u5b9a\u4e49CRUD\u64cd\u4f5c\u7684\u5730\u65b9\u3002\u4ee5\u4e0b\u662f\u8fd9\u4e2a\u7c7b\u7684\u4ee3\u7801\uff1aDBManager.java\u3002<\/p>\n
package com.Olivia.sqlite;\r\n\r\n\r\nimport android.content.ContentValues;\r\nimport android.content.Context;\r\nimport android.database.Cursor;\r\nimport android.database.SQLException;\r\nimport android.database.sqlite.SQLiteDatabase;\r\n\r\npublic class DBManager {\r\n\r\n private DatabaseHelper dbHelper;\r\n\r\n private Context context;\r\n\r\n private SQLiteDatabase database;\r\n\r\n public DBManager(Context c) {\r\n context = c;\r\n }\r\n\r\n public DBManager open() throws SQLException {\r\n dbHelper = new DatabaseHelper(context);\r\n database = dbHelper.getWritableDatabase();\r\n return this;\r\n }\r\n\r\n public void close() {\r\n dbHelper.close();\r\n }\r\n\r\n public void insert(String name, String desc) {\r\n ContentValues contentValue = new ContentValues();\r\n contentValue.put(DatabaseHelper.SUBJECT, name);\r\n contentValue.put(DatabaseHelper.DESC, desc);\r\n database.insert(DatabaseHelper.TABLE_NAME, null, contentValue);\r\n }\r\n\r\n public Cursor fetch() {\r\n String[] columns = new String[] { DatabaseHelper._ID, DatabaseHelper.SUBJECT, DatabaseHelper.DESC };\r\n Cursor cursor = database.query(DatabaseHelper.TABLE_NAME, columns, null, null, null, null, null);\r\n if (cursor != null) {\r\n cursor.moveToFirst();\r\n }\r\n return cursor;\r\n }\r\n\r\n public int update(long _id, String name, String desc) {\r\n ContentValues contentValues = new ContentValues();\r\n contentValues.put(DatabaseHelper.SUBJECT, name);\r\n contentValues.put(DatabaseHelper.DESC, desc);\r\n int i = database.update(DatabaseHelper.TABLE_NAME, contentValues, DatabaseHelper._ID + \" = \" + _id, null);\r\n return i;\r\n }\r\n\r\n public void delete(long _id) {\r\n database.delete(DatabaseHelper.TABLE_NAME, DatabaseHelper._ID + \"=\" + _id, null);\r\n }\r\n\r\n}\r\n<\/code><\/pre>\n\u5f53\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\u65f6\uff0cCountryListActivity.java\u7c7b\u662f\u88ab\u542f\u52a8\u7684\u6d3b\u52a8\u3002\u4e0b\u9762\u662f\u4e3a\u5176\u5b9a\u4e49\u7684\u5e03\u5c40\uff1afragment_emp_list.xml\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<RelativeLayout xmlns:android=\"https:\/\/schemas.android.com\/apk\/res\/android\"\r\n android:layout_width=\"fill_parent\"\r\n android:layout_height=\"fill_parent\" >\r\n\r\n <ListView\r\n android:id=\"@+id\/list_view\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:dividerHeight=\"1dp\"\r\n android:padding=\"10dp\" >\r\n <\/ListView>\r\n\r\n <TextView\r\n android:id=\"@+id\/empty\"\r\n android:layout_width=\"wrap_content\"\r\n android:layout_height=\"wrap_content\"\r\n android:layout_centerInParent=\"true\"\r\n android:text=\"@string\/empty_list_text\" \/>\r\n\r\n<\/RelativeLayout>\r\n<\/code><\/pre>\n\u5728\u8fd9\u91cc\u5b9a\u4e49\u4e86\u4e00\u4e2aListView\u7ec4\u4ef6\u6765\u5305\u542b\u5b58\u50a8\u5728\u6570\u636e\u5e93\u4e2d\u7684\u8bb0\u5f55\u3002\u6700\u521d\uff0cListView\u662f\u7a7a\u7684\uff0c\u56e0\u6b64\u4f7f\u7528TextView\u6765\u663e\u793a\u76f8\u540c\u7684\u5185\u5bb9\u3002CountryListActivity.java<\/p>\n
package com.Olivia.sqlite;\r\n\r\nimport android.content.Intent;\r\nimport android.database.Cursor;\r\nimport android.os.Bundle;\r\nimport android.support.v4.widget.SimpleCursorAdapter;\r\nimport android.support.v7.app.ActionBarActivity;\r\nimport android.view.Menu;\r\nimport android.view.MenuItem;\r\nimport android.view.View;\r\nimport android.widget.AdapterView;\r\nimport android.widget.ListView;\r\nimport android.widget.TextView;\r\n\r\npublic class CountryListActivity extends ActionBarActivity {\r\n\r\n private DBManager dbManager;\r\n\r\n private ListView listView;\r\n\r\n private SimpleCursorAdapter adapter;\r\n\r\n final String[] from = new String[] { DatabaseHelper._ID,\r\n DatabaseHelper.SUBJECT, DatabaseHelper.DESC };\r\n\r\n final int[] to = new int[] { R.id.id, R.id.title, R.id.desc };\r\n\r\n @Override\r\n protected void onCreate(Bundle savedInstanceState) {\r\n super.onCreate(savedInstanceState);\r\n\r\n setContentView(R.layout.fragment_emp_list);\r\n\r\n dbManager = new DBManager(this);\r\n dbManager.open();\r\n Cursor cursor = dbManager.fetch();\r\n\r\n listView = (ListView) findViewById(R.id.list_view);\r\n listView.setEmptyView(findViewById(R.id.empty));\r\n\r\n adapter = new SimpleCursorAdapter(this, R.layout.activity_view_record, cursor, from, to, 0);\r\n adapter.notifyDataSetChanged();\r\n\r\n listView.setAdapter(adapter);\r\n\r\n \/\/ \u5217\u8868\u9879\u70b9\u51fb\u76d1\u542c\u5668\r\n listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {\r\n @Override\r\n public void onItemClick(AdapterView<?> parent, View view, int position, long viewId) {\r\n TextView idTextView = (TextView) view.findViewById(R.id.id);\r\n TextView titleTextView = (TextView) view.findViewById(R.id.title);\r\n TextView descTextView = (TextView) view.findViewById(R.id.desc);\r\n\r\n String id = idTextView.getText().toString();\r\n String title = titleTextView.getText().toString();\r\n String desc = descTextView.getText().toString();\r\n\r\n Intent modify_intent = new Intent(getApplicationContext(), ModifyCountryActivity.class);\r\n modify_intent.putExtra(\"title\", title);\r\n modify_intent.putExtra(\"desc\", desc);\r\n modify_intent.putExtra(\"id\", id);\r\n\r\n startActivity(modify_intent);\r\n }\r\n });\r\n }\r\n\r\n @Override\r\n public boolean onCreateOptionsMenu(Menu menu) {\r\n getMenuInflater().inflate(R.menu.main, menu);\r\n return true;\r\n }\r\n\r\n @Override\r\n public boolean onOptionsItemSelected(MenuItem item) {\r\n\r\n int id = item.getItemId();\r\n if (id == R.id.add_record) {\r\n\r\n Intent add_mem = new Intent(this, AddCountryActivity.class);\r\n startActivity(add_mem);\r\n\r\n }\r\n return super.onOptionsItemSelected(item);\r\n }\r\n\r\n}\r\n<\/code><\/pre>\n\u5728\u8fd9\u4e2a\u6d3b\u52a8\u4e2d\uff0c\u8c03\u7528DBManager\u5bf9\u8c61\u6765\u6267\u884cCRUD\u64cd\u4f5c\u3002\u5b9a\u4e49\u4e86\u4e00\u4e2aSimpleCursorAdapter\u6765\u5c06\u67e5\u8be2\u7ed3\u679c\u4e2d\u8fd4\u56de\u7684Cursor\u5bf9\u8c61\u4e2d\u7684\u5143\u7d20\u6dfb\u52a0\u5230\u5217\u8868\u4e2d\u3002\u5728\u5217\u8868\u9879\u70b9\u51fb\u65f6\uff0c\u6267\u884c\u4e00\u4e2a\u610f\u56fe\u6765\u6253\u5f00ModifyCountryActivity\u7c7b\u3002\u83dc\u5355\u4e2d\u5305\u542b\u4e00\u4e2a\u4eceActionBar\u4e2d\u6dfb\u52a0\u65b0\u8bb0\u5f55\u7684\u9879\u76ee\u3002\u5728\u8fd9\u91cc\uff0c\u518d\u6b21\u6267\u884c\u4e00\u4e2a\u610f\u56fe\u6765\u6253\u5f00AddCountryActivity\u7c7b\u3002\u4ee5\u4e0b\u662fmenu.xml\u7684\u4ee3\u7801\u3002<\/p>\n
<menu xmlns:android=\"https:\/\/schemas.android.com\/apk\/res\/android\"\r\n xmlns:app=\"https:\/\/schemas.android.com\/apk\/res-auto\"\r\n xmlns:tools=\"https:\/\/schemas.android.com\/tools\"\r\n tools:context=\"com.example.sqlitesample.MainActivity\" >\r\n\r\n <item\r\n android:id=\"@+id\/add_record\"\r\n android:icon=\"@android:drawable\/ic_menu_add\"\r\n android:orderInCategory=\"100\"\r\n android:title=\"@string\/add_record\"\r\n app:showAsAction=\"always\"\/>\r\n\r\n<\/menu>\r\n<\/code><\/pre>\n\u4ee5\u4e0b\u662fAddCountryActivity.java\u6587\u4ef6\u7684xml\u5e03\u5c40\u548c\u4ee3\u7801\uff1aactivity_add_record.xml<\/p>\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<LinearLayout xmlns:android=\"https:\/\/schemas.android.com\/apk\/res\/android\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"match_parent\"\r\n android:orientation=\"vertical\"\r\n android:padding=\"20dp\" >\r\n\r\n <EditText\r\n android:id=\"@+id\/subject_edittext\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:ems=\"10\"\r\n android:hint=\"@string\/enter_title\" >\r\n\r\n <requestFocus \/>\r\n <\/EditText>\r\n\r\n <EditText\r\n android:id=\"@+id\/description_edittext\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:ems=\"10\"\r\n android:hint=\"@string\/enter_desc\"\r\n android:inputType=\"textMultiLine\"\r\n android:minLines=\"5\" >\r\n <\/EditText>\r\n\r\n <Button\r\n android:id=\"@+id\/add_record\"\r\n android:layout_width=\"wrap_content\"\r\n android:layout_height=\"wrap_content\"\r\n android:layout_gravity=\"center\"\r\n android:text=\"@string\/add_record\" \/>\r\n\r\n<\/LinearLayout>\r\n<\/code><\/pre>\n\u5b9a\u4e49\u4e86\u4e24\u4e2aEditText\u7ec4\u4ef6\uff0c\u7528\u4e8e\u8f93\u5165\u56fd\u5bb6\u548c\u8d27\u5e01\uff0c\u4ee5\u53ca\u4e00\u4e2a\u6309\u94ae\uff0c\u5c06\u8fd9\u4e9b\u503c\u6dfb\u52a0\u5230\u6570\u636e\u5e93\u5e76\u5728ListView\u4e2d\u663e\u793a\u3002AddCountryActivity.java<\/p>\n
package com.Olivia.sqlite;\r\n\r\nimport android.app.Activity;\r\nimport android.content.Intent;\r\nimport android.os.Bundle;\r\nimport android.view.View;\r\nimport android.view.View.OnClickListener;\r\nimport android.widget.Button;\r\nimport android.widget.EditText;\r\n\r\npublic class AddCountryActivity extends Activity implements OnClickListener {\r\n\r\n private Button addTodoBtn;\r\n private EditText subjectEditText;\r\n private EditText descEditText;\r\n\r\n private DBManager dbManager;\r\n\r\n @Override\r\n protected void onCreate(Bundle savedInstanceState) {\r\n super.onCreate(savedInstanceState);\r\n\r\n setTitle(\"\u6dfb\u52a0\u8bb0\u5f55\");\r\n\r\n setContentView(R.layout.activity_add_record);\r\n\r\n subjectEditText = (EditText) findViewById(R.id.subject_edittext);\r\n descEditText = (EditText) findViewById(R.id.description_edittext);\r\n\r\n addTodoBtn = (Button) findViewById(R.id.add_record);\r\n\r\n dbManager = new DBManager(this);\r\n dbManager.open();\r\n addTodoBtn.setOnClickListener(this);\r\n }\r\n\r\n @Override\r\n public void onClick(View v) {\r\n switch (v.getId()) {\r\n case R.id.add_record:\r\n\r\n final String name = subjectEditText.getText().toString();\r\n final String desc = descEditText.getText().toString();\r\n\r\n dbManager.insert(name, desc);\r\n\r\n Intent main = new Intent(AddCountryActivity.this, CountryListActivity.class)\r\n .setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);\r\n\r\n startActivity(main);\r\n break;\r\n }\r\n }\r\n\r\n}\r\n<\/code><\/pre>\n\u5728\u8fd9\u91cc\u6267\u884c\u7684CRUD\u64cd\u4f5c\u662f\u5411\u6570\u636e\u5e93\u4e2d\u6dfb\u52a0\u4e00\u6761\u65b0\u8bb0\u5f55\u3002\u4e0b\u9762\u5b9a\u4e49\u4e86ModifyCountryActivity.java\u6587\u4ef6\u7684xml\u5e03\u5c40\u548c\u4ee3\u7801\uff1aactivity_modify_record.xml\u3002<\/p>\n
<?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n<LinearLayout xmlns:android=\"https:\/\/schemas.android.com\/apk\/res\/android\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"match_parent\"\r\n android:orientation=\"vertical\"\r\n android:padding=\"10dp\" >\r\n\r\n <EditText\r\n android:id=\"@+id\/subject_edittext\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:layout_marginBottom=\"10dp\"\r\n android:ems=\"10\"\r\n android:hint=\"@string\/enter_title\" \/>\r\n\r\n <EditText\r\n android:id=\"@+id\/description_edittext\"\r\n android:layout_width=\"match_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:ems=\"10\"\r\n android:hint=\"@string\/enter_desc\"\r\n android:inputType=\"textMultiLine\"\r\n android:minLines=\"5\" >\r\n <\/EditText>\r\n\r\n\r\n <LinearLayout\r\n android:layout_width=\"fill_parent\"\r\n android:layout_height=\"wrap_content\"\r\n android:weightSum=\"2\"\r\n android:gravity=\"center_horizontal\"\r\n android:orientation=\"horizontal\" >\r\n\r\n <Button\r\n android:id=\"@+id\/btn_update\"\r\n android:layout_width=\"wrap_content\"\r\n android:layout_height=\"wrap_content\"\r\n android:layout_weight=\"1\"\r\n android:text=\"@string\/btn_update\" \/>\r\n\r\n <Button\r\n android:id=\"@+id\/btn_delete\"\r\n android:layout_width=\"wrap_content\"\r\n android:layout_height=\"wrap_content\"\r\n android:layout_weight=\"1\"\r\n android:text=\"@string\/btn_delete\" \/>\r\n <\/LinearLayout>\r\n\r\n<\/LinearLayout>\r\n<\/code><\/pre>\n\u8fd9\u4e0e\u4ee5\u524d\u7684\u5e03\u5c40\u76f8\u4f3c\uff0c\u53ea\u662f\u6dfb\u52a0\u4e86\u4fee\u6539\u548c\u5220\u9664\u6309\u94ae\u3002ModifyCountryActivity.java<\/p>\n
package com.Olivia.sqlite;\r\n\r\nimport android.app.Activity;\r\nimport android.content.Intent;\r\nimport android.os.Bundle;\r\nimport android.view.View;\r\nimport android.view.View.OnClickListener;\r\nimport android.widget.Button;\r\nimport android.widget.EditText;\r\n\r\npublic class ModifyCountryActivity extends Activity implements OnClickListener {\r\n\r\n private EditText titleText;\r\n private Button updateBtn, deleteBtn;\r\n private EditText descText;\r\n\r\n private long _id;\r\n\r\n private DBManager dbManager;\r\n\r\n @Override\r\n protected void onCreate(Bundle savedInstanceState) {\r\n super.onCreate(savedInstanceState);\r\n\r\n setTitle(\"\u4fee\u6539\u8bb0\u5f55\");\r\n\r\n setContentView(R.layout.activity_modify_record);\r\n\r\n dbManager = new DBManager(this);\r\n dbManager.open();\r\n\r\n titleText = (EditText) findViewById(R.id.subject_edittext);\r\n descText = (EditText) findViewById(R.id.description_edittext);\r\n\r\n updateBtn = (Button) findViewById(R.id.btn_update);\r\n deleteBtn = (Button) findViewById(R.id.btn_delete);\r\n\r\n Intent intent = getIntent();\r\n String id = intent.getStringExtra(\"id\");\r\n String name = intent.getStringExtra(\"title\");\r\n String desc = intent.getStringExtra(\"desc\");\r\n\r\n _id = Long.parseLong(id);\r\n\r\n titleText.setText(name);\r\n descText.setText(desc);\r\n\r\n updateBtn.setOnClickListener(this);\r\n deleteBtn.setOnClickListener(this);\r\n }\r\n\r\n @Override\r\n public void onClick(View v) {\r\n switch (v.getId()) {\r\n case R.id.btn_update:\r\n String title = titleText.getText().toString();\r\n String desc = descText.getText().toString();\r\n\r\n dbManager.update(_id, title, desc);\r\n this.returnHome();\r\n break;\r\n\r\n case R.id.btn_delete:\r\n dbManager.delete(_id);\r\n this.returnHome();\r\n break;\r\n }\r\n }\r\n\r\n public void returnHome() {\r\n Intent home_intent = new Intent(getApplicationContext(), CountryListActivity.class)\r\n .setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);\r\n startActivity(home_intent);\r\n }\r\n}\r\n<\/code><\/pre>\n\u5728\u8fd9\u91cc\u6267\u884c\u7684CRUD\u64cd\u4f5c\u662f\u66f4\u65b0\u548c\u5220\u9664\u8bb0\u5f55\u3002\u4e0b\u9762\u7684\u56fe\u50cf\u662f\u6211\u4eec\u9879\u76ee\u7684\u6700\u7ec8\u8f93\u51fa\u7684\u5c4f\u5e55\u622a\u56fe\u3002\u7b2c\u4e00\u5f20\u56fe\u7247\u662f\u5728\u9996\u6b21\u542f\u52a8\u5e94\u7528\u7a0b\u5e8f\u65f6\u770b\u5230\u7684\u8f93\u51fa\u3002\u7b2c\u4e8c\u5f20\u56fe\u7247\u662f\u70b9\u51fbActionBar\u4e2d\u7684\u83dc\u5355\u9009\u9879\u540e\u7684\u7ed3\u679c\uff0c\u5982\u4e0b\u6240\u793a\u3002\u7b2c\u4e09\u5f20\u56fe\u7247\u663e\u793a\u6dfb\u52a03\u4e2a\u8bb0\u5f55\u7684\u8f93\u51fa\u3002\u7b2c\u56db\u5f20\u56fe\u7247\u663e\u793a\u70b9\u51fb\u5217\u8868\u9879\u4ee5\u4fee\u6539\u6216\u5220\u9664\u8bb0\u5f55\u7684\u8f93\u51fa\u3002\u6700\u540e\u4e00\u5f20\u56fe\u7247\u662f\u5220\u9664\u8bb0\u5f55\u65f6\u7684\u8f93\u51fa\u3002\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff0c\u6211\u4eec\u5220\u9664\u4e86\u7b2c\u4e00\u6761\u8bb0\u5f55\u3002<\/p>\n
\u6253\u5f00Android SQLite\u6570\u636e\u5e93\u6587\u4ef6<\/h3>\n