Code:

db = sqlHelper.getReadableDatabase();// открываем подключение к базе данных db.execSQL("INSERT INTO "+ TABLE +" (" + COLUMN_NAME + ", " + COLUMN_YEAR + ") VALUES ("+name.getText()+" , "+year.getText()+");"); userCursor = db.rawQuery("select * from "+ DatabaseHelper.TABLE, null);//Переместили данные в курсор textBD.setText(String.valueOf(userCursor.getCount()));//вывели количество записей String[] from = new String[] { COLUMN_NAME, COLUMN_YEAR}; userAdapter = new SimpleCursorAdapter(MainActivity.this,//Первым параметром выступает контекст, с которым ассоциируется адаптер, например, текущая activity android.R.layout.two_line_list_item, //Второй параметр - ресурс разметки интерфейса, который будет использоваться для отображения результатов выборки userCursor,//Третий параметр - курсор from, //Четвертый параметр - список столбцов из выборки, которые будут отображаться в разметке интерфейса new int[]{android.R.id.text1,//Пятый параметр - элементы внутри ресурса разметки, которые будут отображать значения столбцов из четвертого параметра android.R.id.text2}, // Шестой параметр - флаг 0);// listView.setAdapter(userAdapter); if (userCursor!=null) {//Проверяем пустой ли курсор if (userCursor.moveToFirst()) { while (!userCursor.isAfterLast()) { int i = 0; column_name[i] = userCursor.getString(userCursor.getColumnIndex(COLUMN_NAME));//создали перменную и в конце указали из какой колонки берем данные // двигаемся к следующему значению userCursor.moveToNext();//переходим на след. значение i++; } } } textBD.setText(column_name[1]); userCursor.close(); Toast toast = Toast.makeText(getApplicationContext(), "ОКЕЙ", Toast.LENGTH_SHORT); toast.show(); } });

Mistake:

java.lang.IllegalStateException: attempt to re-open object already-closed object: SQLiteQuery: select * from users at android.database.sqlite.SQLiteClosable.acquireReference (SQLiteClosable.java:55) at android.database.sqlite.SQLiteQuery.fillWindow (SQLiteQuery.java:58) at android.database.sqlite.SQLiteCursor.fillWindow (SQLiteCursor.java:152) at android.database.sqlite.SQLiteCursor.onMove (SQLiteCursor.java:124) at android.database.AbstractCursor.moveToPosition () AbstractCursor.java:214) at android.widget.CursorAdapter.getView (CursorAdapter.java:245) at android.widget.AbsListView.obtainView (AbsListView.java:2344) at android.widget.ListView.measureHeightOfChildren (ListView.java:1270 ) at android.widget.ListView.onMeasure (ListView.java:1182) at android.view.View.measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget .LinearLayout.measureChildBeforeLayout (LinearLayout.java:1436) at android.widget.LinearLayout.measureHorizontal (LinearLayout.j ava: 1083) at android.widget.LinearLayout.onMeasure (LinearLayout.java:615) at android.view.View.measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget.LinearLayout.measureChildBeforeLayout (LinearLayout.java:1436) at android.widget.LinearLayout.measureVertical (LinearLayout.java:722) at android.widget.LinearLayout.onMeasure (LinearLayout.jr.56. .measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget.FrameLayout.onMeasure (FrameLayout.java penet30) at android.support.v7.widget.ContentFrameLayout. onMeasure (ContentFrameLayout.java:135) at android.view.View.measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.support.v7.widget.ActionBarOverlayay.onMean (ActionBarOverlayLayout.javaUE89) at android.view.View.measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget.FrameLayout.onMeasure (FrameLayout.java:430) at android.view.View.measure (View.java:17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget. LinearLayout.measureChildBeforeLayout (LinearLayout.java:1436) at android.widget.LinearLayout.measureVertical (LinearLayout.java:722) at android.widget.LinearLayout. .java: 17430) at android.view.ViewGroup.measureChildWithMargins (ViewGroup.java:5463) at android.widget.FrameLayout.onMeasure (FrameLayout.java:430) at com.android.internal.policy.impl.PhoneWindow $ DecorView. onMeasure (PhoneWindow.java:2560) at android.view.View.measure (View.java:17430) at android.view.ViewRootImpl.performMeasure (ViewRootImpl.java:2001) at android.view.ViewRootImpl.measureHierarchy (ViewRootImpl.java : 1166) at android.view.ViewRootImpl.performTraversals (ViewRootImpl.java:1372) at android.view.ViewRootImpl.doTraversal (ViewRootImpl.java:1054) at android.view.V iewRootImpl $ TraversalRunnable.run (ViewRootImpl.javaCl7779) at andrew.Choreographer $ CallbackRecord.run (Choreographer.java:767) at android.view.Choreographer.doCallbacks (Choreographer.jrome, irodrajraher.jrome, iRohrapher.jun775) at android.view.Choreographer.doCallbacks (Choreographer.jrome, iJr.75, ipl.jr). .doFrame (Choreographer.java:550) at android.view.Choreographer $ FrameDisplayEventReceiver.run (Choreographer.java:753) at android.os.Handler.handleCallback (Handler.java:739) at android.os.Handler.dispatchMessage ( Handler.java:95) at android.os.Looper.loop (Looper.java:135) at android.app.ActivityThread.main (ActivityThread.java:5221) at java.lang.reflect.Method.invoke (Native Method) at java.lang.reflect.Method.invoke (Method.java=72) at com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run (ZygoteInit.java:899) at com.android.internal.os.ZygoteInit.main (ZygoteInit.java:694) 12-01 12:45: 49.871 1516-1799 / system_process w / ActivityManager: Force finishing activity com.example.mysql_legkosuka / .MainActivity

Closed due to the fact that off-topic by user194374, Denis , Grundy , post_zeew , Bald on Dec 13 '16 at 3:56 .

It seems that this question does not correspond to the subject of the site. Those who voted to close it indicated the following reason:

  • “Questions asking for help with debugging (“ why does this code not work? ”) Should include the desired behavior, a specific problem or error, and a minimum code for playing it right in the question . Questions without an explicit description of the problem are useless for other visitors. See How to create minimal, self-sufficient and reproducible example . " - Community spirit, Denis, Grundy, post_zeew, Bald
If the question can be reformulated according to the rules set out in the certificate , edit it .

  • which line is wrong? - pavlofff
  • I do not know, throws only this without specifying a specific location of the code. - Romag

1 answer 1

Attempt to re-open an already closed object.

I think you are closing the connection to the database, and then at some point you are trying to connect to the database again. You need to re-create the connection.

  • The connection does not close at all in the code. - Romag