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