title: Setting a value in one class and retrieving from another class in Java (Android app)
body: <p>I am setting an id from my Main class when the user enters it on start of the app. taking that I set it in a class called GetSet.java which also has a method to return it on being called. So I need the id set from this first class in a class called MySQLitehelper.java so I can retrieve the data according to the id set instead of hardcoding it. This will make my app dynamic rather than static. Here is my Code:</p>
  
  <p>/<em>----MainActivity.java-----</em>/</p>
  
  <pre><code>public class MainActivity extends Activity {
  
  EditText etGWid;
  Button OKbtn;
  
  public final static String EXTRA_MESSAGE = "com.example.myfirstapp.MESSAGE";
  
  @Override
  protected void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);
      setContentView(R.layout.activity_main);
  
  
      etGWid = (EditText)findViewById(R.id.etGWID);
      OKbtn = (Button)findViewById(R.id.OKbtn);
  
      final GetSet obj_getset = new GetSet();
      //MySQLitehelper db = new MySQLitehelper(null);
  
      final SharedPreferences app_preferences = PreferenceManager.getDefaultSharedPreferences(this);  
              // Create a shared preferences variable using the SharedPreferenceManager for storing GWids
  
      SharedPreferences.Editor editor = app_preferences.edit();  // We also need a shared preferences editor to handle the shared preference requests
      // Call the edit method (library function) to editor variable can edit the key, values.
  
      editor.putInt("47688507", 47688507);   // put in the shared preferences values of user GWids and give them a key for retrieval purposes
      editor.putInt("1234567", 1234567);
      editor.putInt("7654321", 7654321);
  
      editor.commit();   //commit is necessary to save the shared preferences
  
  
  
      OKbtn.setOnClickListener(new View.OnClickListener() {
  
  
          @Override
          public void onClick(View arg0) {
              // TODO Auto-generated method stub
  
              String gwidCheck = etGWid.getText().toString();  //get the value user enters for GWid
  
              if(app_preferences.contains(gwidCheck))       // this will check the stored shared preferences and compare with the value entered
              {
                  Context context = getApplicationContext();
                  CharSequence text = "Login Successfull";
                  int duration = Toast.LENGTH_SHORT;                              //If it exists, then create a toast message for success
  
  
  
                  //etGWid.setText("");    // make the textbox empty
                  long setid = Long.parseLong(gwidCheck);   // take the string gwid and convert to long
                  obj_getset.setId(setid);    // set the gwid entered
  
  
  
                  Toast toast = Toast.makeText(context, text, duration);
                  toast.show();
                  intentfunction();
              } 
              else
              {
                  Context context = getApplicationContext();
                  CharSequence text = "Login Failed";                     // If doesnt exist, create a toast for fail
                  int duration = Toast.LENGTH_SHORT;
  
                  Toast toast = Toast.makeText(context, text, duration);
                  toast.show();
              }
  
          }
      });
  }
  
  
  private void intentfunction()
  {
       Intent intent = new Intent(this, SelectOptions.class);
       //editText = (EditText) findViewById(R.id.editText1);
       //editText = new EditText(this);
       etGWid.setText("");   //set the edit text to blank
      String message = "TestHello";
      intent.putExtra(EXTRA_MESSAGE, message);
      startActivity(intent);
  
  }
  @Override
  public boolean onCreateOptionsMenu(Menu menu) {
      // Inflate the menu; this adds items to the action bar if it is present.
      getMenuInflater().inflate(R.menu.activity_main, menu);
      return true;
  }
  
  }
  
  /*-----GetSet.java----*/
  
  public class GetSet {
  
  long gwid=0;
  
  public void setId(long id)
  {
      gwid = id;
  }
  
  public long getId()
  {
      return gwid;
  }
  
  }
  </code></pre>
  
  <p>/<em>---MySQLitehelper.java---</em>/</p>
  
  <pre><code>public class MySQLitehelper {
  
  //public static final String TABLE_COMMENTS = "comments";
    public static final String COLUMN_ID = "GWid";
    public static final String COLUMN_DATE = "DateGWU";
    public static final String COLUMN_LOCATION = "location";
    public static final String COLUMN_TIME = "time";
  
    public static final String TABLE_NAME = "UPDTable";
  
    private static final String DATABASE_NAME = "UPDdb_version6";
    private static final int DATABASE_VERSION = 6;
  
    private final Context context;
    GetSet getset = new GetSet();
    public void GetIdForGwid(GetSet get)
    {
       getset=get; 
    }
  
    // Database creation sql statement
    private static final String DATABASE_CREATE = "CREATE TABLE " + TABLE_NAME +
                                  " (" +COLUMN_ID+ " integer," + COLUMN_DATE + " VARCHAR," +
                                  COLUMN_LOCATION+" VARCHAR," +COLUMN_TIME +" VARCHAR);";
  
  //  private static final String DATABASE_INSERT = "INSERT INTO " +TABLE_NAME +
  //                                              " Values (47688507,'DEC-07-2012','MARVIN 203','20:00');";
  
    private static final String DATABASE_INSERT = "INSERT INTO " +TABLE_NAME +  " (" +COLUMN_ID+ " ," + COLUMN_DATE + "," +
            COLUMN_LOCATION+" ," +COLUMN_TIME +" )"  +
                            " Values (47688507,'DEC-07-2012','MARVIN 203','20:00');";
  
  
  
    DatabaseHelper dbhelper;
    SQLiteDatabase db;
  
  
  
  
   public MySQLitehelper(Context ctx)
    {
        this.context = ctx;
        dbhelper = new DatabaseHelper(ctx);
    }
  
  
  
  private static class DatabaseHelper extends SQLiteOpenHelper {
  
       public DatabaseHelper(Context context)
       {
           super(context,DATABASE_NAME, null,DATABASE_VERSION);
       }
  
   @Override
  public void onCreate(SQLiteDatabase db) {
      // TODO Auto-generated method stub
      db.execSQL(DATABASE_CREATE);            //execute create table
      db.execSQL(DATABASE_INSERT);            //execute insert query
      db.execSQL("INSERT INTO " +TABLE_NAME +  " (" +COLUMN_ID+ " ," + COLUMN_DATE + "," +COLUMN_LOCATION+" ," +COLUMN_TIME +" )" +" Values (47688507,'DEC-22-2012','OLD MAIN','23:00');");
      db.execSQL("INSERT INTO " +TABLE_NAME +  " (" +COLUMN_ID+ " ," + COLUMN_DATE + "," +COLUMN_LOCATION+" ," +COLUMN_TIME +" )" +" Values (1234567,'DEC-14-2012','FUNGER','12:00');");
      db.execSQL("INSERT INTO " +TABLE_NAME +  " (" +COLUMN_ID+ " ," + COLUMN_DATE + "," +COLUMN_LOCATION+" ," +COLUMN_TIME +" )" +" Values (7654321,'DEC-29-2012','GELMAN','22:00');");
      db.execSQL("INSERT INTO " +TABLE_NAME +  " (" +COLUMN_ID+ " ," + COLUMN_DATE + "," +COLUMN_LOCATION+" ," +COLUMN_TIME +" )" +" Values (47688507,'DEC-12-2012','IVORY','23:00');");
   }
  
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      // TODO Auto-generated method stub
      Log.w(MySQLitehelper.class.getName(),
              "Upgrading database from version " + oldVersion + " to "
                  + newVersion + ", which will destroy all old data");
          db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
          onCreate(db);
      }
  }
  
  
  // open the DB
   public MySQLitehelper open() throws SQLException
   {
      System.out.println("Inside open function");
       db = dbhelper.getWritableDatabase();
      return this;
   }
  
   public void close()
   {
       dbhelper.close();
   }
  
  
  
   public void insertRecord(long gwid, String date, String location, String time)
       {
             ContentValues initialValues = new ContentValues();
            initialValues.put(COLUMN_ID, gwid);
            initialValues.put(COLUMN_DATE, date);
            initialValues.put(COLUMN_LOCATION, location);
            initialValues.put(COLUMN_TIME, time);
            db.insert(TABLE_NAME, null, initialValues);
       }
  
  public Cursor getAllrows()      //function to get all rows in the DB. Testing initially.
  {
  
       Cursor cur = db.rawQuery("SELECT * FROM "+TABLE_NAME, null);
       return cur;
  }
  
  public Cursor getRecord() throws SQLException
  {
          Cursor mCursor =
          db.query(true, TABLE_NAME, new String[] {COLUMN_ID,
          COLUMN_DATE, COLUMN_LOCATION, COLUMN_TIME},
          COLUMN_ID + "= 47688507", null, null, null, null, null);   //HARDCODED. Please make it dynamic
          if (mCursor != null) 
          {
              mCursor.moveToFirst();
          }
   return mCursor;
   }
  
  }
  </code></pre>
  
  <p>I am retrieving it in the getRecord() method in the above class right at the bottom,instead of <code>COLUMN_ID + "= 47688507</code> i wish to get the set value from the <code>GetSet</code> class ( <code>getId</code> method) and replace it in place of <code>47688507</code>. Any suggestions ?</p>