PDA

View Full Version : خواندن اطلاعات از دیتابیس



CRbreeze
دوشنبه 03 اسفند 1394, 17:49 عصر
سلام دوستان ازقبل بخاطر وقتی میذارید سپاسگذارم

من یک کدی نوشتم که یک دیتابیس موجود در برنامه شامل چندین جدول است به این جداول مقادیری دادم .... حالا میخوام از این جداول اطلاعاتش رو بخونم .... طبق کد زیر ... مثلا من میخوام از جدول stud تمام اطلاعاتش رو بگیرم ... که قبلا 12 ردیف اطلاعات ادد شده بوده ... از کاربر هم میخوام کدی بنویسه که تمام اطلاعات رو بهش بده ... بعد با خروجی گرفتن ببینم کاربر درست کد نوشته یا نه؟ (هدف اصلی برنامه قابلیت کوپیز گرفت از کاربره) ولی مشکل اینجاس که 12 ردیف اطلاعات رو میخونه و در آخر وارد catch میشه و برنامه خاتمه پیدا میکنه .... میخواستم ببینم ایراد کد من کجاست؟

public boolean check1(String data){ boolean result = false;
try{
SQLiteDatabase mydb=openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE,null);
Cursor allrows = mydb.rawQuery("select * from stud", null);
Cursor rows = mydb.rawQuery(data,null);
if(allrows.getCount() != rows.getCount()){
return result;
}else {

String[] myRes;
String[] karbarRes;
int i = 0;
int j = 0;
int counter = 0;
myRes = new String[allrows.getCount()];
karbarRes = new String[rows.getCount()];
if(allrows.moveToFirst()){

do {
myRes[i] = allrows.getString(0);
i++;
}while(allrows.moveToNext());

}
if(rows.moveToFirst()){

while(rows.moveToNext()){
karbarRes[j] = rows.getString(0);
j++;
}

}

for(int t=0;t<myRes.length;t++){
flag = "true";
for(int k=0;k<karbarRes.length;k++) {
if (myRes[t].equals(karbarRes[k]))
counter++;
}
}

if(counter==allrows.getCount()){
result = true;
}
}
mydb.close();

}catch(Exception e){
Toast.makeText(getApplicationContext(), "Error encountered while deleting.", Toast.LENGTH_LONG).show();}
return result;
}

msroid
دوشنبه 03 اسفند 1394, 19:36 عصر
سلام

من الان نمیتونم تشخیص بدم که مشکل کد کجاست اما بهترین کاری که میتونید انجام بدین اینه که توی خط 10 یه breakpoint بذارین و برنامه رو دیباگ کنین. اگر وارد else بشه خط به خط جلو برین ببینین تا کجا درست کار میکنه و وقتی وارد قسمت catch میشه داخل e چه مقداری وجود داره.

یا اینکه قبل از دیباگ کردن هم میتونین توی خود بدنه catch مسیج مربوط به e رو داخل Log بذارین تا شاید از این طریق متوجه بشین به چه دلیلی وارد catch شده.

msroid
دوشنبه 03 اسفند 1394, 19:40 عصر
توی اون حلقه تودرتو هم میتونین بعد از ++counter یه break بذارین تا زمانی که مورد مشابه پیدا شد دیگه سراغ بعدی ها نره.

CRbreeze
دوشنبه 03 اسفند 1394, 20:05 عصر
من میدونم تا جا درست کار میکنه ... ببینید وارد else میشه بعد از اون وارد do - while اولی میشه اطلاعات جدول رو تا آخر میخونه ... یعنی 12 ردیف رو میخونه بعد دیگه از while خارج نمیشه که بقیه برنامه رو اجرا کنه ... میره تو catch

msroid
دوشنبه 03 اسفند 1394, 21:17 عصر
خب شما دستور زیر رو بذار توی بدنه catch:
Log.i("ERROR_MESSAGE", e.getMessage());
بعد توی LogCat ببین چه خطایی باعث شده وارد بدنه catch بشه. به نظر نمیاد توی کد مشکلی وجود داشته باشه.

CRbreeze
سه شنبه 04 اسفند 1394, 09:07 صبح
من از cogcat چیزی متوجه نشدم متاسفانه ...

