마스터Q&A 안드로이드는 안드로이드 개발자들의 질문과 답변을 위한 지식 커뮤니티 사이트입니다. 안드로이드펍에서 운영하고 있습니다. [사용법, 운영진]

sqlite에서 select문 질문이요 ㅠ [closed]

0 추천
txtlogin.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                String sql = "select userpass from USER where userid = '" + editid.getText().toString() + "';";
                Cursor result = database.rawQuery(sql, null);
                result.moveToFirst();
                while (!result.isAfterLast()) {
                    userpass = result.getString(0);
                    result.moveToNext();
                }
                result.close();

                Toast.makeText(StartPage.this, userpass, Toast.LENGTH_LONG).show();

            }
        });

 

text를 클릭하면 sqlite에서 정보를 빼오는건데;

일단 정보값은 다들어가있구요... 쿼리문은 맞는거 같은데;;

자꾸 커서쪽에서 오류가 나네요;;

 

05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime: FATAL EXCEPTION: main
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime: Process: com.younggue_kim.myhospital, PID: 24531
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime: java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase: /data/data/com.younggue_kim.myhospital/databases/hospital
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:55)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1450)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1393)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at com.younggue_kim.myhospital.StartPage$1.onClick(StartPage.java:65)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.view.View.performClick(View.java:5242)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.widget.TextView.performClick(TextView.java:10530)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.view.View$PerformClick.run(View.java:21185)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.os.Handler.handleCallback(Handler.java:739)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.os.Handler.dispatchMessage(Handler.java:95)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.os.Looper.loop(Looper.java:145)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at android.app.ActivityThread.main(ActivityThread.java:6872)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at java.lang.reflect.Method.invoke(Native Method)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at java.lang.reflect.Method.invoke(Method.java:372)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1404)
05-16 23:06:05.901 24531-24531/com.younggue_kim.myhospital E/AndroidRuntime:     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1199)
05

 

도저히 봐도 모르겠네요 ㅠㅠ

도움좀 주세요 ㅠ
질문을 종료한 이유: 해결
익명사용자 님이 2016년 5월 16일 질문
2016년 5월 16일 closed
...