致命异常：Android项目中的MAIN

问题描述：

我正在创建一个数据库来存储来自列表的文本输入。但是，我收到一个错误，我找不到如何解决。致命异常：Android项目中的MAIN

我的目录代码：

package bookshelf.Android.Java; 
import java.util.ArrayList; 
import java.util.List; 

import android.app.Activity; 
import android.os.Bundle; 
import android.view.KeyEvent; 
import android.view.View; 
import android.widget.ArrayAdapter; 
import android.widget.Button; 
import android.widget.EditText; 
import android.widget.ListView; 
import android.widget.Toast; 
import bookshelf.Android.Java.R; 


public class Own extends Activity 
{ 
    private EditText item; 
    private ListView lv; 
    private Toast toast; 
    private Button addButton; 
    ArrayList<String> items; 
    ArrayAdapter<String> listad; 
    List<String> books; 
    @Override 
    public void onCreate(Bundle savedInstanceState) 
    { 
      super.onCreate(savedInstanceState); 
      setContentView(R.layout.own); 
      CharSequence text = "Item added!"; 
      toast = Toast.makeText(getApplicationContext(), text, Toast.LENGTH_SHORT); 
      setUpView(); 



    } 
    private void setUpView() 
    { 
     item = (EditText)this.findViewById(R.id.txtAmount); 
     lv = (ListView)this.findViewById(R.id.listView1); 
     addButton = (Button)this.findViewById(R.id.Add); 
     items = new ArrayList<String>(); 
     items.clear(); 
     final DataBaseOwn dbo = new DataBaseOwn(Own.this); 

     listad = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, items);//need to create a way to get items to equal books 
     lv.setAdapter(listad); 
     addButton.setOnClickListener(new View.OnClickListener() { 
      public void onClick(View v) 
      { 
       addItemList(); 
       books = dbo.get(items); 
       toast.show(); 
      } 
     }); 
     item.setOnKeyListener(new View.OnKeyListener() { 
      public boolean onKey(View v, int keyCode, KeyEvent event) 
      { 
       // TODO Auto-generated method stub 

       if (keyCode == KeyEvent.KEYCODE_ENTER) 
       { 
        addItemList(); 
       } 
       return true; 
      } 
     }); 
    } 
    protected void addItemList() 
    { 
     // TODO Auto-generated method stub 

     // TODO Auto-generated method stub 
     if (isInputValid(item)) 
     { 
      items.add(0,item.getText().toString()); 
      item.setText(""); 
      listad.notifyDataSetChanged(); 
     } 
    } 
    protected boolean isInputValid(EditText item2) 
    { 
     // TODO Auto-generatd method stub 
     if (item2.getText().toString().trim().length()<1) 
     { 
      item2.setError("Please Enter Item"); 
      return false; 
     } 
     else 
     { 
      return true; 
     } 

    } 
}

，这是数据库代码：

package bookshelf.Android.Java; 

import java.util.ArrayList; 
import java.util.List; 

import android.content.ContentValues; 
import android.content.Context; 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
import android.database.sqlite.SQLiteOpenHelper; 

public class DataBaseOwn extends SQLiteOpenHelper 
{ 
    public static final int VERSION = 1; 
    public static final String TABLE_NAME = "Own List"; 
    public static final String DBNAME = "ownList.sqlite"; 
    public static final String ID = "id"; 
    public static final String BOOK = "book"; 
    static SQLiteDatabase db; 

    public DataBaseOwn(Context context) 
    { 
     super(context, DBNAME, null, VERSION); 
     // TODO Auto-generated constructor stub 
    } 


    @Override 
    public void onCreate(SQLiteDatabase db) 
    { 
     // TODO Auto-generated method stub 
     createDatabase(db); 
    } 
    private void createDatabase(SQLiteDatabase db) 
    { 
     db.execSQL("create table " + TABLE_NAME + "(" + ID + "integer primary key autoincrement not null" + BOOK + " text " + ");"); 
    } 

    @Override 
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
    { 
     // TODO Auto-generated method stub 
     db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME); 
     onCreate(db); 
    } 
    public Long Insert(String book) 
    { 
     ContentValues values = new ContentValues(); 
     values.put(BOOK, book); 
     return db.insert(TABLE_NAME, null, values); 
    } 
    public List<String> get(ArrayList<String> item) 
    { 
     String[] column = new String[] {BOOK}; 
     Cursor c = db.query(TABLE_NAME, column, null, null, null, null, null); 
     List<String> result = item; 
     int columnIndex = c.getColumnIndex(BOOK); 
     for(c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) 
     { 
      result.add(c.getString(columnIndex)); 
     } 
     return result; 
    } 
}

这些之前，我改变了我的代码，被张贴的第一个回答我收到的错误：

