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