vendredi 22 avril 2016

Error on inserting values to SQLite DB ?Can anyone solve this?

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