jeudi 10 décembre 2015

Adding another table in Database android

Can i use this way to add another table in my database? See my onupgrade i tried this way is it possible. and one thing is database upgraded everytime we Add or delete information.??

public class DataBaseOperations extends SQLiteOpenHelper {
public static final int DATABASE_VERSION = 1;
private static final String SQL_CREATE_ENTRIES = "CREATE TABLE "+
        mDatabase.Tableinfo.Table_Name +"("
        +mDatabase.Tableinfo.Name+" TEXT,"
        +mDatabase.Tableinfo.phone+" INTEGER,"
        +mDatabase.Tableinfo.status+" TEXT,"
        +mDatabase.Tableinfo.Pic+" BLOB"+")";
private static final String Contacts_Table = "CREATE TABLE "+
        mDatabase.Tableinfo.contacts +"("
        +mDatabase.Tableinfo.Contacts_id+" INTEGER PRIMARY KEY,"
        +mDatabase.Tableinfo.Contacts_name+" TEXT,"
        +mDatabase.Tableinfo.Contacts_phone+" INTEGER,"
        +mDatabase.Tableinfo.status_contact+" TEXT,"
        +mDatabase.Tableinfo.Contact_pic+" BLOB"+")";

public DataBaseOperations(Context context) {
    super(context, mDatabase.Tableinfo.Database_Name, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(SQL_CREATE_ENTRIES);


}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    if(newVersion==1){
    db.execSQL(SQL_CREATE_ENTRIES);
    onCreate(db);

  }
}

and this is my that contract class.

public class mDatabase {
public mDatabase(){
}
 public static abstract class Tableinfo{
 public static final String Name = "Name";
 public static final String status = "status";
 public static final String phone = "Phone";
 public static final String Pic  = "Pro_pic";
 public static final String Database_Name = "User_info.db";
 public static final String Table_Name = "User";
 public static final String contacts = "Contacts";
 public static final String Contacts_id= "Contact_id";
 public static final String Contacts_name = "Contacts name";
 public static final String Contacts_phone = "Contacts phone No";
 public static final String status_contact = "Status";
 public static final String Contact_pic = "pic";
}
}

Aucun commentaire:

Enregistrer un commentaire