I want to get the String taken from SQLite db and write it into a textview.
Here's the code for my MainClass which tries to call the value from SQLite db :
public class MainActivity extends Activity {
    private ChosenSlotDAO chosenSlotDAO = new ChosenSlotDAO(this);
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_PORTRAIT);
        //String hoho = "Hohoho";
        chosenSlotDAO.open();
        TextView chosenSlotView = (TextView) findViewById(R.id.chosenSlotTView);
            String slots = chosenSlotDAO.getSlot();
            chosenSlotDAO.createSlot(slots);
            if(slots == null)
            {
                chosenSlotView.setText("You have not parked");
            }
            else
            {
                chosenSlotView.setText(slots);
            }
            chosenSlotDAO.close();
    }
What I am trying to do here is to automatically show user's parking location.
I have this snippet in my MainMap class which comes after tapping NFC at the entrance of the parking slot :
chosenSlotDAO.open();
chosenSlotDAO.dropTable();
chosenSlotDAO.close();
So basically whenever user taps the entrance NFC the table is dropped to show that user isn't parked(this is a software prototype, it is supposed to be exit NFC, but as exit is not in the scope of my application development, as a convenience, I placed the code in entrance).
This is my dropTable() code :
public void dropTable() {
          database.execSQL("DROP TABLE IF EXISTS " + ChosenSlotDatabaseHandler.TABLE_CHOSEN_PARKING_SLOT);
      }
Does the drop table mess with the value inside the textview?
 
Aucun commentaire:
Enregistrer un commentaire