10-17 03:18:42.993: D/dalvikvm(2054): GC_FOR_ALLOC freed 0K, 3% free 10829K/11143K, paused 100ms 
    10-17 03:18:43.056: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:18:43.114: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:18:43.523: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:18:43.633: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:18:43.723: D/gralloc_goldfish(2054): Emulator without GPU emulation detected. 
    10-17 03:18:44.033: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:18:44.093: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:26.243: D/dalvikvm(2054): GC_FOR_ALLOC freed 542K, 7% free 10369K/11143K, paused 85ms 
    10-17 03:19:26.293: I/dalvikvm-heap(2054): Grow heap (frag case) to 12.537MB for 2457616-byte allocation 
    10-17 03:19:26.426: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:26.743: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:26.793: D/dalvikvm(2054): GC_CONCURRENT freed 2K, 6% free 12767K/13575K, paused 10ms+8ms 
    10-17 03:19:26.903: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:26.963: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:27.413: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:27.483: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:27.675: D/dalvikvm(2054): GC_FOR_ALLOC freed 0K, 6% free 12767K/13575K, paused 89ms 
    10-17 03:19:27.773: I/dalvikvm-heap(2054): Grow heap (frag case) to 17.808MB for 5529616-byte allocation 
    10-17 03:19:27.903: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:28.073: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:28.133: D/dalvikvm(2054): GC_CONCURRENT freed 0K, 5% free 18167K/19015K, paused 9ms+11ms 
    10-17 03:19:28.403: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:28.463: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:28.903: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:29.053: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:29.413: I/dalvikvm(2054): threadid=3: reacting to signal 3 
    10-17 03:19:29.504: I/dalvikvm(2054): Wrote stack traces to '/data/anr/traces.txt' 
    10-17 03:19:35.773: D/AndroidRuntime(2054): Shutting down VM 
    10-17 03:19:35.773: W/dalvikvm(2054): threadid=1: thread exiting with uncaught exception (group=0x409c01f8) 
    10-17 03:51:39.553: I/dalvikvm(2103): Wrote stack traces to '/data/anr/traces.txt' 

    10-17 03:19:35.813: E/AndroidRuntime(2054): FATAL EXCEPTION: main 

    10-17 03:19:35.813: E/AndroidRuntime(2054): java.lang.NullPointerException 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at bookshelf.Android.Java.DataBaseOwn.get(DataBaseOwn.java:55) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at bookshelf.Android.Java.Own$1.onClick(Own.java:53) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.view.View.performClick(View.java:3511) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.view.View$PerformClick.run(View.java:14105) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.os.Handler.handleCallback(Handler.java:605) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.os.Handler.dispatchMessage(Handler.java:92) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.os.Looper.loop(Looper.java:137) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at android.app.ActivityThread.main(ActivityThread.java:4424) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at java.lang.reflect.Method.invokeNative(Native Method) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at java.lang.reflect.Method.invoke(Method.java:511) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 

    10-17 03:19:35.813: E/AndroidRuntime(2054):  at dalvik.system.NativeStart.main(Native Method) 

These are the new set of errors that I am getting after I put this line in 
db = this.getWritableDatabase(); 
before line 54. 


10-17 04:08:45.765: E/AndroidRuntime(2151): FATAL EXCEPTION: main 
10-17 04:08:45.765: E/AndroidRuntime(2151): android.database.sqlite.SQLiteException: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY: , while compiling: create table OwnList(idinteger primary key autoincrement not nullbook text); 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:134) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteStatement.acquireAndLock(SQLiteStatement.java:260) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:84) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1899) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1839) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at bookshelf.Android.Java.DataBaseOwn.createDatabase(DataBaseOwn.java:36) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at bookshelf.Android.Java.DataBaseOwn.onCreate(DataBaseOwn.java:32) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:165) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at bookshelf.Android.Java.DataBaseOwn.get(DataBaseOwn.java:54) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at bookshelf.Android.Java.Own$1.onClick(Own.java:53) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.view.View.performClick(View.java:3511) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.view.View$PerformClick.run(View.java:14105) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.os.Handler.handleCallback(Handler.java:605) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.os.Handler.dispatchMessage(Handler.java:92) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.os.Looper.loop(Looper.java:137) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at android.app.ActivityThread.main(ActivityThread.java:4424) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at java.lang.reflect.Method.invokeNative(Native Method) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at java.lang.reflect.Method.invoke(Method.java:511) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 
10-17 04:08:45.765: E/AndroidRuntime(2151):  at dalvik.system.NativeStart.main(Native Method)

对不起，他们格式不好，我不知道该怎么做。

什么是第55行上？ – Ahmad

你参考了哪一类？ – user2887839

DataBaseOwn类 – Ahmad

答

我不太确定，但是当你定义它时，表名是否有空格？

public static final String TABLE_NAME = "Own List";

并且你可以确保这里的项目不返回null。

books = dbo.get(items);

EDIT在setupView函数（）方法，（对于Add按钮在setOnClickListener）调用addItemList后（）;你能检查这些项目是否返回null或其他东西？

EDIT 2使用try &捕捉该块 - books = dbo.get(items);

我从表格名称中取出空格，并没有摆脱任何错误。我不确定你的意思是“你能确保这里的项目不会返回null”。 – user2887839

我不知道该怎么做。有一个答案在你的之前被删除，它摆脱了空错误，但更多的产生，我不知道他们的意思或如何去解决它们。 – user2887839

我创建了一个try＆catch块，并且没有发现异常。 – user2887839

答

有你的代码中的一些混乱，但我觉得有以下可能导致paroblem：

你不初始化数据库与任何东西，所以它是空的。如果你尝试使用这个null来做任何事情，它将导致一个NullPonterException。

我建议你遵循这个伟大的教程：

www.vogella.com/articles/AndroidSQLite/article.html http://www.androidhive.info/2013/09/android-sqlite-database-with-multiple-tables/

希望它会帮助你。

我没有初始化数据库更新问题。它创建了以上列出的新错误。我不知道他们的意思或如何解决它们。 – user2887839

对不起，您是否使用getWritableDatabase从数据库中读取数据？你可以检查你的获取方法数据库permision？ –

答

你缺少"和integer之间的空间 - >更改ID + " integer...在createDatabase(SQLiteDatabase db)方法

致命异常：Android项目中的MAIN

相关推荐