title: Insert radio button value in to database
body: <p>I want to make an app that can collect people's information and add into a database. But I have some problem with inserting the selected radiobutton value in to the database.</p>
  
  <pre><code>public class MainActivity extends Activity {
     SQLiteDatabase pf;
  
     TableRow tablerow;
     TextView t,t1,t2,t3,t4,t5;    
     String first_name,last_name;
  
  
  @Override
  protected void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);
      setContentView(R.layout.activity_main);
      pf=openOrCreateDatabase("Profile",MODE_PRIVATE,null);
      pf.execSQL("CREATE TABLE IF NOT EXISTS Persone(first_name VARCHAR,last_name VARCHAR,Usergender VARCHAR);");
  }
  
  public void RadioButtonClicked(View view) {
  
      //This variable will store whether the user was male or female
      String userGender=""; 
      // Check that the button is  now checked?
      boolean checked = ((RadioButton) view).isChecked();
  
      // Check which radio button was clicked
      switch(view.getId()) {
          case R.id.radio_female:
              if (checked)
                  userGender = "female";
              break;
          case R.id.radio_male:
              if (checked)
                 userGender = "male";
              break;
      }
      pf.execSQL("INSER INTO Persone VALUES('"+userGender+"');");
  }
  
  public void add(View view){
      EditText fn  = (EditText)findViewById(R.id.first_name);
      EditText ln   = (EditText)findViewById(R.id.last_name);
  
      first_name=fn.getText().toString();
      last_name =ln.getText().toString();
  
      pf.execSQL("INSERT INTO Persone VALUES('"+first_name+"','"+last_name+"');");
  }
  
  
  
  public void show(View view){
      Cursor c = pf.rawQuery("SELECT * FROM Persone", null);
      int count = c.getCount();
      c.moveToFirst();
      TableLayout tablelayout = new TableLayout(getApplicationContext());
      tablelayout.setVerticalScrollBarEnabled(true);
      TableRow tablerow;
      TextView t,t1,t2,t3,t4,t5;
      tablerow = new TableRow(getApplicationContext());
  
      t = new TextView(getApplicationContext());
      t.setText("First Name");
      t.setTextColor(Color.RED);
      t.setTypeface(null,Typeface.BOLD);
      t.setPadding(20,20,20,20);
      tablerow.addView(t);
  
      t3 = new TextView(getApplicationContext());
      t3.setText("Last Name");
      t3.setTextColor(Color.RED);
      t3.setTypeface(null,Typeface.BOLD);
      t3.setPadding(20,20,20,20);
      tablerow.addView(t3);
  
      t4 = new TextView(getApplicationContext());
      t4.setText("Gender");
      t4.setTextColor(Color.RED);
      t4.setTypeface(null,Typeface.BOLD);
      t4.setPadding(20,20,20,20);
      tablerow.addView(t4);
  
      tablelayout.addView(tablerow);
      for(Integer j = 0;j&lt;count;j++)
      {
        tablerow = new TableRow(getApplicationContext());
  
        t1 = new TextView(getApplicationContext());
        t1.setText(c.getString(c.getColumnIndex("first_name")));
        t1.setPadding(20, 20, 20, 20);
  
  
        t2 = new TextView(getApplicationContext());
        t2.setText(c.getString(c.getColumnIndex("last_name")));
        t2.setPadding(20, 20, 20, 20);
  
        t5 = new TextView(getApplicationContext());
        t5.setText(c.getString(c.getColumnIndex("userGender")));
        t5.setPadding(20, 20, 20, 20);
  
  
  
        tablerow.addView(t1);
        tablerow.addView(t2);
        tablerow.addView(t5);
  
  
        tablelayout.addView(tablerow);
  
        c.moveToNext();
      }
      setContentView(tablelayout);
      pf.close();
  }
  </code></pre>
  
  <p><br></p>
  
  <pre><code>&lt;RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
      xmlns:tools="http://schemas.android.com/tools"
      android:layout_width="match_parent"
      android:layout_height="match_parent"
      android:paddingBottom="@dimen/activity_vertical_margin"
      android:paddingLeft="@dimen/activity_horizontal_margin"
      android:paddingRight="@dimen/activity_horizontal_margin"
      android:paddingTop="@dimen/activity_vertical_margin"
      tools:context="com.example.mythirdapp.MainActivity" &gt;
  
      &lt;TextView
          android:id="@+id/textView2"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignLeft="@+id/textView1"
          android:layout_below="@+id/textView1"
          android:layout_marginTop="14dp"
          android:text="@string/last_name"
          android:textAppearance="?android:attr/textAppearanceMedium" /&gt;
  
      &lt;EditText
          android:id="@+id/first_name"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignBaseline="@+id/textView1"
          android:layout_alignBottom="@+id/textView1"
          android:layout_alignParentRight="true"
          android:layout_toRightOf="@+id/textView1"
          android:ems="10"
          android:inputType="textPersonName" &gt;
  
          &lt;requestFocus android:layout_width="match_parent" /&gt;
  
      &lt;/EditText&gt;
  
      &lt;TextView
          android:id="@+id/textView1"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignParentLeft="true"
          android:layout_alignParentTop="true"
          android:layout_marginTop="14dp"
          android:text="@string/first_name"
          android:textAppearance="?android:attr/textAppearanceMedium" /&gt;
  
      &lt;Button
          android:id="@+id/button1"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignParentBottom="true"
          android:layout_alignParentLeft="true"
          android:layout_marginBottom="16dp"
          android:onClick="add"
          android:text="@string/add" /&gt;
  
      &lt;Button
          android:id="@+id/Button01"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignBaseline="@+id/button1"
          android:layout_alignBottom="@+id/button1"
          android:layout_alignRight="@+id/last_name"
          android:onClick="show"
          android:text="@string/show" /&gt;
  
      &lt;EditText
          android:id="@+id/last_name"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignLeft="@+id/first_name"
          android:layout_below="@+id/textView1"
          android:ems="10"
          android:inputType="textPersonName" /&gt;
  
      &lt;TextView
          android:id="@+id/textView3"
          android:layout_width="wrap_content"
          android:layout_height="wrap_content"
          android:layout_alignLeft="@+id/textView2"
          android:layout_below="@+id/last_name"
          android:layout_marginTop="14dp"
          android:text="@string/gender"
          android:textAppearance="?android:attr/textAppearanceMedium" /&gt;
  
      &lt;RadioGroup
          android:id="@+id/radio_gender"
          android:layout_width="wrap_content"
          android:layout_height="fill_parent"
          android:layout_alignRight="@+id/Button01"
          android:layout_alignTop="@+id/textView3"
          android:layout_toRightOf="@+id/button1" &gt;
  
          &lt;RadioButton
              android:id="@+id/radio_female"
              android:text="@string/radio_female"
              android:onClick="RadioButtonClicked" /&gt;
  
          &lt;RadioButton
              android:id="@+id/radio_male"
              android:text="@string/radio_male" 
              android:onClick="RadioButtonClicked"/&gt;
  
      &lt;/RadioGroup&gt;
  
  &lt;/RelativeLayout&gt;
  </code></pre>
  
  <p>I want to get the value of the selected radiobutton and add it to the database. But when I run the Android simulator and the program, it says:</p>
  
  <blockquote>
    <p>unfortunately, MyThirdApp has stopped</p>
  </blockquote>
  
  <p>Can anyone help me?</p>
  
  <p>logcat:</p>
  
  <pre><code>10-02 06:36:51.319: E/SQLiteLog(1770): (1) near "INSER": syntax error
  10-02 06:36:51.399: E/AndroidRuntime(1770): FATAL EXCEPTION: main
  10-02 06:36:51.399: E/AndroidRuntime(1770): Process: com.example.mythirdapp, PID: 1770
  10-02 06:36:51.399: E/AndroidRuntime(1770): java.lang.IllegalStateException: Could not execute method of the activity
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.view.View$1.onClick(View.java:3823)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.view.View.performClick(View.java:4438)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.widget.CompoundButton.performClick(CompoundButton.java:100)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.view.View$PerformClick.run(View.java:18422)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.os.Handler.handleCallback(Handler.java:733)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.os.Handler.dispatchMessage(Handler.java:95)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.os.Looper.loop(Looper.java:136)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.app.ActivityThread.main(ActivityThread.java:5017)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at java.lang.reflect.Method.invokeNative(Native Method)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at java.lang.reflect.Method.invoke(Method.java:515)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at dalvik.system.NativeStart.main(Native Method)
  10-02 06:36:51.399: E/AndroidRuntime(1770): Caused by: java.lang.reflect.InvocationTargetException
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at java.lang.reflect.Method.invokeNative(Native Method)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at java.lang.reflect.Method.invoke(Method.java:515)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.view.View$1.onClick(View.java:3818)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     ... 12 more
  10-02 06:36:51.399: E/AndroidRuntime(1770): Caused by: android.database.sqlite.SQLiteException: near "INSER": syntax error (code 1): , while compiling: INSER INTO Persone VALUES('female');
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteProgram.&lt;init&gt;(SQLiteProgram.java:58)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteStatement.&lt;init&gt;(SQLiteStatement.java:31)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1672)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1603)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     at com.example.mythirdapp.MainActivity.RadioButtonClicked(MainActivity.java:56)
  10-02 06:36:51.399: E/AndroidRuntime(1770):     ... 15 more
  </code></pre>