How to send a select made by a StringBuffer to a class

Question

How to send a select made by a StringBuffer to a class

Navigation

#1 by (0 votes)

0

I do not know how to send a select into my DatabaseHelper class and send it to a public class, so from there make my code work normally.

My DatabaseHelper class and at the end select :

class AddressBookDatabaseHelper extends SQLiteOpenHelper {
    private static final String DATABASE_NAME = "Forca.db";
    private static final int DATABASE_VERSION = 1;

    // constructor
    public AddressBookDatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    // creates the contacts table when the database is created
    @Override
    public void onCreate(SQLiteDatabase db) {
        // SQL for creating the contacts table
        final String CREATE_CONTACTS_TABLE =
                "CREATE TABLE " + Contact.TABLE_NAME + "(" +
                        Contact._ID + " integer primary key, " +
                        Contact.COLUMN_WORD + " TEXT, " +
                        Contact.COLUMN_TIP + " TEXT);";
        db.execSQL(CREATE_CONTACTS_TABLE); // create the contacts table
    }

    // normally defines how to upgrade the database when the schema changes
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    }

/* SELECT RANDOM */
    private void Exemplo(){
        List<String> dados = new ArrayList();
        SQLiteDatabase db = getReadableDatabase();
        String selectQuery = "SELECT palavra FROM palavrasforca";
        Cursor cursor = db.rawQuery(selectQuery, null);

        if (cursor.moveToFirst()) {
            do{
                String palavra = cursor.getString(cursor.getColumnIndex("palavra"));
                dados.add(palavra);
            }while (cursor.moveToNext());
        }
        //aqui dados terá todos os valores do banco
    }

}

And now the class I want to send to:

public class Palavras {

    private String[] palavras = new String[] {/* Gravar os valores da coluna aqui*/};

    public Palavras() {

    }

    public String sorteio() {
        String palavraSorteada = palavras[(int)(random()*palavras.length)];

        return palavraSorteada;
    }

    public static double random() {
        Random r = new Random();

        return r.nextDouble();
    }
}

I would like to know how I could write the select data in private String[] palavras = new String[] {};

android sqlite

asked by anonymous 14.06.2016 / 00:07

1 answer

Instantiate Unit of Work with only 1 context. EF 6 Simple Injector Struct with char vector

score 0 · Answer 1

You create a set for the property or change it to public eg

public class Palavras {
    public String[] palavras = new String[] 
}

and you would call it that way

public void Exemplo2(){
   Palavras palavras = new Palavras(); //instancia o objeto
   palavras.palavras = new String[] {"exemplo1", "exemplo2"} //aqui você trocaria pelo array que você quer passar
}

You can do via builder too (which is most recommended)

public class Palavras {

    private String[] palavras = new String[] {/* Gravar os valores da coluna aqui*/};

    public Palavras(String[] arrayPalavras) {
        this.palavras = arrayPalavras;
    }

    public String[] getPalavras(){
       return palavras;
    } 
}

and use it this way:

public void Exemplo2(){
       String dados = new String[] {"exemplo1", "exemplo2"}
       Palavras palavras = new Palavras(dados); //instancia o objeto //aqui é obrigado a passar "dados" para construir a classe Palavras
       String dados2 = palavras.getPalavras(); //'dados2' contém mesmo que 'dados'

    }