{"id":4268,"date":"2016-05-07T16:50:44","date_gmt":"2016-05-07T13:50:44","guid":{"rendered":"http:\/\/www.fandroid.info\/?p=4268"},"modified":"2016-05-12T22:54:24","modified_gmt":"2016-05-12T19:54:24","slug":"urok-35-dobavlenie-i-udalenie-strok-v-baze-dannyh-sqlite-v-android","status":"publish","type":"post","link":"https:\/\/www.fandroid.info\/urok-35-dobavlenie-i-udalenie-strok-v-baze-dannyh-sqlite-v-android\/","title":{"rendered":"\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"},"content":{"rendered":"<p>\u041d\u0430 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c , \u043a\u0430\u043a \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c \u0438 \u0443\u0434\u0430\u043b\u044f\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u043c\u0435\u0442\u043e\u0434\u0430\u043c\u0438 update \u0438 delete. \u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0439 \u043a\u043e\u0434 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u043f\u043e\u0434 \u0432\u0438\u0434\u0435\u043e:<\/p>\n<p><iframe loading=\"lazy\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/TpYZFKGFlHQ?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    &lt;EditText\r\n        android:id=\"@+id\/etId\"\r\n        android:hint=\"Id\"\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\/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\/btnUpd\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"Update\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnDel\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"Delete\"&gt;\r\n        &lt;\/Button&gt;\r\n    &lt;\/LinearLayout&gt;\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\">package ...\r\n\r\nimport 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\">package ...\r\n\r\nimport 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, btnUpd, btnDel;\r\n    EditText etName, etEmail, etId;\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        btnUpd = (Button) findViewById(R.id.btnUpd);\r\n        btnUpd.setOnClickListener(this);\r\n\r\n        btnDel = (Button) findViewById(R.id.btnDel);\r\n        btnDel.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        etId = (EditText) findViewById(R.id.etId);\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        String id = etId.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            case R.id.btnUpd:\r\n                if (id.equalsIgnoreCase(\"\")){\r\n                    break;\r\n                }\r\n                contentValues.put(DBHelper.KEY_MAIL, email);\r\n                contentValues.put(DBHelper.KEY_NAME, name);\r\n                int updCount = database.update(DBHelper.TABLE_CONTACTS, contentValues, DBHelper.KEY_ID + \"= ?\", new String[] {id});\r\n\r\n                Log.d(\"mLog\", \"updates rows count = \" + updCount);\r\n\r\n            case R.id.btnDel:\r\n                if (id.equalsIgnoreCase(\"\")){\r\n                    break;\r\n                }\r\n                int delCount = database.delete(DBHelper.TABLE_CONTACTS, DBHelper.KEY_ID + \"=\" + id, null);\r\n\r\n                Log.d(\"mLog\", \"deleted rows count = \" + delCount);\r\n\r\n        }\r\n        dbHelper.close();\r\n    }\r\n}\r\n<\/pre>\n<hr \/>\n<p style=\"text-align: center;\"><a href=\"\/urok-34-rabota-s-bazami-dannyh-sqlite-v-android\/\" target=\"_blank\">&lt;&lt;\u041f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0439 \u0443\u0440\u043e\u043a <\/a>\u00a0 \u00a0 <a href=\"\/urok-36-rabota-s-bazoj-dannyh-sqlite-v-android-gruppirovka-sortirovka-vyborka-po-usloviyu\/\" target=\"_blank\">\u0421\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0443\u0440\u043e\u043a&gt;&gt;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041d\u0430 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c , \u043a\u0430\u043a \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0442\u044c \u0438 \u0443\u0434\u0430\u043b\u044f\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u043c\u0435\u0442\u043e\u0434\u0430\u043c\u0438 update \u0438 delete. \u0418\u0441\u0445\u043e\u0434\u043d\u044b\u0439 \u043a\u043e\u0434 \u043f\u0440\u0438\u043c\u0435\u0440\u0430 \u043f\u043e\u0434 \u0432\u0438\u0434\u0435\u043e: &lt;?xml version=&#187;1.0&#8243; encoding=&#187;utf-8&#8243;?&gt; &lt;LinearLayout xmlns:android=&#187;http:\/\/schemas.android.com\/apk\/res\/android&#187; android:layout_width=&#187;fill_parent&#187; android:layout_height=&#187;fill_parent&#187; android:orientation=&#187;vertical&#187;&gt; &lt;EditText android:id=&#187;@+id\/etId&#187; android:hint=&#187;Id&#187; android:layout_width=&#187;match_parent&#187; android:layout_height=&#187;wrap_content&#187;&gt; &lt;\/EditText&gt; &lt;EditText android:id=&#187;@+id\/etName&#187; android:hint=&#187;Name&#187; android:layout_width=&#187;match_parent&#187; android:layout_height=&#187;wrap_content&#187;&gt; &lt;\/EditText&gt; &lt;EditText android:id=&#187;@+id\/etEmail&#187; android:hint=&#187;Email&#187; android:layout_width=&#187;match_parent&#187; android:layout_height=&#187;wrap_content&#187;&gt; &lt;\/EditText&gt; &lt;LinearLayout android:layout_width=&#187;match_parent&#187; android:layout_height=&#187;wrap_content&#187;&gt; &lt;Button android:id=&#187;@+id\/btnUpd&#187; android:layout_width=&#187;wrap_content&#187; [&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,19,14,267,136,137,5,140,4,141,132,133],"_links":{"self":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4268"}],"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=4268"}],"version-history":[{"count":3,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4268\/revisions"}],"predecessor-version":[{"id":4288,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4268\/revisions\/4288"}],"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=4268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/categories?post=4268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/tags?post=4268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}