generateSearchQuery "And (" + mDatabaseHelper.STATION_TITLE + LIKE ?"And (" + mDatabaseHelper.STATION_TITLE + LIKE ? ) +The box, CARL!

Adapter operating code:public Cursor getOrderData() { SQLiteDatabase database = dbHelper.getWritableDatabase(); String buildSQL = "SELECT * FROM elf_Orders ORDER BY _id"; return database.rawQuery(buildSQL, null); } public class OrderAdapter extends CursorAdapter { private LayoutInflater inflater; private class ViewHolder { TextView name; } public OrderAdapter(Context context, Cursor c, int flags) { super(context, c, flags); this.inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE); } private int getItemViewType(Cursor cursor) { String type = cursor.getString(cursor.getColumnIndex("State")); if (type.equals("1")) { return 0; } else { return 1; } } @Override public int getItemViewType(int position) { Cursor cursor = (Cursor) getItem(position); return getItemViewType(cursor); } @Override public int getViewTypeCount() { return 2; } @Override public void bindView(View view, Context context, Cursor cursor) { ViewHolder holder = (ViewHolder) view.getTag(); holder.name.setText(cursor.getString(cursor.getColumnIndex("mitm_Name"))); } @Override public View newView(Context context, Cursor cursor, ViewGroup parent) { ViewHolder holder = new ViewHolder(); View v = null; if (cursor.getInt(cursor.getColumnIndex("State")) == 0) { v = inflater.inflate(R.layout.cellordername, parent, false); holder.name = (TextView) v.findViewById(R.id.txtmitmname); } else { v = inflater.inflate(R.layout.cellorder, parent, false); holder.name = (TextView) v.findViewById(R.id.txtmitmname); } v.setTag(holder); return v; } } Thank you very much!

In order to record data from the 2nd pillars of the database in one list:(1) Develop a caste layout of your line, which will position, for example, on the left, some data on the right;(2) Implement a courseor that will contain information from the two pillars of your OBD;(3) Implement the SimpleCursorAdapter itself, which will fill in your view, and in order to accommodate the information from the courseor to layout make such a comparison:String[] from = new String[] { DB.COLUMN_TEXT1, DB.COLUMN_TEXT2 }; int[] to = new int[] { R.id.text1, R.id.text2 };

You don't really have a third line. You can just make sure you get the id out.You have to do it before the first iterary. cursor.moveToFirst()

You hit the google. https://www.google.ru/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=android%20cursoradapter%20onitemclick Go first. https://stackoverflow.com/questions/20581460/cursoradapter-onitemclick-of-listview Copy your code:_articleList.setOnItemClickListener(new OnItemClickListener() { public void onItemClick(AdapterView<?> parent, View view, int position, long arg3) { Intent intent = new Intent(MainActivity.this, SecondActivity.class); startActivity(intent); } });