CRbreeze
سه شنبه 04 اسفند 1394, 09:15 صبح
02-23 02:52:20.405 2078-2082/? D/dalvikvm﹕ GC_CONCURRENT freed 636K, 24% free 2681K/3492K, paused 0ms+10ms, total 20ms02-23 02:52:31.275 2990-2990/? D/AndroidRuntime﹕ >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
02-23 02:52:31.285 2990-2990/? D/AndroidRuntime﹕ CheckJNI is OFF
02-23 02:52:31.295 2990-2990/? D/dalvikvm﹕ Trying to load lib libjavacore.so 0x0
02-23 02:52:31.295 2990-2990/? D/dalvikvm﹕ Added shared lib libjavacore.so 0x0
02-23 02:52:31.295 2990-2990/? D/dalvikvm﹕ Trying to load lib libnativehelper.so 0x0
02-23 02:52:31.295 2990-2990/? D/dalvikvm﹕ Added shared lib libnativehelper.so 0x0
02-23 02:52:31.295 2990-2990/? D/dalvikvm﹕ No JNI_OnLoad found in libnativehelper.so 0x0, skipping init
02-23 02:52:31.315 2990-2990/? D/dalvikvm﹕ Note: class Landroid/app/ActivityManagerNative; has 179 unimplemented (abstract) methods
02-23 02:52:31.325 2990-2990/? E/cutils-trace﹕ Error opening trace file: No such file or directory (2)
02-23 02:52:31.425 2990-2990/? E/memtrack﹕ Couldn't load memtrack module (No such file or directory)
02-23 02:52:31.425 2990-2990/? E/android.os.Debug﹕ failed to load memtrack module: -2
02-23 02:52:31.475 2990-2990/? D/AndroidRuntime﹕ Calling main entry com.android.commands.pm.Pm
02-23 02:52:31.485 1750-1774/? W/ActivityManager﹕ No content provider found for permission revoke: file:///data/local/tmp/com.example.pc1.myapplication
02-23 02:52:31.495 1750-1774/? D/dalvikvm﹕ GC_EXPLICIT freed 208K, 21% free 5126K/6432K, paused 0ms+0ms, total 0ms
02-23 02:52:31.495 1750-1774/? W/ActivityManager﹕ No content provider found for permission revoke: file:///data/local/tmp/com.example.pc1.myapplication
02-23 02:52:31.495 1750-1774/? I/PackageManager﹕ Copying native libraries to /data/app-lib/vmdl-481681999
02-23 02:52:31.595 1750-1753/? D/dalvikvm﹕ GC_CONCURRENT freed 699K, 16% free 5461K/6432K, paused 10ms+0ms, total 10ms
02-23 02:52:31.665 1750-1753/? D/dalvikvm﹕ GC_CONCURRENT freed 1104K, 19% free 5475K/6732K, paused 10ms+0ms, total 10ms
02-23 02:52:31.705 1750-1753/? D/dalvikvm﹕ GC_CONCURRENT freed 1109K, 19% free 5494K/6732K, paused 10ms+0ms, total 10ms
02-23 02:52:31.775 1750-1765/? I/ActivityManager﹕ Force stopping com.example.pc1.myapplication appid=10053 user=-1: uninstall pkg
02-23 02:52:31.775 1750-1765/? I/ActivityManager﹕ Killing 2927:com.example.pc1.myapplication/u0a53 (adj 9): stop com.example.pc1.myapplication
02-23 02:52:31.775 1750-1765/? I/ActivityManager﹕ Setting mBooting value to false, currently mBooted = true
02-23 02:52:31.835 1750-1774/? I/PackageManager﹕ Package com.example.pc1.myapplication codePath changed from /data/app/com.example.pc1.myapplication-1.apk to /data/app/com.example.pc1.myapplication-2.apk; Retaining data and using new
02-23 02:52:31.875 1750-1774/? D/dalvikvm﹕ GC_EXPLICIT freed 364K, 19% free 5483K/6732K, paused 0ms+10ms, total 40ms
02-23 02:52:31.875 1750-1774/? I/PackageManager﹕ Running dexopt on: com.example.pc1.myapplication
02-23 02:52:32.035 3001-3001/? W/dalvikvm﹕ method Landroid/support/v7/internal/widget/ListViewCompat;.lookForSelectablePosition incorrectly overrides package-private method with same name in Landroid/widget/ListView;
02-23 02:52:32.285 3001-3001/? D/dalvikvm﹕ DexOpt: load 60ms, verify+opt 230ms, 1726124 bytes
02-23 02:52:32.345 1750-1774/? W/PackageManager﹕ Code path for pkg : com.example.pc1.myapplication changing from /data/app/com.example.pc1.myapplication-1.apk to /data/app/com.example.pc1.myapplication-2.apk
02-23 02:52:32.345 1750-1774/? W/PackageManager﹕ Resource path for pkg : com.example.pc1.myapplication changing from /data/app/com.example.pc1.myapplication-1.apk to /data/app/com.example.pc1.myapplication-2.apk
02-23 02:52:32.355 1750-1765/? I/ActivityManager﹕ Force stopping com.example.pc1.myapplication appid=10053 user=-1: update pkg
02-23 02:52:32.355 1750-1765/? I/ActivityManager﹕ Setting mBooting value to false, currently mBooted = true
02-23 02:52:32.415 1750-1774/? I/ActivityManager﹕ Force stopping com.example.pc1.myapplication appid=10053 user=0: pkg removed
02-23 02:52:32.425 2107-2107/? D/dalvikvm﹕ GC_EXPLICIT freed 632K, 20% free 6296K/7856K, paused 0ms+0ms, total 0ms
02-23 02:52:32.425 2094-2094/? D/dalvikvm﹕ GC_EXPLICIT freed 186K, 12% free 4010K/4540K, paused 0ms+0ms, total 0ms
02-23 02:52:32.435 1750-1765/? I/ActivityManager﹕ Setting mBooting value to false, currently mBooted = true
02-23 02:52:32.445 2580-2580/? D/Blue.Master﹕ intent =Intent { act=android.intent.action.PACKAGE_REMOVED dat=package:com.example.pc1.myapplication flg=0x4000010 (has extras) }
02-23 02:52:32.445 2580-2580/? D/S2P.Blue.Master﹕ App installed: null
02-23 02:52:32.475 1952-1952/? D/dalvikvm﹕ GC_EXPLICIT freed 2196K, 36% free 6538K/10180K, paused 0ms+0ms, total 20ms
02-23 02:52:32.495 1750-2181/? I/ActivityManager﹕ Start proc com.android.keychain for broadcast com.android.keychain/.KeyChainBroadcastReceiver: pid=3004 uid=1000 gids={41000, 1028, 1015, 1023, 3002, 3001, 3003}
02-23 02:52:32.515 3004-3004/? W/ContextImpl﹕ Calling a method in the system process without a qualified user: android.app.ContextImpl.startService:1485 android.content.ContextWrapper.startService:494 android.content.ContextWrapper.startService:494 com.android.keychain.KeyChainBroadcastReceiver.onR eceive:12 android.app.ActivityThread.handleReceiver:2419
02-23 02:52:32.575 1952-1952/? D/Constants﹕ product.oem not found
02-23 02:52:32.575 1952-1952/? D/PackageModifiedRecevier﹕ Install .. com.example.pc1.myapplication
02-23 02:52:32.575 1952-1952/? E/gpop.InstalledAppsGrid﹕ Hidden list size 0
02-23 02:52:32.575 1952-1952/? D/Constants﹕ product.oem not found
02-23 02:52:32.585 1750-1799/? I/InputReader﹕ Reconfiguring input devices. changes=0x00000010
02-23 02:52:32.585 1750-1750/? D/BackupManagerService﹕ Received broadcast Intent { act=android.intent.action.PACKAGE_REMOVED dat=package:com.example.pc1.myapplication flg=0x4000010 (has extras) }
02-23 02:52:32.615 1952-1952/? D/dalvikvm﹕ GC_FOR_ALLOC freed 1495K, 50% free 5191K/10180K, paused 0ms, total 0ms
02-23 02:52:32.655 1750-1750/? D/BackupManagerService﹕ Received broadcast Intent { act=android.intent.action.PACKAGE_ADDED dat=package:com.example.pc1.myapplication flg=0x4000010 (has extras) }
02-23 02:52:32.655 1750-1750/? V/BackupManagerService﹕ removePackageParticipantsLocked: uid=10053 #1
02-23 02:52:32.655 1750-1750/? V/BackupManagerService﹕ addPackageParticipantsLocked: #1
02-23 02:52:32.665 1750-1799/? I/InputReader﹕ Reconfiguring input devices. changes=0x00000010
02-23 02:52:32.665 2580-2580/? D/Blue.Master﹕ intent =Intent { act=android.intent.action.PACKAGE_ADDED dat=package:com.example.pc1.myapplication flg=0x4000010 (has extras) }
02-23 02:52:32.665 2580-2580/? D/S2P.Blue.Master﹕ App installed: com.example.pc1.myapplication
02-23 02:52:32.685 1952-1957/? D/dalvikvm﹕ GC_CONCURRENT freed 30K, 36% free 6614K/10180K, paused 0ms+0ms, total 0ms
02-23 02:52:32.695 1750-1799/? I/InputReader﹕ Reconfiguring input devices. changes=0x00000010
02-23 02:52:32.695 2580-2580/? D/Blue.Master﹕ intent =Intent { act=android.intent.action.PACKAGE_REPLACED dat=package:com.example.pc1.myapplication flg=0x4000010 (has extras) }
02-23 02:52:32.695 1750-1766/? W/RecognitionManagerService﹕ no available voice recognition services found for user 0
02-23 02:52:32.735 2580-2580/? D/S2P.Blue.Master﹕ App installed: com.example.pc1.myapplication
02-23 02:52:32.735 2107-2107/? D/BstCommandProcessor-ApplicationIntentReceiver﹕ BstApplicationIntentsReceiver Action: android.intent.action.PACKAGE_REPLACED , DATA: package:com.example.pc1.myapplication
02-23 02:52:32.755 2107-2107/? D/BstCommandProcessor-Application﹕ in sendHttpRequest, request to send to (fqdn): http://10.0.2.2:2861/installed
data: {"package":"com.example.pc1.myapplication","activities":"[{\"img\":\"com.example.pc1.myapplication.com.example.pc1.myap plication.Nasim.png\",\"activity\":\"com.example.pc1.myapplication.Nasim\",\"name\":\"My Application\"}]","version":1}
02-23 02:52:32.835 1750-1774/? D/dalvikvm﹕ GC_EXPLICIT freed 1215K, 24% free 5174K/6732K, paused 0ms+0ms, total 140ms
02-23 02:52:32.845 2990-2990/? D/AndroidRuntime﹕ Shutting down VM
02-23 02:52:32.845 2990-2994/? D/dalvikvm﹕ GC_CONCURRENT freed 94K, 15% free 552K/648K, paused 0ms+0ms, total 0ms
02-23 02:52:32.935 1952-1952/? D/blue.home﹕ PackageChanged...
02-23 02:52:32.965 2580-3035/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:32.965 1952-3034/? D/KeyMappingDownloader﹕ Download attempt for pacakge com.example.pc1.myapplication
02-23 02:52:32.965 1952-3034/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:32.995 1750-2090/? I/ActivityManager﹕ Start proc com.svox.pico for broadcast com.svox.pico/.VoiceDataInstallerReceiver: pid=3039 uid=10032 gids={50032, 1028, 1015, 1023}
02-23 02:52:33.115 1952-1952/? D/Constants﹕ product.oem not found
02-23 02:52:33.115 1952-1952/? D/PackageModifiedRecevier﹕ Install .. com.example.pc1.myapplication
02-23 02:52:33.115 1952-1952/? E/gpop.InstalledAppsGrid﹕ Hidden list size 0
02-23 02:52:33.115 1952-1952/? D/Constants﹕ product.oem not found
02-23 02:52:33.165 1952-1952/? D/dalvikvm﹕ GC_FOR_ALLOC freed 2051K, 49% free 5249K/10180K, paused 10ms, total 10ms
02-23 02:52:33.225 1952-3034/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at tv.gamepop.home.KeyMappingDownloader.fetchMappingF romWeb(KeyMappingDownloader.java:116)
at tv.gamepop.home.KeyMappingDownloader.downloadMappi ngsForPackage(KeyMappingDownloader.java:99)
at tv.gamepop.home.KeyMappingDownloader.onHandleInten t(KeyMappingDownloader.java:56)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:33.245 1952-1957/? D/dalvikvm﹕ GC_CONCURRENT freed 99K, 35% free 6642K/10180K, paused 10ms+0ms, total 10ms
02-23 02:52:33.255 3056-3056/? D/AndroidRuntime﹕ >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
02-23 02:52:33.275 3056-3056/? D/AndroidRuntime﹕ CheckJNI is OFF
02-23 02:52:33.275 3056-3056/? D/dalvikvm﹕ Trying to load lib libjavacore.so 0x0
02-23 02:52:33.275 3056-3056/? D/dalvikvm﹕ Added shared lib libjavacore.so 0x0
02-23 02:52:33.295 3056-3056/? D/dalvikvm﹕ Trying to load lib libnativehelper.so 0x0
02-23 02:52:33.295 3056-3056/? D/dalvikvm﹕ Added shared lib libnativehelper.so 0x0
02-23 02:52:33.295 3056-3056/? D/dalvikvm﹕ No JNI_OnLoad found in libnativehelper.so 0x0, skipping init
02-23 02:52:33.325 2580-3035/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at com.bluestacks.home.KeyMappingDownloader.fetchMapp ingFromWeb(KeyMappingDownloader.java:111)
at com.bluestacks.home.KeyMappingDownloader.downloadM appingsForPackage(KeyMappingDownloader.java:94)
at com.bluestacks.home.KeyMappingDownloader.onHandleI ntent(KeyMappingDownloader.java:55)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:33.325 3056-3056/? D/dalvikvm﹕ Note: class Landroid/app/ActivityManagerNative; has 179 unimplemented (abstract) methods
02-23 02:52:33.325 3056-3056/? E/cutils-trace﹕ Error opening trace file: No such file or directory (2)
02-23 02:52:33.465 3056-3056/? E/memtrack﹕ Couldn't load memtrack module (No such file or directory)
02-23 02:52:33.465 3056-3056/? E/android.os.Debug﹕ failed to load memtrack module: -2
02-23 02:52:33.515 3056-3056/? D/AndroidRuntime﹕ Calling main entry com.android.commands.am.Am
02-23 02:52:33.535 1750-2026/? I/ActivityManager﹕ START u0 {act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.example.pc1.myapplication/.Nasim} from pid 3056
02-23 02:52:33.535 1750-2026/? D/ActivityManager﹕ TopActivityInfo, pkgName: com.example.pc1.myapplication activityName: com.example.pc1.myapplication.Nasim bstSpecialAppKeyboardHandlingEnabled = false
02-23 02:52:33.535 2094-2094/? D/GuidanceScreen﹕ event === app_launch
02-23 02:52:33.535 2094-2094/? D/GuidanceScreen﹕ hiding guidance
02-23 02:52:33.535 2094-2094/? D/GuidanceScreen﹕ hardKeyboard = 1
02-23 02:52:33.535 2094-2094/? D/GuidanceScreen﹕ controllerType === DualAction
02-23 02:52:33.535 2094-2094/? D/GuidanceScreen﹕ appName: My Application, currentPkg: com.example.pc1.myapplication, event: app_launch, controller: DualAction
02-23 02:52:33.535 1750-2026/? D/ActivityManager﹕ Showing guidance for pkgName: com.example.pc1.myapplication
02-23 02:52:33.545 2094-2094/? D/GuidanceScreen﹕ appName: My Application
02-23 02:52:33.545 3056-3056/? D/AndroidRuntime﹕ Shutting down VM
02-23 02:52:33.545 3056-3060/? D/dalvikvm﹕ GC_CONCURRENT freed 94K, 15% free 576K/672K, paused 0ms+0ms, total 0ms
02-23 02:52:33.555 2094-2094/? D/GuidanceScreen﹕ no guidance for com.example.pc1.myapplication.
02-23 02:52:33.695 2580-3071/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:33.745 3073-3073/? D/dalvikvm﹕ Late-enabling CheckJNI
02-23 02:52:33.755 1735-1735/? D/dalvikvm﹕ GC_EXPLICIT freed 40K, 28% free 2660K/3684K, paused 0ms+10ms, total 10ms
02-23 02:52:33.775 1750-2091/? I/ActivityManager﹕ Start proc com.example.pc1.myapplication for activity com.example.pc1.myapplication/.Nasim: pid=3073 uid=10053 gids={50053}
02-23 02:52:33.815 1952-1952/? D/Constants﹕ product.oem not found
02-23 02:52:33.825 1952-3081/? D/KeyMappingDownloader﹕ Download attempt for pacakge com.example.pc1.myapplication
02-23 02:52:33.825 1952-3081/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:33.825 1952-1952/? D/PackageModifiedRecevier﹕ Install .. com.example.pc1.myapplication
02-23 02:52:33.845 1750-1769/? D/WindowManager﹕ Sending appClickStats request with data: [package=com.example.pc1.myapplication, appname=My Application, appver=1.0, clickloc=system_server]
02-23 02:52:33.915 1735-1735/? D/dalvikvm﹕ GC_EXPLICIT freed <1K, 28% free 2660K/3684K, paused 70ms+0ms, total 160ms
02-23 02:52:33.935 1735-1735/? D/dalvikvm﹕ GC_EXPLICIT freed <1K, 28% free 2660K/3684K, paused 0ms+20ms, total 20ms
02-23 02:52:33.965 2580-3071/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at com.bluestacks.home.KeyMappingDownloader.fetchMapp ingFromWeb(KeyMappingDownloader.java:111)
at com.bluestacks.home.KeyMappingDownloader.downloadM appingsForPackage(KeyMappingDownloader.java:94)
at com.bluestacks.home.KeyMappingDownloader.onHandleI ntent(KeyMappingDownloader.java:55)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:33.965 2580-2584/? D/dalvikvm﹕ GC_CONCURRENT freed 734K, 24% free 3009K/3932K, paused 0ms+0ms, total 0ms
02-23 02:52:33.985 3073-3073/? I/dalvikvm﹕ Could not find method android.view.ViewGroup.onNestedScrollAccepted, referenced from method android.support.v7.internal.widget.ActionBarOverla yLayout.onNestedScrollAccepted
02-23 02:52:33.985 3073-3073/? W/dalvikvm﹕ VFY: unable to resolve virtual method 11353: Landroid/view/ViewGroup;.onNestedScrollAccepted (Landroid/view/View;Landroid/view/View;I)V
02-23 02:52:33.985 3073-3073/? D/dalvikvm﹕ VFY: replacing opcode 0x6f at 0x0000
02-23 02:52:33.985 3073-3073/? I/dalvikvm﹕ Could not find method android.view.ViewGroup.onStopNestedScroll, referenced from method android.support.v7.internal.widget.ActionBarOverla yLayout.onStopNestedScroll
02-23 02:52:33.985 3073-3073/? W/dalvikvm﹕ VFY: unable to resolve virtual method 11359: Landroid/view/ViewGroup;.onStopNestedScroll (Landroid/view/View;)V
02-23 02:52:33.985 3073-3073/? D/dalvikvm﹕ VFY: replacing opcode 0x6f at 0x0000
02-23 02:52:33.985 3073-3073/? I/dalvikvm﹕ Could not find method android.support.v7.internal.widget.ActionBarOverla yLayout.stopNestedScroll, referenced from method android.support.v7.internal.widget.ActionBarOverla yLayout.setHideOnContentScrollEnabled
02-23 02:52:33.985 3073-3073/? W/dalvikvm﹕ VFY: unable to resolve virtual method 9043: Landroid/support/v7/internal/widget/ActionBarOverlayLayout;.stopNestedScroll ()V
02-23 02:52:33.985 3073-3073/? D/dalvikvm﹕ VFY: replacing opcode 0x6e at 0x000e
02-23 02:52:33.985 3073-3073/? I/dalvikvm﹕ Could not find method android.content.res.TypedArray.getChangingConfigur ations, referenced from method android.support.v7.internal.widget.TintTypedArray. getChangingConfigurations
02-23 02:52:33.985 3073-3073/? W/dalvikvm﹕ VFY: unable to resolve virtual method 365: Landroid/content/res/TypedArray;.getChangingConfigurations ()I
02-23 02:52:33.985 3073-3073/? D/dalvikvm﹕ VFY: replacing opcode 0x6e at 0x0002
02-23 02:52:33.985 3073-3073/? I/dalvikvm﹕ Could not find method android.content.res.TypedArray.getType, referenced from method android.support.v7.internal.widget.TintTypedArray. getType
02-23 02:52:33.985 3073-3073/? W/dalvikvm﹕ VFY: unable to resolve virtual method 387: Landroid/content/res/TypedArray;.getType (I)I
02-23 02:52:33.985 3073-3073/? D/dalvikvm﹕ VFY: replacing opcode 0x6e at 0x0002
02-23 02:52:34.065 1952-3081/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at tv.gamepop.home.KeyMappingDownloader.fetchMappingF romWeb(KeyMappingDownloader.java:116)
at tv.gamepop.home.KeyMappingDownloader.downloadMappi ngsForPackage(KeyMappingDownloader.java:99)
at tv.gamepop.home.KeyMappingDownloader.onHandleInten t(KeyMappingDownloader.java:56)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:34.065 1952-3081/? D/KeyMappingDownloader﹕ Download attempt for pacakge com.example.pc1.myapplication
02-23 02:52:34.065 1952-3081/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:34.115 2580-2608/? D/Blue.Master﹕ isOnline called...
02-23 02:52:34.265 1952-1952/? D/blue.home﹕ PackageChanged...
02-23 02:52:34.275 2580-2580/? D/Home.AppLaunchReceiver﹕ *************************Received app launch broadcast
02-23 02:52:34.275 2580-2580/? D/Home.AppLaunchReceiver﹕ APP LAUNCH com.example.pc1.myapplication
02-23 02:52:34.275 2580-3088/? D/Blue.API.util﹕ URL: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
02-23 02:52:34.335 3073-3073/? I/PGA﹕ New SOCKET connection: com.example.pc1.myapplication (pid 3073, tid 3073)
02-23 02:52:34.365 1952-3081/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at tv.gamepop.home.KeyMappingDownloader.fetchMappingF romWeb(KeyMappingDownloader.java:116)
at tv.gamepop.home.KeyMappingDownloader.downloadMappi ngsForPackage(KeyMappingDownloader.java:99)
at tv.gamepop.home.KeyMappingDownloader.onHandleInten t(KeyMappingDownloader.java:56)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:34.445 1750-1764/? I/ActivityManager﹕ Displayed com.example.pc1.myapplication/.Nasim: +700ms
02-23 02:52:34.515 2580-3088/? E/KeyMappingDownloader﹕ Failed to fetch map from web: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
java.io.FileNotFoundException: http://opasanet.appspot.com/op/appmap?id=com.example.pc1.myapplication
at com.android.okhttp.internal.http.HttpURLConnection Impl.getInputStream(HttpURLConnectionImpl.java:186 )
at com.bluestacks.api.util.getResponse(util.java:97)
at com.bluestacks.home.KeyMappingDownloader.fetchMapp ingFromWeb(KeyMappingDownloader.java:111)
at com.bluestacks.home.KeyMappingDownloader.downloadM appingsForPackage(KeyMappingDownloader.java:94)
at com.bluestacks.home.KeyMappingDownloader.onHandleI ntent(KeyMappingDownloader.java:55)
at android.app.IntentService$ServiceHandler.handleMes sage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:10 2)
at android.os.Looper.loop(Looper.java:136)
at android.os.HandlerThread.run(HandlerThread.java:61 )
02-23 02:52:34.525 2580-2608/? D/Blue.BundledAppUpdates﹕ Bundled Apps update...
02-23 02:52:34.525 2580-2606/? D/Blue.API.util﹕ URL: https://bluestacks-cloud-geo.appspot.com/
02-23 02:52:35.515 2580-2606/? D/Blue.API.util﹕ URL: http://10.0.2.2:2861/getuserdata
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ isgl = true
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ oem from sys prop = BlueStacks
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1.4057.<!DOCTYPE html><html lang=en><meta charset=utf-8><meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width"><title>Error 403 (Forbidden)!!1</title><style>*{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px }body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}</style><a href=//www.google.com/><span id=logo aria-label=Google></span></a><p><b>403.</b> <ins>That’s an error.</ins><p>Your client does not have permission to get URL <code>/</code> from this server. (Client IP address: 5.221.191.178)<br><br>.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1.<!DOCTYPE html><html lang=en><meta charset=utf-8><meta name=viewport content="initial-scale=1, minimum-scale=1, width=device-width"><title>Error 403 (Forbidden)!!1</title><style>*{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px }body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}</style><a href=//www.google.com/><span id=logo aria-label=Google></span></a><p><b>403.</b> <ins>That’s an error.</ins><p>Your client does not have permission to get URL <code>/</code> from this server. (Client IP address: 5.221.191.178)<br><br>.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1.4057_BlueStacks.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1.4057.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_BlueStacks.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1_BlueStacks.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps_0.9.1.txt
02-23 02:52:35.525 2580-2606/? D/Blue.API.CC﹕ getUrls :http://cdn.bluestacks.com/public/appsettings/bundledapps.txt

