开发者

SqliteOpenHelper when it call OnCreate()Method

Hi I want to know when the Oncreate() method of SqliteOPenHelper will called when i am create Object of MyDatabase Manager class

Question is that when i run app it create database but table is not create and it throw exception table does not exit.

package pk.com.db;

import org.apache.http.Header;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.util.Log;

public class AdatabaseManager {

    // Constant through out the class we use

    private SQLiteDatabase sqlitedatabase; //reference to the database manaager 
    private final String DB_NAME = "MYBooks";
    private final int DB_VERSION= 1;


    //Now table name and it's fields

    private final String DB_TABLE="Book_Details"; //this all constant are use as Key
    private final String FK_ID="ID";
    private final String Field_ONE="NAME";
    private final String Field_TWO="PRICE";
    private final String Field_THREE="AUTHER";
    private CustomSqliteOpenHelper helper;

     private static final String DATABASE_CREATE =
            "create table if not exites Book_Details(_id integer primary key autoincrement, "
            + "NAME text not null,PRICE text not null, "
            + "AUTHER text not null);";



    public AdatabaseManager(Context context){
        helper=new CustomSqliteOpenHelper(context);
        this.sqlitedatabase=helper.getReadableDatabase();


    }
    public void openDb(){
        try
        {
            this.sqlitedatabase=helper.getWritableDatabase();



        }catch (Exception e) {

            Log.i(getClass().getName(), e.toString());
            System.out.print(e);
        }

    }
    public void closedb(){
        try{
            helper.close();

        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    public void addRow(String strName,String strPrice,String strAuother){
        try{

            ContentValues values=new ContentValues();
            values.put(Field_ONE,strName);
            values.put(Field_TWO,strPrice);
            values.put(Field_THREE,strAuother); 

            sqlitedatabase.insert(DB_TABLE,null,values);

        }catch (Exception e) {
            Log.i(getClass().getName(),e.toString());

        }       
    }

    private class CustomSqliteOpenHelper extends SQLiteOpenHelper
{
    public CustomSqliteOpenHelper(Context context){

        super(context,DB_NAME,null,DB_VERSION);

    }


    *开发者_JS百科*@Override
    public void onCreate(SQLiteDatabase db) {
    try{



            db.execSQL(DATABASE_CREATE);



    }catch (Exception e) {
        System.out.println("********************************");
        System.out.print(e);
        System.out.println("********************************");
    }

    }**

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }

}

}

Here i called my AdatabaseManager

//************************************
import android.app.Activity;
import android.os.Bundle;

public class activity_db extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        AdatabaseManager _adm=new AdatabaseManager(this);  //it think it open database 
       /* _adm.openDb();
        _adm.addRow("ANDROID EBOOKS","2999","KINGRAJARANN");
        _adm.closedb();*/


    }
}


At least part of the problem is a spelling error in your DATABASE_CREATE string:

 private static final String DATABASE_CREATE =
        "create table if not exites Book_Details(_id integer primary key autoincrement, "
        + "NAME text not null,PRICE text not null, "
        + "AUTHER text not null);";

The word "exists" is misspelled as "exites". Corrected, it would be:

 private static final String DATABASE_CREATE =
        "create table if not exists Book_Details(_id integer primary key autoincrement, "
        + "NAME text not null,PRICE text not null, "
        + "AUTHER text not null);";

By the way, your code doesn't show whether your openDB method is called anywhere. onCreate won't actually be called until you call getWritableDatabase, which is called through your openDB method.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