Android简单数据库操作练习

简单操作内置的sqlite3数据库，添加，删除和显示数据。但不知为什么APP并没能跑起来。

代码：

package com.example.androidtask03;

import android.R.fraction;
import android.R.string;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.TextView;

public class MainActivity extends Activity {

    SQLiteDatabase sd = openOrCreateDatabase("fruit.db",
            Activity.MODE_PRIVATE, null);
    EditText mEditID= (EditText) findViewById(R.id.inputID);
    EditText mEditName= (EditText) findViewById(R.id.inputName);
    EditText mEditPrice= (EditText) findViewById(R.id.inputPrice);
    EditText mEditStore= (EditText) findViewById(R.id.inputStore);


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        sd.execSQL("CREATE TABLE IF NOT EXISTS basetable(id INT,name TEXT,price double,store TEXT)");
    }

    public void insertInfo(View view){
        String id = mEditID.getText().toString();
        String name = mEditName.getText().toString();
        String price = mEditPrice.getText().toString();
        String store = mEditStore.getText().toString();

        sd.execSQL("INSERT INTO basetable VALUES("+id+","+name+","+price+","+store+")");
    }

    public void deleteInfo(View view){
        sd.execSQL("DELETE FROM basetable");
    }

    public void showInfo(View view){
        Cursor cursor = sd.rawQuery("SELECT * FROM basetable", null);
        TextView textview1 = (TextView) this.findViewById(R.id.showInfo);
        textview1.setText("");
        while (cursor.moveToNext()) {

            int id = cursor.getInt(0);
            String name = cursor.getString(1);
            double price = cursor.getDouble(2);
            String store = cursor.getString(3);
            textview1.append("" + id + "," + name + "," + price + ","+store+"\r\n");
        }
    }
}

xml部分就不贴了。三个Editview，两个按钮操作插入数据和删除。