{"id":3859,"date":"2016-01-21T07:32:57","date_gmt":"2016-01-21T07:32:57","guid":{"rendered":"http:\/\/www.fandroid.info\/?p=3859"},"modified":"2019-04-18T15:50:34","modified_gmt":"2019-04-18T12:50:34","slug":"urok-34-rabota-s-bazami-dannyh-sqlite-v-android","status":"publish","type":"post","link":"https:\/\/www.fandroid.info\/urok-34-rabota-s-bazami-dannyh-sqlite-v-android\/","title":{"rendered":"\u0423\u0440\u043e\u043a 34. \u0420\u0430\u0431\u043e\u0442\u0430 \u0441 \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 Android"},"content":{"rendered":"<p>\u041d\u0430 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u0441\u0430\u043c\u044b\u0439 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 -SharedPreferences. \u041d\u043e \u044d\u0442\u043e\u0442 \u0441\u043f\u043e\u0441\u043e\u0431 \u043d\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0431\u043e\u043b\u044c\u0448\u043e\u0433\u043e \u043e\u0431\u044a\u0435\u043c\u0430 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445. \u041d\u0430 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 android. SQLite \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u0435\u0442 \u0430\u0432\u0442\u043e\u043d\u043e\u043c\u043d\u044b\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043d\u0435 \u043d\u0443\u0436\u0434\u0430\u044e\u0449\u0438\u0435\u0441\u044f \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445 \u0438 \u043d\u0435 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u043a \u0440\u0435\u0441\u0443\u0440\u0441\u0430\u043c, \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u044b\u0435 \u0438 \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0435. \u0420\u0430\u0431\u043e\u0442\u0430 \u0441 \u0411\u0414 SQLite \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043a\u043e\u043c\u0430\u043d\u0434 \u044f\u0437\u044b\u043a\u0430 SQL, \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441 \u0438 \u0441\u043f\u0438\u0441\u043e\u043a \u043a\u043b\u044e\u0447\u0435\u0432\u044b\u0445 \u0441\u043b\u043e\u0432 \u044f\u0437\u044b\u043a\u0430 SQL \u043c\u043e\u0436\u043d\u043e \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0430 \u0441\u0430\u0439\u0442\u0435 sqlite.org. SQLite \u0447\u0438\u0442\u0430\u0435\u0442 \u0438 \u043f\u0438\u0448\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043e\u0431\u044b\u0447\u043d\u044b\u0435 \u0444\u0430\u0439\u043b\u044b \u043d\u0430 \u0434\u0438\u0441\u043a\u0435. \u041f\u043e\u043b\u043d\u0430\u044f \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 SQL \u0441 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u0438\u043d\u0434\u0435\u043a\u0441\u0430\u043c\u0438, \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u0430\u043c\u0438 \u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f\u043c\u0438, \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u043e \u0445\u0440\u0430\u043d\u0438\u0442\u0441\u044f \u0432 \u043e\u0434\u043d\u043e\u043c \u0444\u0430\u0439\u043b\u0435. \u0412\u0441\u0435 android \u0443\u0441\u0442\u0440\u043e\u0439\u0441\u0442\u0432\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442 \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 SQLite.<\/p>\n<p>\u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0439 \u043a\u043e\u0434 \u043f\u043e\u0434 \u0432\u0438\u0434\u0435\u043e:<\/p>\n<p><iframe loading=\"lazy\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/1z7KP-Xv8LA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<pre class=\"lang:default decode:true \" title=\"activity_main.xml\">&lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;\r\n&lt;LinearLayout\r\n    xmlns:android=\"http:\/\/schemas.android.com\/apk\/res\/android\"\r\n    android:layout_width=\"fill_parent\"\r\n    android:layout_height=\"fill_parent\"\r\n    android:orientation=\"vertical\"&gt;\r\n\r\n        &lt;EditText\r\n            android:id=\"@+id\/etName\"\r\n            android:hint=\"Name\"\r\n            android:layout_width=\"match_parent\"\r\n            android:layout_height=\"wrap_content\"&gt;\r\n        &lt;\/EditText&gt;\r\n\r\n        &lt;EditText\r\n            android:id=\"@+id\/etEmail\"\r\n            android:hint=\"Email\"\r\n            android:layout_width=\"match_parent\"\r\n            android:layout_height=\"wrap_content\"&gt;\r\n        &lt;\/EditText&gt;\r\n\r\n    &lt;LinearLayout\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnAdd\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"Add\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnRead\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"Read\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnClear\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"Clear\"&gt;\r\n        &lt;\/Button&gt;\r\n    &lt;\/LinearLayout&gt;\r\n&lt;\/LinearLayout&gt;<\/pre>\n<pre class=\"lang:default decode:true \" title=\"DBHelper.java\">import android.content.Context;\r\nimport android.database.sqlite.SQLiteDatabase;\r\nimport android.database.sqlite.SQLiteOpenHelper;\r\n\r\npublic class DBHelper  extends SQLiteOpenHelper{\r\n\r\n    public static final int DATABASE_VERSION = 1;\r\n    public static final String DATABASE_NAME = \"contactDb\";\r\n    public static final String TABLE_CONTACTS = \"contacts\";\r\n\r\n    public static final String KEY_ID = \"_id\";\r\n    public static final String KEY_NAME = \"name\";\r\n    public static final String KEY_MAIL = \"mail\";\r\n\r\n    public DBHelper(Context context) {\r\n        super(context, DATABASE_NAME, null, DATABASE_VERSION);\r\n    }\r\n\r\n    @Override\r\n    public void onCreate(SQLiteDatabase db) {\r\n        db.execSQL(\"create table \" + TABLE_CONTACTS + \"(\" + KEY_ID\r\n                + \" integer primary key,\" + KEY_NAME + \" text,\" + KEY_MAIL + \" text\" + \")\");\r\n\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_CONTACTS);\r\n\r\n        onCreate(db);\r\n\r\n    }\r\n}\r\n<\/pre>\n<pre class=\"lang:default decode:true \" title=\"MainActivity.java\">import android.content.ContentValues;\r\nimport android.database.Cursor;\r\nimport android.database.sqlite.SQLiteDatabase;\r\nimport android.os.Bundle;\r\nimport android.support.v7.app.AppCompatActivity;\r\nimport android.util.Log;\r\nimport android.view.View;\r\nimport android.widget.Button;\r\nimport android.widget.EditText;\r\n\r\npublic class MainActivity extends AppCompatActivity implements View.OnClickListener{\r\n\r\n    Button btnAdd, btnRead, btnClear;\r\n    EditText etName, etEmail;\r\n\r\n    DBHelper dbHelper;\r\n\r\n    @Override\r\n    protected void onCreate(Bundle savedInstanceState) {\r\n        super.onCreate(savedInstanceState);\r\n        setContentView(R.layout.activity_main);\r\n\r\n        btnAdd = (Button) findViewById(R.id.btnAdd);\r\n        btnAdd.setOnClickListener(this);\r\n\r\n        btnRead = (Button) findViewById(R.id.btnRead);\r\n        btnRead.setOnClickListener(this);\r\n\r\n        btnClear = (Button) findViewById(R.id.btnClear);\r\n        btnClear.setOnClickListener(this);\r\n\r\n        etName = (EditText) findViewById(R.id.etName);\r\n        etEmail = (EditText) findViewById(R.id.etEmail);\r\n\r\n        dbHelper = new DBHelper(this);\r\n    }\r\n\r\n    @Override\r\n    public void onClick(View v) {\r\n\r\n        String name = etName.getText().toString();\r\n        String email = etEmail.getText().toString();\r\n\r\n        SQLiteDatabase database = dbHelper.getWritableDatabase();\r\n\r\n        ContentValues contentValues = new ContentValues();\r\n\r\n\r\n        switch (v.getId()) {\r\n\r\n            case R.id.btnAdd:\r\n                contentValues.put(DBHelper.KEY_NAME, name);\r\n                contentValues.put(DBHelper.KEY_MAIL, email);\r\n\r\n                database.insert(DBHelper.TABLE_CONTACTS, null, contentValues);\r\n                break;\r\n\r\n            case R.id.btnRead:\r\n                Cursor cursor = database.query(DBHelper.TABLE_CONTACTS, null, null, null, null, null, null);\r\n\r\n                if (cursor.moveToFirst()) {\r\n                    int idIndex = cursor.getColumnIndex(DBHelper.KEY_ID);\r\n                    int nameIndex = cursor.getColumnIndex(DBHelper.KEY_NAME);\r\n                    int emailIndex = cursor.getColumnIndex(DBHelper.KEY_MAIL);\r\n                        do {\r\n                            Log.d(\"mLog\", \"ID = \" + cursor.getInt(idIndex) +\r\n                                            \", name = \" + cursor.getString(nameIndex) +\r\n                                            \", email = \" + cursor.getString(emailIndex));\r\n                        } while (cursor.moveToNext());\r\n                } else\r\n                    Log.d(\"mLog\",\"0 rows\");\r\n\r\n                cursor.close();\r\n                break;\r\n\r\n            case R.id.btnClear:\r\n                database.delete(DBHelper.TABLE_CONTACTS, null, null);\r\n                break;\r\n        }\r\n        dbHelper.close();\r\n    }\r\n}\r\n<\/pre>\n<p>\u0411\u043e\u043b\u044c\u0448\u0435 \u0443\u0440\u043e\u043a\u043e\u0432:<\/p>\n<p>\u0423\u0440\u043e\u043a\u0438 Android Studio: <a href=\"https:\/\/www.youtube.com\/playlist?list=PLyfVjOYzujugap6Rf3ETNKkx4v9ePllNK\" target=\"_blank\" rel=\"noopener noreferrer\">\u0442\u0443\u0442<\/a><br \/>\n\u0418\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b android \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0430: <a href=\"https:\/\/www.youtube.com\/playlist?list=PLyfVjOYzujugEUT-7gYhONqB5Y1xszpCq\" target=\"_blank\" rel=\"noopener noreferrer\">\u0442\u0443\u0442<\/a><br \/>\n\u0414\u0438\u0437\u0430\u0439\u043d android \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439: <a href=\"https:\/\/www.youtube.com\/playlist?list=PLyfVjOYzujugPnav0g4l0GGOPbj_vUf93\" target=\"_blank\" rel=\"noopener noreferrer\">\u0442\u0443\u0442<\/a><br \/>\n\u0423\u0440\u043e\u043a\u0438 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0438\u0433\u0440 \u0434\u043b\u044f android: <a href=\"https:\/\/www.youtube.com\/playlist?list=PLyfVjOYzujuisikez6McGsBtKviTa_lty\" target=\"_blank\" rel=\"noopener noreferrer\">\u0442\u0443\u0442<\/a><br \/>\n\u041e\u0441\u043d\u043e\u0432\u044b \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430 JAVA: <a href=\"https:\/\/www.youtube.com\/playlist?list=PLyfVjOYzujuj1J2z2CgHw1p4PdDwHuRsd\" target=\"_blank\" rel=\"noopener noreferrer\">\u0442\u0443\u0442<\/a><\/p>\n<p><a href=\"\/urok-33-sharedpreferences-sohranenie-dannyh-v-prilozheniyah-uroki-android-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u0423\u0440\u043e\u043a 33. SharedPreferences \u2013 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f\u0445 | \u0423\u0440\u043e\u043a\u0438 Android Studio<\/a><\/p>\n<p><a href=\"\/urok-35-dobavlenie-i-udalenie-strok-v-baze-dannyh-sqlite-v-android\/\">\u0423\u0440\u043e\u043a 35. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0438 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0441\u0442\u0440\u043e\u043a \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 Android<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041d\u0430 \u043f\u0440\u043e\u0448\u043b\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u0441\u0430\u043c\u044b\u0439 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u0441\u043f\u043e\u0441\u043e\u0431 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 -SharedPreferences. \u041d\u043e \u044d\u0442\u043e\u0442 \u0441\u043f\u043e\u0441\u043e\u0431 \u043d\u0435 \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0431\u043e\u043b\u044c\u0448\u043e\u0433\u043e \u043e\u0431\u044a\u0435\u043c\u0430 \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445. \u041d\u0430 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 android. SQLite \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u043e\u0439 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u043e\u0439, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u0435\u0442 \u0430\u0432\u0442\u043e\u043d\u043e\u043c\u043d\u044b\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445, \u043d\u0435 \u043d\u0443\u0436\u0434\u0430\u044e\u0449\u0438\u0435\u0441\u044f \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u0445 \u0438 \u043d\u0435 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0435 \u043a \u0440\u0435\u0441\u0443\u0440\u0441\u0430\u043c, \u043a\u043e\u043c\u043f\u0430\u043a\u0442\u043d\u044b\u0435 \u0438 \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0435. \u0420\u0430\u0431\u043e\u0442\u0430 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3538,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[3,63,65,135,19,14,21,267,404,136,137,5,139,140,4,141,138,132,133,334],"_links":{"self":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/3859"}],"collection":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/comments?post=3859"}],"version-history":[{"count":2,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/3859\/revisions"}],"predecessor-version":[{"id":11306,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/3859\/revisions\/11306"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/media\/3538"}],"wp:attachment":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/media?parent=3859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/categories?post=3859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/tags?post=3859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}