msroid
سه شنبه 04 اسفند 1394, 16:22 عصر
اون خط کد رو که دادم بدون تغییر اگر بذاری توی بدنه catch وقتی وارد بدنه بشه توی خروجی با استفاده از ERROR_MESSAGE میتونی پیداش کنی.
یه باکس توی LogCat هست که میتونی داخل اون اگر توی اکلیپس هستی بنویسی "ERROR_MESSAGE" و اگر توی اندروید استودیو هستی دیگه کوتیشن نمیخواد. اینجوری فیلتر میشه و فقط همون خطای مورد نظر رو بهت نشون میده.

من الان چک کردم و نتونستم توی چیزایی که گذاشتی ERROR_MESSAGE رو پیدا کنم که دو حالت بیشتر نداره. یا اون چیزی که گفتم رو نذاشتی و اگر گذاشتی عوضش کردی و احتمال دوم اینه که بدنه catch اجرا نشده باشه.

CRbreeze
سه شنبه 04 اسفند 1394, 18:27 عصر
این رو چاپ کرد ... دفعه اول اشتباه اجرا کرده بود متاسفانه...

02-23 11:57:55.177 2943-2943/? I/ERROR_MESSAGE﹕ String resource ID #0xc

msroid
سه شنبه 04 اسفند 1394, 19:47 عصر
قبلنا این بزرگوار بیشتر و بهتر حرف میزد جدیدا انگار کوتاه و غیرمفید صحبت میکنه...!!
شما مطمعن هستی که مشکل تو حلقه اولی هست...؟؟ چون الان حلقه دومی هم باید عینا مثل حلقه اولی باشه که نیست و خودش در کل نتایج غلط بهت میده چون یکی از داده هارو داری بیخیال میشی و از داده دوم به بعد داری میریزی توی آرایه...!!

