· 7 years ago · Jan 14, 2019, 04:50 PM
1sqlite in android-error when add layout
2import java.util.ArrayList;
3
4import com.example.save_money.Screen2DelekActivity;
5
6
7
8public class DelekActivity extends ListActivity {
9 private final String DB_NAME = "mcustomerDbName2";
10 private final String TABLE_NAME = "mcustomeTableName2";
11 SQLiteDatabase customersDB = null;
12 /** Called when the activity is first created. */
13
14
15
16
17
18 private void mFillDbsTable(){
19 try {
20
21 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'ABARTH ','500','Abarth','15.3846153846154' );");
22 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'ABARTH ', 'Grande Punto ', '1.4 T-Jet 155 ', '14.9253731343284 ' );");
23 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'ALFA ROMEO ', 'MiTo ', '1.4 16v TB 120 ', '16.3934426229508 ');");
24 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'ALFA ROMEO ', 'MiTo ', '1.3 JTDm 90 ', '22.2222222222222 ');");
25 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'VOLVO ', 'XC90 ', 'D5 Auto ', '11.7647058823529 ');");
26 customersDB.execSQL("INSERT INTO " + TABLE_NAME + " Values ( 'VOLVO ', 'XC90 ', 'D5 Auto R-Design & Exec ', '11.7647058823529 ');");
27
28 ........
29 ........
30
31 }
32 catch (SQLiteException se ) {
33 Log.e(getClass().getSimpleName(), "Could not create records");
34 }
35 }
36
37@Override
38public void onCreate(Bundle savedInstanceState) {
39 super.onCreate(savedInstanceState);
40
41 try {
42 customersDB = this.openOrCreateDatabase( DB_NAME, MODE_PRIVATE, null);
43 customersDB.execSQL("CREATE TABLE IF NOT EXISTS " +
44 TABLE_NAME +
45 " (Name VARCHAR," +
46 " Street VARCHAR, Block VARCHAR, City VARCHAR);");
47 mFillDbsTable();}
48 catch (SQLiteException se ) {
49 Log.e(getClass().getSimpleName(), "create/Open the database problem");
50 }
51
52 setContentView(R.layout.activity_delek);
53}
54
5510-06 17:28:29.839: D/dalvikvm(447): GC_EXTERNAL_ALLOC freed 854 objects / 59696 bytes in 131ms
5610-06 17:38:26.114: E/AndroidRuntime(532): FATAL EXCEPTION: main
5710-06 17:38:26.114: E/AndroidRuntime(532): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.save_money/com.example.save_money.DelekActivity}: java.lang.RuntimeException: Your content must have a ListView whose id attribute is 'android.R.id.list'
5810-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)
5910-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)
6010-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread.access$2300(ActivityThread.java:125)
6110-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033)
6210-06 17:38:26.114: E/AndroidRuntime(532): at android.os.Handler.dispatchMessage(Handler.java:99)
6310-06 17:38:26.114: E/AndroidRuntime(532): at android.os.Looper.loop(Looper.java:123)
6410-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread.main(ActivityThread.java:4627)
6510-06 17:38:26.114: E/AndroidRuntime(532): at java.lang.reflect.Method.invokeNative(Native Method)
6610-06 17:38:26.114: E/AndroidRuntime(532): at java.lang.reflect.Method.invoke(Method.java:521)
6710-06 17:38:26.114: E/AndroidRuntime(532): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
6810-06 17:38:26.114: E/AndroidRuntime(532): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
6910-06 17:38:26.114: E/AndroidRuntime(532): at dalvik.system.NativeStart.main(Native Method)
7010-06 17:38:26.114: E/AndroidRuntime(532): Caused by: java.lang.RuntimeException: Your content must have a ListView whose id attribute is 'android.R.id.list'
7110-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ListActivity.onContentChanged(ListActivity.java:245)
7210-06 17:38:26.114: E/AndroidRuntime(532): at com.android.internal.policy.impl.PhoneWindow.setContentView(PhoneWindow.java:201)
7310-06 17:38:26.114: E/AndroidRuntime(532): at android.app.Activity.setContentView(Activity.java:1647)
7410-06 17:38:26.114: E/AndroidRuntime(532): at com.example.save_money.DelekActivity.onCreate(DelekActivity.java:2953)
7510-06 17:38:26.114: E/AndroidRuntime(532): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
76 10-06 17:38:26.114: E/AndroidRuntime(532): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)
7710-06 17:38:26.114: E/AndroidRuntime(532): ... 11 more