This question already has an answer here:
I need to add multiple Table but when i insert basket table i get "no such table: BASKET (code 1):" Error
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseClass extends SQLiteOpenHelper {
static final String Database1="STUDENT_DB";
enter code here
static final int version=1;
public DatabaseClass(Context ctxt){
super(ctxt, Database1, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE STU_TABLE (id INTEGER PRIMARY KEY AUTOINCREMENT , name TEXT, surname TEXT, sid TEXT, mail TEXT);");
db.execSQL("CREATE TABLE BASKET (id INTEGER PRIMARY KEY AUTOINCREMENT , ProductName TEXT, value TEXT , date TEXT);");
}
@Override
public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
db.execSQL("DROP TABLE IF EXIST STU_TABLE");
db.execSQL("DROP TABLE IF EXIST Basket");
onCreate(db);
}
}
Aucun commentaire:
Enregistrer un commentaire