CRbreeze
چهارشنبه 05 اسفند 1394, 03:26 صبح
والا چه عرض کنم کم سخن شدن جدیدا.... اینکه مشکل تو حلقه اولی هست مطمئنم چون بعد از حلقه اولی که بهش گفتم حالا i رو چاپ کن اصلا به اون خط نرسید...وارد catch شد
اینکه میگید اطلاعات رو کامل نمیخونه بیخیال میشه .... این اتفاق هم نمیفته چون امتحان کردم تو حلقه، مسیج چاپ اطلاعات هم گذاشتم عین 12 داده رو چاپ کرد
بله دومی رو هم باید do-while بنویسم ... حق با شماست ... ولی مشکل اینجاس که اصلا از حلقه اول خارج نمیشه :متفکر:

msroid
چهارشنبه 05 اسفند 1394, 05:46 صبح
ببین اگه تا الان دیباگ نکردی بهترین راه اینه که یه breakpoint توی بدنه else بذاری و خط به خط اجرای کد رو جلو ببری و مقادیر رو چک کنی. بعدش میتونی ببینی دقیقا چند بار حلقه اجرا شده و اینکه آیا اطلاعات رو درست میده یا و نه و اینکه بعد از انجام چه عملی اجرا وارد بدنه catch میشه.