You get a message: column '_id' does not exist - this means that a column with the name (_id) has not been established in the OBD system, while it is absolutely necessary for standard Android classes interacting with SQLite (in particular class of class Cursorand contains ID records. (Libo in sample given to class Cursor No columnIn establishing the table, add this column in each table:CREATE TABLE sometable (_id INTEGER PRIMARY KEY AUTOINCREMENT, .. ) If there's a column for ID with another name, delete it.If the name column _id in OBD presence, it should be included in the sample of OBD

Only the use of the database as a data repository will be indispensable for this task. Only part of the data can be requested. Also, with large amounts of data, use of the courseor or various ORMs that provide LazyListIt'll avoid OOM mistakes. In the future, the use of the bd will facilitate the downloading of any detailed information on the record - it will be sufficient to transfer the id records to the next Activity/Fragment and to make a sample on this id. Well, plus are a lot of ORM that will simplify and speed up development.

view - submissions, very good work, updated on their own when the necessary data are recorded in the main tablesMake the dialogue list on the window. view on the screen of of a particular dialogue viewYou can even be temporary.

If you need to update ListView, you create a new courseor, you get the data. SimpleCursorAdapter has a method to update the courseor - scAdapter.changeAdapter(Transital courseosphere); then notify the adapter scAdapter.notifyDataSetChanged();

1. Use CursorLoader.2. You can just update and whip the cadets.private Db mDbAdapter; private Cursor mCursor; private SimpleCursorAdapter mCursorAd; ..................................... //After removing the item from the DB, use this ..................................... mCursor = mDbAdapter.getAllItems(); mCursorAd.swapCursor(mCursor);

Method getSupportLoaderManager() only in class http://developer.android.com/reference/android/support/v4/app/FragmentActivity.html and his heirs. To call him, you need to bring Activity to this type.

java.lang.ClassCastException: android.content.ContentResolver$CursorWrapperInner cannot be cast to android.content.ContentResolverTranslation: java.lang.ClassCastException: android.content.ContentResolver$CursorWrapperInner Not applicable android.content.ContentResolver What kind of mistake?((ContentResolver)cursor3).delete(Contract.Favorite.CONTENT_URI,Contract.Favorite._ID + "=" + id, null); What makes you think Cursor cursor3 may be given to the type ContentResolver? Where did you see one inherited from another?

There's no point in a click listener. position♪ long idwhich contains the record identifier Cursor (precision field value) _ID)Accordingly, it is necessary to extract the parameters of this recording. id

/users/1012/lucky_spirit - I understand it works as: query We're signing:cursor.setNotificationUri(getContext().getContentResolver(), CIRCLE_CONTENT_URI); Method delete♪ insert♪ update Notify:getContext().getContentResolver().notifyChange(resultUri, null);

I found an answer to the next subject. Column _id must be included in the sample of the courseor.But you don't have to put her on the listview.

You need to update the OBD data in some way when you get back to the activate. It's not gonna change itself.In the real world, this is usually done:Data from the OBD are collected by a library (Room, for example). Retrieval in RxJava or LiveData, which automatically (if necessary) re-requires OBD data if something has been changed to the OBD system (changes trace libraries (Room)).However, p.1 will be performed only if the activists have not been destroyed or the request for OBD is initially made of onResumefor example, which, of course, is superfluous.Architectural libraries for MVP (MVM etc) are used to avoid the problem described above. At that time, the request for OBD is in the presenters, which are in the right manner already focused on life cycle events and correctly re-examine the data at the right time.However, in your case, since you don't use any of the above-mentioned libraries and approaches, you need to do everything manually. For example:Start the second activate through startActivityForResult()Before closing the second activate the results through setResult()She' get her method back to the first act. onActivityResult() - in it, repeat the request for OBD and update the data on the screen.

You can only get the size of the pictures in two ways. 1. send a request to the server from where you download this picture, "let me the size of that picture." To get the picture size only after the image is downloaded.Yes, I agree, and in my case, I could only find the size after loading.Look how this works in viber, skype, whatsapp, or others.I mean, maybe RecyclerView + PagedListAdapter. It's true that she was in operation. In general, it helps in my case. Since this connection or pictures are fully stored at the time of the show, which means their size is known and a proportional placeholder can be placed, or the view just doesn't appear until the image is downloaded. Of course, the first option should work more often than it does.

The data are read in a redefined method onLoadFinished. In order to correct the error, the listener must be moved to displayPoem. public void displayPoem(Cursor cursor) { if (!cursor.moveToFirst()) { finish(); } String title = cursor.getString(cursor.getColumnIndexOrThrow(PoemsContract.Poems.COLUMN_TITLE)); tv_Title.setText(title); String poem = cursor.getString(cursor.getColumnIndexOrThrow(PoemsContract.Poems.COLUMN_POEM)); tv_Poem.setText(poem); String years = cursor.getString(cursor.getColumnIndexOrThrow(PoemsContract.Poems.COLUMN_YEARS)); tv_Years.setText(years); String favorite = cursor.getString(cursor.getColumnIndexOrThrow(PoemsContract.Poems.COLUMN_FAVORITE)); if (favorite.equals("0")) { iv_heart.setImageResource(R.drawable.heart); } else { iv_heart.setImageResource(R.drawable.heart_ok); } iv_heart.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { if (favorite.equals("0")) { ContentValues contentValues = new ContentValues(); contentValues.put(PoemsContract.Poems.COLUMN_FAVORITE, "1"); getContentResolver().update(ContentUris.withAppendedId(PoemsContract.Poems.URI, poemId), contentValues, null, null); Toast.makeText(getApplicationContext(), "Добавлено в избранное", Toast.LENGTH_SHORT).show(); iv_heart.setImageResource(R.drawable.heart_ok); } else { ContentValues contentValues = new ContentValues(); contentValues.put(PoemsContract.Poems.COLUMN_FAVORITE, "0"); getContentResolver().update(ContentUris.withAppendedId(PoemsContract.Poems.URI, poemId), contentValues, null, null); Toast.makeText(getApplicationContext(), "Удалено из избранного", Toast.LENGTH_SHORT).show(); iv_heart.setImageResource(R.drawable.heart); } } });

You close Cursor, and then you make a request with him.c.close(); c = db.query("mytable", null, null, null, null, null, null); Method https://developer.android.com/reference/android/database/Cursor.html#close() Closes the courseor by freeing all its resources and renders it completely null and void. Create a new one. Cursor♪

Mistake java.lang.IllegalArgumentException: column '_id' does not exist Tells us that the Android application database must contain a unique key column with a name. _id (not id, ID, _ID or otherwise) and attribution INTEGER PRIMARY KEY AUTOINCREMENT for correcting classes related to SQLite.public void onCreate (SQLiteDatabase db){ db.execSQL("create table mytable (" + "_id integer primary key autoincrement," + "date text," + "note text"+");"); } Same column _id must be included in the cadet sample.Attention: To change the structure of the OBD system, it is not easy to correct the name of the column because the OBD is created once at the start and only if the OBD file is not on the device, and its structure can be changed only through the method onUpgrade() Class SQLiteOpenHelper with an upgrade of the OBD version, but the test application is simple enough Delete That's it. Annex Testing devicesthe database will then be removed together and the next OBD launch will be redesigned with corrections.