{"id":4282,"date":"2016-05-12T22:52:32","date_gmt":"2016-05-12T19:52:32","guid":{"rendered":"http:\/\/www.fandroid.info\/?p=4282"},"modified":"2016-06-02T11:58:38","modified_gmt":"2016-06-02T08:58:38","slug":"urok-36-rabota-s-bazoj-dannyh-sqlite-v-android-gruppirovka-sortirovka-vyborka-po-usloviyu","status":"publish","type":"post","link":"https:\/\/www.fandroid.info\/urok-36-rabota-s-bazoj-dannyh-sqlite-v-android-gruppirovka-sortirovka-vyborka-po-usloviyu\/","title":{"rendered":"\u0423\u0440\u043e\u043a 36. \u0420\u0430\u0431\u043e\u0442\u0430 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 Android, \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0430, \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430, \u0432\u044b\u0431\u043e\u0440\u043a\u0430 \u043f\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u044e"},"content":{"rendered":"<p><iframe loading=\"lazy\" width=\"700\" height=\"394\" src=\"https:\/\/www.youtube.com\/embed\/Po7USpYLYPc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>\u041d\u0430 \u044d\u0442\u043e\u043c \u0443\u0440\u043e\u043a\u0435 \u043f\u0440\u043e\u0434\u043e\u0436\u0438\u043c \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 Android. \u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435, \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u043f\u043e\u043a\u0430\u0436\u0435\u043c, \u043a\u0430\u043a \u0434\u0435\u043b\u0430\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443, \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0443 \u0438 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043c\u0435\u0442\u043e\u0434\u0430 query \u0441 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u043c\u0438 columns, selection, selectionArgs, groupBy, having, orderBy.<\/p>\n<pre class=\"lang:default decode:true \" title=\"activity_main\">&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;TextView\r\n        android:layout_width=\"fill_parent\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:text=\"\u0421\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a \u0441\u0442\u0440\u0430\u043d\"\r\n        android:textSize=\"14sp\"\r\n        android:gravity=\"center_horizontal\"\r\n        android:layout_marginBottom=\"5dp\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n    &lt;\/TextView&gt;\r\n    &lt;Button\r\n        android:id=\"@+id\/btnAll\"\r\n        android:layout_width=\"wrap_content\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:text=\"\u0412\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n    &lt;\/Button&gt;\r\n    &lt;LinearLayout\r\n        android:id=\"@+id\/linearLayout1\"\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnFunc\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"\u0424\u0443\u043d\u043a\u0446\u0438\u044f\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;EditText\r\n            android:id=\"@+id\/etFunc\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:layout_weight=\"1\"&gt;\r\n            &lt;requestFocus&gt;\r\n            &lt;\/requestFocus&gt;\r\n        &lt;\/EditText&gt;\r\n    &lt;\/LinearLayout&gt;\r\n    &lt;LinearLayout\r\n        android:id=\"@+id\/linearLayout2\"\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnPeople\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"\u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 &gt;\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;EditText\r\n            android:id=\"@+id\/etPeople\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:layout_weight=\"1\"\r\n            android:inputType=\"number\"&gt;\r\n        &lt;\/EditText&gt;\r\n    &lt;\/LinearLayout&gt;\r\n    &lt;Button\r\n        android:id=\"@+id\/btnGroup\"\r\n        android:layout_width=\"wrap_content\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:text=\"\u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n    &lt;\/Button&gt;\r\n    &lt;LinearLayout\r\n        android:id=\"@+id\/linearLayout4\"\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnHaving\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"\u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443 &gt;\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;EditText\r\n            android:id=\"@+id\/etRegionPeople\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:layout_weight=\"1\"\r\n            android:inputType=\"number\"&gt;\r\n        &lt;\/EditText&gt;\r\n    &lt;\/LinearLayout&gt;\r\n    &lt;LinearLayout\r\n        android:id=\"@+id\/linearLayout3\"\r\n        android:layout_width=\"match_parent\"\r\n        android:layout_height=\"wrap_content\"\r\n        android:layout_marginTop=\"5dp\"&gt;\r\n        &lt;Button\r\n            android:id=\"@+id\/btnSort\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"\r\n            android:text=\"\u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430\"&gt;\r\n        &lt;\/Button&gt;\r\n        &lt;RadioGroup\r\n            android:id=\"@+id\/rgSort\"\r\n            android:layout_width=\"wrap_content\"\r\n            android:layout_height=\"wrap_content\"&gt;\r\n            &lt;RadioButton\r\n                android:id=\"@+id\/rName\"\r\n                android:layout_width=\"wrap_content\"\r\n                android:layout_height=\"wrap_content\"\r\n                android:checked=\"true\"\r\n                android:text=\"\u041d\u0430\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0435\"&gt;\r\n            &lt;\/RadioButton&gt;\r\n            &lt;RadioButton\r\n                android:id=\"@+id\/rPeople\"\r\n                android:layout_width=\"wrap_content\"\r\n                android:layout_height=\"wrap_content\"\r\n                android:text=\"\u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435\"&gt;\r\n            &lt;\/RadioButton&gt;\r\n            &lt;RadioButton\r\n                android:id=\"@+id\/rRegion\"\r\n                android:layout_width=\"wrap_content\"\r\n                android:layout_height=\"wrap_content\"\r\n                android:text=\"\u0420\u0435\u0433\u0438\u043e\u043d\"&gt;\r\n            &lt;\/RadioButton&gt;\r\n        &lt;\/RadioGroup&gt;\r\n    &lt;\/LinearLayout&gt;\r\n&lt;\/LinearLayout&gt;<\/pre>\n<pre class=\"lang:default decode:true \" title=\"MainActivity.java\">package ...\r\n\r\nimport android.content.ContentValues;\r\nimport android.content.Context;\r\nimport android.database.Cursor;\r\nimport android.database.sqlite.SQLiteDatabase;\r\nimport android.database.sqlite.SQLiteOpenHelper;\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\nimport android.widget.RadioGroup;\r\n\r\npublic class MainActivity extends AppCompatActivity implements View.OnClickListener {\r\n\r\n    final String LOG_TAG = \"myLogs\";\r\n\r\n    String name[] = { \"\u041a\u0438\u0442\u0430\u0439\", \"\u0421\u0428\u0410\", \"\u0411\u0440\u0430\u0437\u0438\u043b\u0438\u044f\", \"\u0420\u043e\u0441\u0441\u0438\u044f\", \"\u042f\u043f\u043e\u043d\u0438\u044f\",\r\n            \"\u0413\u0435\u0440\u043c\u0430\u043d\u0438\u044f\", \"\u0415\u0433\u0438\u043f\u0435\u0442\", \"\u0418\u0442\u0430\u043b\u0438\u044f\", \"\u0424\u0440\u0430\u043d\u0446\u0438\u044f\", \"\u041a\u0430\u043d\u0430\u0434\u0430\" };\r\n    int people[] = { 1400, 311, 195, 142, 128, 82, 80, 60, 66, 35 };\r\n    String region[] = { \"\u0410\u0437\u0438\u044f\", \"\u0410\u043c\u0435\u0440\u0438\u043a\u0430\", \"\u0410\u043c\u0435\u0440\u0438\u043a\u0430\", \"\u0415\u0432\u0440\u043e\u043f\u0430\", \"\u0410\u0437\u0438\u044f\",\r\n            \"\u0415\u0432\u0440\u043e\u043f\u0430\", \"\u0410\u0444\u0440\u0438\u043a\u0430\", \"\u0415\u0432\u0440\u043e\u043f\u0430\", \"\u0415\u0432\u0440\u043e\u043f\u0430\", \"\u0410\u043c\u0435\u0440\u0438\u043a\u0430\" };\r\n\r\n    Button btnAll, btnFunc, btnPeople, btnSort, btnGroup, btnHaving;\r\n    EditText etFunc, etPeople, etRegionPeople;\r\n    RadioGroup rgSort;\r\n\r\n    DBHelper dbHelper;\r\n    SQLiteDatabase db;\r\n\r\n\r\n    public void onCreate(Bundle savedInstanceState) {\r\n        super.onCreate(savedInstanceState);\r\n        setContentView(R.layout.activity_main);\r\n\r\n        btnAll = (Button) findViewById(R.id.btnAll);\r\n        btnAll.setOnClickListener(this);\r\n\r\n        btnFunc = (Button) findViewById(R.id.btnFunc);\r\n        btnFunc.setOnClickListener(this);\r\n\r\n        btnPeople = (Button) findViewById(R.id.btnPeople);\r\n        btnPeople.setOnClickListener(this);\r\n\r\n        btnSort = (Button) findViewById(R.id.btnSort);\r\n        btnSort.setOnClickListener(this);\r\n\r\n        btnGroup = (Button) findViewById(R.id.btnGroup);\r\n        btnGroup.setOnClickListener(this);\r\n\r\n        btnHaving = (Button) findViewById(R.id.btnHaving);\r\n        btnHaving.setOnClickListener(this);\r\n\r\n        etFunc = (EditText) findViewById(R.id.etFunc);\r\n        etPeople = (EditText) findViewById(R.id.etPeople);\r\n        etRegionPeople = (EditText) findViewById(R.id.etRegionPeople);\r\n\r\n        rgSort = (RadioGroup) findViewById(R.id.rgSort);\r\n\r\n        dbHelper = new DBHelper(this);\r\n        \/\/ \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u043a \u0431\u0430\u0437\u0435\r\n        db = dbHelper.getWritableDatabase();\r\n\r\n        \/\/ \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0438\u044f \u0437\u0430\u043f\u0438\u0441\u0435\u0439\r\n        Cursor c = db.query(\"mytable\", null, null, null, null, null, null);\r\n        if (c.getCount() == 0) {\r\n            ContentValues cv = new ContentValues();\r\n            \/\/ \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443\r\n            for (int i = 0; i &lt; 10; i++) {\r\n                cv.put(\"name\", name[i]);\r\n                cv.put(\"people\", people[i]);\r\n                cv.put(\"region\", region[i]);\r\n                Log.d(LOG_TAG, \"id = \" + db.insert(\"mytable\", null, cv));\r\n            }\r\n        }\r\n        c.close();\r\n        dbHelper.close();\r\n        \/\/ \u044d\u043c\u0443\u043b\u0438\u0440\u0443\u0435\u043c \u043d\u0430\u0436\u0430\u0442\u0438\u0435 \u043a\u043d\u043e\u043f\u043a\u0438 btnAll\r\n        onClick(btnAll);\r\n\r\n    }\r\n\r\n    public void onClick(View v) {\r\n\r\n        \/\/ \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u043a \u0431\u0430\u0437\u0435\r\n        db = dbHelper.getWritableDatabase();\r\n\r\n        \/\/ \u0434\u0430\u043d\u043d\u044b\u0435 \u0441 \u044d\u043a\u0440\u0430\u043d\u0430\r\n        String sFunc = etFunc.getText().toString();\r\n        String sPeople = etPeople.getText().toString();\r\n        String sRegionPeople = etRegionPeople.getText().toString();\r\n\r\n        \/\/ \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u0434\u043b\u044f query\r\n        String[] columns = null;\r\n        String selection = null;\r\n        String[] selectionArgs = null;\r\n        String groupBy = null;\r\n        String having = null;\r\n        String orderBy = null;\r\n\r\n        \/\/ \u043a\u0443\u0440\u0441\u043e\u0440\r\n        Cursor c = null;\r\n\r\n        \/\/ \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u043c \u043d\u0430\u0436\u0430\u0442\u0443\u044e \u043a\u043d\u043e\u043f\u043a\u0443\r\n        switch (v.getId()) {\r\n            \/\/ \u0412\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438\r\n            case R.id.btnAll:\r\n                Log.d(LOG_TAG, \"--- \u0412\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 ---\");\r\n                c = db.query(\"mytable\", null, null, null, null, null, null);\r\n                break;\r\n            \/\/ \u0424\u0443\u043d\u043a\u0446\u0438\u044f\r\n            case R.id.btnFunc:\r\n                Log.d(LOG_TAG, \"--- \u0424\u0443\u043d\u043a\u0446\u0438\u044f \" + sFunc + \" ---\");\r\n                columns = new String[] { sFunc };\r\n                c = db.query(\"mytable\", columns, null, null, null, null, null);\r\n                break;\r\n            \/\/ \u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u0431\u043e\u043b\u044c\u0448\u0435, \u0447\u0435\u043c\r\n            case R.id.btnPeople:\r\n                Log.d(LOG_TAG, \"--- \u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u0431\u043e\u043b\u044c\u0448\u0435 \" + sPeople + \" ---\");\r\n                selection = \"people &gt; ?\";\r\n                selectionArgs = new String[] { sPeople };\r\n                c = db.query(\"mytable\", null, selection, selectionArgs, null, null,\r\n                        null);\r\n                break;\r\n            \/\/ \u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443\r\n            case R.id.btnGroup:\r\n                Log.d(LOG_TAG, \"--- \u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443 ---\");\r\n                columns = new String[] { \"region\", \"sum(people) as people\" };\r\n                groupBy = \"region\";\r\n                c = db.query(\"mytable\", columns, null, null, groupBy, null, null);\r\n                break;\r\n            \/\/ \u041d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443 \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c\r\n            case R.id.btnHaving:\r\n                Log.d(LOG_TAG, \"--- \u0420\u0435\u0433\u0438\u043e\u043d\u044b \u0441 \u043d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435\u043c \u0431\u043e\u043b\u044c\u0448\u0435 \" + sRegionPeople\r\n                        + \" ---\");\r\n                columns = new String[] { \"region\", \"sum(people) as people\" };\r\n                groupBy = \"region\";\r\n                having = \"sum(people) &gt; \" + sRegionPeople;\r\n                c = db.query(\"mytable\", columns, null, null, groupBy, having, null);\r\n                break;\r\n            \/\/ \u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430\r\n            case R.id.btnSort:\r\n                \/\/ \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u043f\u043e\r\n                switch (rgSort.getCheckedRadioButtonId()) {\r\n                    \/\/ \u043d\u0430\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u0435\r\n                    case R.id.rName:\r\n                        Log.d(LOG_TAG, \"--- \u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u043f\u043e \u043d\u0430\u0438\u043c\u0435\u043d\u043e\u0432\u0430\u043d\u0438\u044e ---\");\r\n                        orderBy = \"name\";\r\n                        break;\r\n                    \/\/ \u043d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u0435\r\n                    case R.id.rPeople:\r\n                        Log.d(LOG_TAG, \"--- \u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u043f\u043e \u043d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u044e ---\");\r\n                        orderBy = \"people\";\r\n                        break;\r\n                    \/\/ \u0440\u0435\u0433\u0438\u043e\u043d\r\n                    case R.id.rRegion:\r\n                        Log.d(LOG_TAG, \"--- \u0421\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0430 \u043f\u043e \u0440\u0435\u0433\u0438\u043e\u043d\u0443 ---\");\r\n                        orderBy = \"region\";\r\n                        break;\r\n                }\r\n                c = db.query(\"mytable\", null, null, null, null, null, orderBy);\r\n                break;\r\n        }\r\n\r\n        if (c != null) {\r\n            if (c.moveToFirst()) {\r\n                String str;\r\n                do {\r\n                    str = \"\";\r\n                    for (String cn : c.getColumnNames()) {\r\n                        str = str.concat(cn + \" = \"\r\n                                + c.getString(c.getColumnIndex(cn)) + \"; \");\r\n                    }\r\n                    Log.d(LOG_TAG, str);\r\n\r\n                } while (c.moveToNext());\r\n            }\r\n            c.close();\r\n        } else\r\n            Log.d(LOG_TAG, \"Cursor is null\");\r\n\r\n        dbHelper.close();\r\n    }\r\n\r\n    class DBHelper extends SQLiteOpenHelper {\r\n\r\n        public DBHelper(Context context) {\r\n            \/\/ \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0442\u043e\u0440 \u0441\u0443\u043f\u0435\u0440\u043a\u043b\u0430\u0441\u0441\u0430\r\n            super(context, \"myDB\", null, 1);\r\n        }\r\n\r\n        public void onCreate(SQLiteDatabase db) {\r\n            Log.d(LOG_TAG, \"--- onCreate database ---\");\r\n            \/\/ \u0441\u043e\u0437\u0434\u0430\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0441 \u043f\u043e\u043b\u044f\u043c\u0438\r\n            db.execSQL(\"create table mytable (\"\r\n                    + \"id integer primary key autoincrement,\" + \"name text,\"\r\n                    + \"people integer,\" + \"region text\" + \");\");\r\n        }\r\n\r\n        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r\n\r\n        }\r\n    }\r\n\r\n}\r\n<\/pre>\n<hr \/>\n<p style=\"text-align: center;\"><a href=\"\/urok-35-dobavlenie-i-udalenie-strok-v-baze-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-37-rabota-s-bazoj-dannyh-sqlite-v-android-zaprosy-iz-svyazannyh-tablits\/\">\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 \u043f\u0440\u043e\u0434\u043e\u0436\u0438\u043c \u0440\u0430\u0431\u043e\u0442\u0443 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0432 Android. \u0421\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435, \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u043f\u043e\u043a\u0430\u0436\u0435\u043c, \u043a\u0430\u043a \u0434\u0435\u043b\u0430\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0443, \u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u043a\u0443 \u0438 \u0432\u044b\u0431\u043e\u0440\u043a\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 SQLite \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043c\u0435\u0442\u043e\u0434\u0430 query \u0441 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430\u043c\u0438 columns, selection, selectionArgs, groupBy, having, orderBy. &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;TextView android:layout_width=&#187;fill_parent&#187; android:layout_height=&#187;wrap_content&#187; android:text=&#187;\u0421\u043f\u0440\u0430\u0432\u043e\u0447\u043d\u0438\u043a \u0441\u0442\u0440\u0430\u043d&#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,142,267,136,5],"_links":{"self":[{"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4282"}],"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=4282"}],"version-history":[{"count":3,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4282\/revisions"}],"predecessor-version":[{"id":4413,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/posts\/4282\/revisions\/4413"}],"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=4282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/categories?post=4282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fandroid.info\/wp-json\/wp\/v2\/tags?post=4282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}