اگر برنامت اختصاصی هست که هیچی ولی اگر برای تمرین و یا یادگیری داری انجام میدی دیتابیست رو آپلود کن تا منم اجراش کنم ببینم مشکلش چیه.

CRbreeze
شنبه 08 اسفند 1394, 06:37 صبح
برنامه رو میذارم براتون ... حقیقتش اینه که من کلا دیباگ کردن بلد نیستم ... چهار ساله کد میزنما ولی با دیباگ مشکل دارم کلا متاسفانه....

package com.example.pc1.myapplication;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.ActionBarActivity;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


import java.util.HashMap;
import java.util.Iterator;
public class Queeze extends ActionBarActivity {


String data;
String DB_NAME ="university.db";
String stud ="stud";
String prof="prof";
String crs="crs";
String sec="sec";
String clg="clg";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.second);


Button btn = (Button) findViewById(R.id.button2);
final EditText et = (EditText) findViewById(R.id.editText);
// show();
createTable();
btn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
data = et.getText().toString();
// show(data);
if(check1(data)){
Toast.makeText(Queeze.this,"آفرین پاسخ شما صحیح می باشد",Toast.LENGTH_SHORT).show();
}else{
Toast.makeText(Queeze.this,"متاسفانه پاسخ صحیح نیست دوباره تلاش کنید",Toast.LENGTH_SHORT).show();
}
}
});

}

