dimanche 13 mars 2016

How to create stable SQLite database

What i need is here: http://ift.tt/1Lkht1h

3 Columns with data that i input in code, but i dont know how to do this

Here is what done with code:

public abstract class LibSQL extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "BazaSQL";
private String tableName;
private String[] columns;

String[] getColumns = {"ID ", "Polish ", "English "};



public LibSQL(Context context, String tableName, String[] columns){
    super(context, DATABASE_NAME, null, 1);
    this.tableName = tableName;
    this.columns = columns;
}
@Override
public void onCreate(SQLiteDatabase db){
    String sql = "create table " + tableName +
            " (" + BaseColumns._ID + " integer primary key autoincrement ";

    for (int i=0;i<columns.length;i++){
        sql+=", "+columns[i];

    }
    sql+=" ) ";

    db.execSQL(sql);
}

}

How to put data for each column, like: id 1, 2, 3, 4, 5.... and every text for other columns? Im a green :(

Aucun commentaire:

Enregistrer un commentaire