Populating radio objects from android database

How can I fill radio lenses? The query will be "SELECT AnswerA, AnswerB, AnswerC from WHERE table id_test = 1"

You probably want to select those values ​​directly in the first query, so instead of:

Cursor c = adbh.query(bundle.getString("test")); 
    //"test"-->"SELECT question, image FROM table WHERE id_test = 1"

      

        
        
        
      

    

will have:

Cursor c = adbh.query(bundle.getString("test")); 
    //"test"-->"SELECT question, AnswerA,  AnswerB, AnswerC, image FROM table WHERE id_test = 1"

      

        
        
        
      

    

Then, in this loop, while

assign text RadioButton

as you did to TextView txtenun

.

And my last question is how can I fix the test. I think when storing (I don't know for sure) in an array and then compare with the correct answers.

Add OnCheckedChangeListener()

to all your RadioGroup

s. In this listener, you will get RadioGroup

where the user checked something and the ID of the checked one RadioButton

. Use this to build an array of correct answers.

Some tips:

Perhaps you should change the layout and your current approach. Giving the user a scroll through 30 question templates might not be such a good idea, also you are loading a lot of resources, although the user won't actually see them until they get to this particular question (I don't know the size of your image, if they are small it probably isn't problem). Other alternatives are a mock ListView

or a simple one-question mock that you fill out on demand, depending on what questions the user is on. My advice would be the second option. This parameter will also help you avoid method calls getIdentifier

, this method is slower than findViewById

that and should be avoided. The boot is a layout:

<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:background="#AAC1E2" >

    <LinearLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="vertical" >

        <ImageView
            android:id="@+id/questionImage"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" />

        <TextView
            android:id="@+id/questionText"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Enun"
            android:textAppearance="?android:attr/textAppearanceMedium" />

        <RadioGroup
            android:id="@+id/radioGroup1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content" >

            <RadioButton
                android:id="@+id/radio0"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:checked="true"
                android:text="RadioButton" />

            <RadioButton
                android:id="@+id/radio1"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="RadioButton" />

            <RadioButton
                android:id="@+id/radio2"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:text="RadioButton" />
        </RadioGroup>

        <LinearLayout
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:weightSum="3" >

            <Button
                android:id="@+id/previousQuestion"
                android:layout_width="wrap_content"
                android:layout_height="fill_parent"
                android:layout_weight="1"
                android:text="previous" />

            <Button
                android:id="@+id/validateTest"
                android:layout_width="wrap_content"
                android:layout_height="fill_parent"
                android:layout_weight="1"
                android:text="validate" />

            <Button
                android:id="@+id/nextQuestion"
                android:layout_width="wrap_content"
                android:layout_height="fill_parent"
                android:layout_weight="1"
                android:text="next" />
        </LinearLayout>
    </LinearLayout>

</ScrollView>

      

        
        
        
      

    

You will query for the entire question in this test (including all data) and start with a static field int counter = 0

. When the application is launched, you will move the cursor to the counter value (which is 0 at the beginning):

c.moveToPosition(counter);

      

        
        
        
      

    

and use the values ​​from that line to fill in the above question layout:

ImageView questionImage = (ImageView) findViewById(R.id.questionImage);
int idDrawable = getResources().getIdentifier(ruta, "drawable", this.getPackageName());
   questionImage.setImageResource(idDrawable);

String enun = c.getString(anotherIndex);
TextView txtenun = (TextView) findViewById(R.id.questionText);
txtenun.setText(enun);
// will do the same to populate the other parts of the question from the cursor

      

        
        
        
      

    

When the user clicks the button nextQuestion

Button

, you increment the value counter

(you have to do some validation so you don't go overboard with 30 questions), move the cursor to position counter

again, and then fill the layout as above. When the user clicks on the previous query, you zoom out counter

, move the cursor, and populate the layout with data again. Also you will only add one OnCheckedChangeListener

to yours RadioGroup

. When this listener fires, you have to store the question id (from the value counter

you should specify for which question) and selected RadioButton

in the data structure (possibly HashMap

), get the correct answers for the test from the database, and see if the user is a good driver.

Also you could (possibly) optimize your database.

Edit:

private ArrayList<Integer> responses = new ArrayList<Integer>(); // this will hold the number of the correct answer. Note that this will work if the user answers question one after the other
// if the user skips question you'll get in trouble, this is one of the reasons why your design is not so good.

String rg = "radioGroup" + i;
int idRg = getResources().getIdentifier(rg, "id", this.getPackageName());
RadioGroup radioGroup = (TextView) findViewById(idRg);
radioGroup.setOnChekedChangeListener(new OnCheckedChangeListener(){
       public void onCheckedChanged (RadioGroup group, int checkedId) {
            if (group.getChildAt(0).getId() == checkedId) {
               responses.add(0); // the first answer was checked
            } else if (group.getChildAt(1).getId() == checkedId) {
               responses.add(1); // the first answer was checked
            } else if (group.getChildAt(2).getId() == checkedId) {
               responses.add(2); // the first answer was checked
            }
      } 
});