public void show(String data){
SQLiteDatabase mydb = openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE, null);
Cursor all = mydb.rawQuery(data,null);


if(all.moveToFirst())
while(all.moveToNext()) {
Toast.makeText(getApplicationContext(), all.getString(0)+"", Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), all.getString(1)+"", Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), all.getString(2)+"", Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), all.getString(3)+"", Toast.LENGTH_LONG).show();
Toast.makeText(getApplicationContext(), all.getString(4)+"", Toast.LENGTH_LONG).show();




}
}


public void createTable() {
try {
SQLiteDatabase mydb = openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE, null);
mydb.execSQL("CREATE TABLE IF NOT EXISTS " + stud + " (s INTEGER PRIMARY KEY, sname TEXT, city TEXT, avg REAL, clg INTEGER);");
mydb.execSQL("CREATE TABLE IF NOT EXISTS " + prof + " (pname TEXT PRIMARY KEY, office TEXT, esp TEXT, degree TEXT, clg INTEGER);");
mydb.execSQL("CREATE TABLE IF NOT EXISTS " + crs + " (c INTEGER PRIMARY KEY, cname TEXT, unit INTEGER, clg INTEGER);");
mydb.execSQL("CREATE TABLE IF NOT EXISTS " + clg + " (clg INTEGER PRIMARY KEY, clgname TEXT, city TEXT, pname TEXT);");
mydb.execSQL("CREATE TABLE IF NOT EXISTS " + sec + " (sec INTEGER, c INTEGER PRIMARY KEY, s INTEGER PRIMARY KEY, term INTEGER PRIMARY KEY, pname TEXT, score REAL);");
mydb.close();
} catch (Exception e) {
Toast.makeText(getApplicationContext(), "Error in creating table", Toast.LENGTH_LONG).show();
}


