Room List Source

public class RoomList extends Activity {

    final Context context = this;
    private ListView lvItem;
    private ArrayList<String> itemArrey;
    private ArrayAdapter<String> itemAdapter;
    public String value = CreateClient.getName();
    public static String selectedRoom;
    public int roomID;
    public static String r_id;
    SQLiteDatabase sampleDB;
    public ImageButton edit, seeImage, delete, next;
    public String bValue = CreateBuilding.buildingToView();
    ImageView jpgView;
    Button okButton;
    public String clientName;

    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.roomlist);

        next = (ImageButton) findViewById(R.id.next);
        next.setVisibility(View.INVISIBLE);
        next.setEnabled(false);

        edit = (ImageButton) findViewById(R.id.editroom);
        edit.setAlpha(127);
        edit.setEnabled(false);

        seeImage = (ImageButton) findViewById(R.id.seeimage);
        seeImage.setAlpha(127);
        seeImage.setEnabled(false);

        delete = (ImageButton) findViewById(R.id.deleteButton);
        delete.setAlpha(127);
        delete.setEnabled(false);

        lvItem = (ListView)this.findViewById(R.id.expandableListView1);
        lvItem.setTextFilterEnabled(true);

        itemArrey = new ArrayList<String>();
        itemArrey.clear();

        itemAdapter = new ArrayAdapter<String>(getApplicationContext(), R.layout.single_item,itemArrey);
        lvItem.setAdapter(itemAdapter);

        if(value == "Retrieve"){
            sampleDB = getBaseContext().openOrCreateDatabase(ClientList.retrievedClient+".db", MODE_PRIVATE, null);
            clientName = ClientList.retrievedClient;
        }
        else if (value == "Create"){
            sampleDB = getBaseContext().openOrCreateDatabase(CreateClient.createdClient+".db", MODE_PRIVATE, null);
            clientName = CreateClient.createdClient;
        }

        Toast.makeText(getApplicationContext(), "VALUE="+value, Toast.LENGTH_LONG).show();

        Cursor c = sampleDB.rawQuery("SELECT * FROM tbl_roomDesc WHERE b_id =?", new String[] {BuildingList.newBuildingID});

        if (c != null ) {
            if  (c.moveToFirst()) {
                do {
                    String roomName = c.getString(c.getColumnIndex("roomName"));
                    itemArrey.add(roomName);

                }while (c.moveToNext());
            }
        }
        c.close();

        lvItem.setOnItemClickListener(new OnItemClickListener() {
                public void onItemClick(AdapterView<?> parent, View view, int position, long id) {

                    // When clicked, show a toast with the TextView text
                    next.setEnabled(true);
                    next.setVisibility(View.VISIBLE);
                    edit.setEnabled(true);
                    edit.setAlpha(255);
                    seeImage.setEnabled(true);
                    seeImage.setAlpha(255);
                    delete.setEnabled(true);
                    delete.setAlpha(255);

                    for(int a=0; a<parent.getChildCount(); a++){
                        parent.getChildAt(a).setBackgroundColor(Color.WHITE);
                    }

                    view.setBackgroundColor(Color.parseColor("#97C361"));
                    selectedRoom = (String) ((TextView) view).getText();
                    Cursor c2 = sampleDB.rawQuery("SELECT * FROM tbl_roomDesc WHERE roomName =?", new String[] {selectedRoom});

                    if (c2 != null ) {
                        if  (c2.moveToFirst()) {
                            do {
                                r_id = c2.getString(c2.getColumnIndex("r_id"));
                            }while (c2.moveToNext());
                        }
                    }
                    c2.close();
                }
            });

        next = (ImageButton) findViewById(R.id.next);
        next.setOnClickListener(new View.OnClickListener() {
            public void onClick(View view) {

                CreateBuilding.val = "Retrieve";
                sampleDB.close();
                Intent intent2 = new Intent(RoomList.this, TabLayoutActivity.class);
                setResult(RESULT_OK, intent2);
                finish();
                startActivityForResult(intent2, 0);
            }
        });
    }
}