Below is the DB coding for creating Table Visitors to store name and adress of place
public class DbFav {
static final String DataBaseName = "Favdb";
static final String favtable = "Visiters";
static final String ColNam="Name";
static final String ColAdd="Address";
public static final int DATABASE_VERSION = 3;
private static final String REGISTER_TABLE_CREATE ="Create table " + favtable + "("+ColNam + " INTEGER PRIMARY KEY AUTOINCREMENT, " + ColAdd+ " VARCHAR(15)) ";
private final Context context;
private DatabaseHelper DBHelper;
private SQLiteDatabase db;
public DbFav(Context ctx){
this.context = ctx;
DBHelper = new DatabaseHelper(context);
}
private static class DatabaseHelper extends SQLiteOpenHelper{
public DatabaseHelper(Context context){
super(context, DataBaseName, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(REGISTER_TABLE_CREATE);
}
public DbFav open() throws SQLException{
db = DBHelper.getWritableDatabase();
return this;
}
public void close(){
DBHelper.close();
}
public long insert(String Name,String Address ) {
ContentValues initialValues = new ContentValues();
initialValues.put(ColNam,Name); //key , value
initialValues.put(ColAdd,Address);
Log.i("Values Inserted","Values are inserted");
return db.insert(favtable, null,initialValues);
}
Values to be saved to the DB from below coding which gives the exception of Visitors contain no Col named (Name, Address)
get_place=trname.getText().toString();
get_add=tradd.getText().toString();
db.open();
db.insert(get_place,get_add);
db.close();
Aucun commentaire:
Enregistrer un commentaire