MainActivity.java

package none.treego;

import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.support.design.widget.NavigationView;
import android.support.v4.view.GravityCompat;
import android.support.v4.widget.DrawerLayout;
import android.support.v7.app.ActionBarDrawerToggle;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.Button;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity implements NavigationView.OnNavigationItemSelectedListener {
    dbOfflineExtension offlineDB;
    public int pos1 = 1;
    public int pos2 = 1;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        DrawerLayout drawer = (DrawerLayout) findViewById(R.id.drawer_layout);
        ActionBarDrawerToggle toggle = new ActionBarDrawerToggle(
                this, drawer, toolbar, R.string.navigation_drawer_open, R.string.navigation_drawer_close);
        drawer.setDrawerListener(toggle);
        toggle.syncState();

        NavigationView navigationView = (NavigationView) findViewById(R.id.nav_view);
        navigationView.setNavigationItemSelectedListener(this);
        offlineDB = new dbOfflineExtension(this);
        Button btnShowState = (Button) findViewById(R.id.btnShowState);
        btnShowState.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                ShowcStates();
            }
        });

        Button btnShowCity = (Button) findViewById(R.id.btnShowCity);
        btnShowCity.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                ShowCities();
            }
        });

        Button btnShowNeighborhood = (Button) findViewById(R.id.btnShowNeighborhood);
        btnShowNeighborhood.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                ShowNeighborhoods();
            }
        });

        Button btnShowStreet = (Button) findViewById(R.id.btnShowStreet);
        btnShowStreet.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                ShowStreets();
            }
        });
    }

    public void ShowcStates() {
        TextView lblState = (TextView) findViewById(R.id.lblState);
        Cursor res = offlineDB.getAllcStates();
        res.moveToFirst();
        if (res.getCount() > 0) {
            lblState.setText(res.getString(1));
        } else {
            lblState.setText("Nenhum registro encontrado! ");
        }
    }

    public void ShowCities() {
        TextView lblCity = (TextView) findViewById(R.id.lblCity);
        Cursor res = offlineDB.getAllCities();
        res.moveToFirst();
        if (res.getCount() > 0) {
            lblCity.setText(res.getString(1));
        } else {
            lblCity.setText("Nenhum registro encontrado! ");
        }
    }

    public void ShowNeighborhoods() {
        TextView lblNeighborhood = (TextView) findViewById(R.id.lblNeighborhood);
        Cursor res = offlineDB.getAllNeighborhoods();
        if (res.getCount() > 0) {
            if (res.move(pos1)) {
                lblNeighborhood.setText(res.getString(1) + ", " + res.getString(0));
                pos1++;
            } else {
                res.moveToFirst();
                pos1 = 2;
                lblNeighborhood.setText(res.getString(1) + ", " + res.getString(0));
            }
        } else {
            lblNeighborhood.setText("Nenhum registro encontrado! ");
        }
    }

    public void ShowStreets() {
        TextView lblStreets = (TextView) findViewById(R.id.lblStreet);
        Cursor res = offlineDB.getAllStreets();
        if (res.getCount() > 0) {
            if (res.move(pos2)) {
                lblStreets.setText(res.getString(1) + ", " + res.getString(0));
                pos2++;
            } else {
                res.moveToFirst();
                pos2 = 2;
                lblStreets.setText(res.getString(1) + ", " + res.getString(0));
            }
        } else {
            lblStreets.setText("Nenhum registro encontrado! ");
        }
    }

    @Override
    public void onBackPressed() {
        DrawerLayout drawer = (DrawerLayout) findViewById(R.id.drawer_layout);
        if (drawer.isDrawerOpen(GravityCompat.START)) {
            drawer.closeDrawer(GravityCompat.START);
        } else {
            super.onBackPressed();
        }
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.main, menu);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        // Handle action bar item clicks here. The action bar will
        // automatically handle clicks on the Home/Up button, so long
        // as you specify a parent activity in AndroidManifest.xml.
        int id = item.getItemId();

        //noinspection SimplifiableIfStatement
        if (id == R.id.action_settings) {
            return true;
        }

        return super.onOptionsItemSelected(item);
    }

    @SuppressWarnings("StatementWithEmptyBody")
    @Override
    public boolean onNavigationItemSelected(MenuItem item) {
        int id = item.getItemId();
        if (id == R.id.nav_newtree) {
            Intent intent = new Intent(MainActivity.this, AddTreeActivity.class);
            startActivity(intent);
            finish();
        } else if (id == R.id.nav_sendtree) {

        } else if (id == R.id.nav_settings) {

        }
        DrawerLayout drawer = (DrawerLayout) findViewById(R.id.drawer_layout);
        drawer.closeDrawer(GravityCompat.START);
        return true;
    }
}