try {
SQLiteDatabase mydb = openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE, null);
Toast.makeText(getApplicationContext(), "qable insert", Toast.LENGTH_LONG).show();
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9110263','borabadi','esfarayen','15.32','21')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9111923','hajian','esfarayen','14.84','11')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9111113','torkashvand','tehran','17.65','21')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9010263','akbari','shiraz','18.60','11')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9011923','kashefi','esfahan','15.53','10')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9011113','saqari','kerman','16.28','10')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9310263','abbasi','mashhad','18.45','12')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9211923','hosseini','birjand','14.39','12')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9211113','karimi','tabriz','12.19','13')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9210263','sadeqi','ahvaz','15.97','13')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9311923','mohammadi','shahrood','13.70','14')");
mydb.execSQL("INSERT INTO " + stud + " (s, sname, city, avg, clg) VALUES ('9311113','zahedi','zahedan','18.92','14')");

mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('shahmardan','1','mekanik','phd','10')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('abbasi','7','mekanik','phd','10')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('ahmadifar','8','electronic','phd','11')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('toosian','6','control','phd','11')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('ahmadi','9','omran','phd','12')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('borumand','2','omran','phd','12')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('hashemi','3','riazi','phd','13')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('moosavi','4','math','phd','13')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('momeni','5','coantom','phd','14')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('hosseini','10','hastei','phd','14')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('hasanpoor','11','signalprocessing','phd','21')");
mydb.execSQL("INSERT INTO " + prof + " (pname, office, esp, degree, clg) VALUES ('farhadi','12','datamining','msc','21')");


mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('1','paygahdade','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('2','memari','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('3','manteqi','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('4','sayalat','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('5','khak','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('6','physic','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('7','controlsanati','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('8','manteqi','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('9','mabani','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('10','termodinamik','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('11','estatik','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('12','naqshekeshi','1','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('13','sakhteman','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('14','jabr','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('15','tahqiqdaramaliat','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('16','riazi1','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('17','coantom','3','21')");
mydb.execSQL("INSERT INTO " + crs + " (c, cname, unit, clg) VALUES ('18','hastei','3','21')");


mydb.execSQL("INSERT INTO "+sec +" (seC#‎‎‎, C#‎‎‎, s#, term, pname, score) VALUES ('1','paygahdade','3','21')");


mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('10','mekanik','shahrood','shahmardan')");
mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('11','barq','shahrood','ahmadifar')");
mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('12','omran','shahrood','ahmadi')");
mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('13','riazi','shahrood','hashemi')");
mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('14','physic','shahrood','momeni')");
mydb.execSQL("INSERT INTO " + clg + " (clg, clgname, city, pname) VALUES ('21','itc','shahrood','hasanpoor')");


mydb.close();
} catch (Exception e) {
Toast.makeText(getApplicationContext(), "Error in inserting into table", Toast.LENGTH_LONG).show();
}
}


public boolean check1(String data){
boolean result = false;
try{
SQLiteDatabase mydb=openOrCreateDatabase(DB_NAME, Context.MODE_PRIVATE,null);


Cursor allrows = mydb.rawQuery("select * from stud", null);
Cursor rows = mydb.rawQuery(data,null);


if(allrows.getCount() != rows.getCount()){
return result;
}else {
String[] myRes;
String[] karbarRes;
int i = 0;
int j = 0;
int counter = 0;


myRes = new String[allrows.getCount()];
karbarRes = new String[rows.getCount()];
if(allrows.moveToFirst()){
do {


myRes[i] = allrows.getString(0);
i++;
}while(allrows.moveToNext());
}
if(rows.moveToFirst()){
while(rows.moveToNext()){
karbarRes[j] = rows.getString(0);
j++;
}
}


String flag = "false";


for(int t=0;t<myRes.length;t++){
flag = "true";
for(int k=0;k<karbarRes.length;k++) {
if (myRes[t].equals(karbarRes[k]))
counter++;
}
}


if(counter==allrows.getCount()){
result = true;
}
}
mydb.close();


}catch(Exception e){
// Toast.makeText(getApplicationContext(), "Error encountered while deleting.", Toast.LENGTH_LONG).show();
Log.i("ERROR_MESSAGE",e.getMessage());
}
return result;
}
}




کلاس main:

public class Nasim extends ActionBarActivity {

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_nasim);
Button btn = (Button) findViewById(R.id.button);
btn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent i = new Intent(Nasim.this,Queeze.class);
startActivity(i);


}
});
}
}

CRbreeze
شنبه 08 اسفند 1394, 06:43 صبح
آها راستی sec رو هم حذف کنید فعلا ارور میده .... فک کنم برای اینکه چند تا کلید اصلی واسش تعریف کردم ....

msroid
شنبه 08 اسفند 1394, 10:11 صبح
من این کدها رو اجرا کردم و هیچ اروری دریافت نکردم...!!
فقط نتیجه رو اشتباه میداد که اونم به خاطر کد زیر هست که قبلا هم بهت گفتم:

if (rows.moveToFirst()) {
while(rows.moveToNext()){
karbarRes[j] = rows.getString(0);
j++;
}
}

و باید بشه مثل کد قبلیش یعنی اینجوری:

if (rows.moveToFirst()) {
do {
karbarRes[j] = rows.getString(0);
j++;
}while (rows.moveToNext());
}

CRbreeze
شنبه 08 اسفند 1394, 12:25 عصر
واقعا؟؟!!!!!!!!!

خب پس چرا من ارور دارم؟ :گریه: به نظرتون چکار کم؟ چقدر جالب ... انتظار هر جوابی داشتم جز این :لبخند:

msroid
شنبه 08 اسفند 1394, 12:36 عصر
همون اول هم گفتم که توی این کدها خطایی نمیبینم به جز همون موردی که بهش اشاره کردم.
اگر اکتیویتی ها رو توی منیفست معرفی کردی و اکتیویتی دوم هم اجرا میشه و دستور رو وارد میکنی بعد روی دکمه کلیک میکنه بعدش ارور میده تنها راهش اینه که دیباگ کنی تا بفهمی دقیقا مشکلش از کجاست. در غیر این صورت خیلی سخته که بشه فهمید از کجا ارور میده. مسلما ارور ربطی به کدهای اینجا نداره چون من همینارو اجرا کردم و بدون خطا اجرا شد و جواب درست رو هم تولید کرد.

پس شما یه breakpoint بذار توی متد check و برنامه رو دیباگ کن.

CRbreeze
یک شنبه 09 اسفند 1394, 13:38 عصر
ممنون دوست عزیز ... خیلی لطف کردی :چشمک: