public void onClick(View v) { TextView idTextView = (EditText) findViewById(R.id.idEditText); TextView timeTextView = (TextView) findViewById(R.id.timeTextView); TextView signalStrengthTextView = (TextView) findViewById(R.id.signalStrengthTextView); TextView connectionTypeTextView = (TextView) findViewById(R.id.connectionTypeTextView); TextView downloadSpeedTextView = (TextView) findViewById(R.id.downloadSpeedTextView); TextView uploadSpeedTextView = (TextView) findViewById(R.id.uploadSpeedTextView); EditText noteEditText = (EditText) findViewById(R.id.noteEditText); DataCollectorDbHelper dbHelper = new DataCollectorDbHelper(getApplicationContext()); SQLiteDatabase db = dbHelper.getWritableDatabase(); ContentValues values = new ContentValues(); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_ENTRY_ID, idTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_TIME, timeTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_SIGNAL_STRENGTH, signalStrengthTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_CONNECTION_TYPE, connectionTypeTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_DOWNLOAD_SPEED, downloadSpeedTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_UPLOAD_SPEED, uploadSpeedTextView.getText().toString()); values.put( DataCollectorContract.DataEntry.COLUMN_NAME_NOTE, noteEditText.getText().toString()); db.insert(DataCollectorContract.DataEntry.TABLE_NAME, "null", values); db.close(); Context context = getApplicationContext(); CharSequence text = "Data Saved Successfully!"; int duration = Toast.LENGTH_SHORT; Toast toast = Toast.makeText(context, text, duration); toast.show(); }
@Override public void onClick(DialogInterface dialog, int which) { switch (which) { case DialogInterface.BUTTON_POSITIVE: // Yes button clicked DataCollectorDbHelper dbHelper = new DataCollectorDbHelper(getApplicationContext()); SQLiteDatabase db = dbHelper.getWritableDatabase(); db.execSQL("delete from " + DataCollectorContract.DataEntry.TABLE_NAME); db.close(); Context context = getApplicationContext(); CharSequence text = "Database cleared. Save next entry twice."; int duration = Toast.LENGTH_SHORT; Toast toast = Toast.makeText(context, text, duration); toast.show(); break; case DialogInterface.BUTTON_NEGATIVE: // No button clicked break; } }
public void onClick(View v) { DataCollectorDbHelper dbHelper = new DataCollectorDbHelper(getApplicationContext()); SQLiteDatabase db = dbHelper.getWritableDatabase(); String[] projection = { DataCollectorContract.DataEntry._ID, DataCollectorContract.DataEntry.COLUMN_NAME_ENTRY_ID, DataCollectorContract.DataEntry.COLUMN_NAME_TIME, DataCollectorContract.DataEntry.COLUMN_NAME_SIGNAL_STRENGTH, DataCollectorContract.DataEntry.COLUMN_NAME_CONNECTION_TYPE, DataCollectorContract.DataEntry.COLUMN_NAME_DOWNLOAD_SPEED, DataCollectorContract.DataEntry.COLUMN_NAME_UPLOAD_SPEED, DataCollectorContract.DataEntry.COLUMN_NAME_NOTE }; String sortOrder = DataCollectorContract.DataEntry._ID + " ASC"; Cursor c = db.query( DataCollectorContract.DataEntry.TABLE_NAME, projection, null, null, null, null, sortOrder); SimpleDateFormat df = new SimpleDateFormat("dMMMyyyyHHmmss"); String date = df.format(Calendar.getInstance().getTime()); File sdCard = Environment.getExternalStorageDirectory(); File exportFile = new File(sdCard, "COMP635-Exported-" + date + ".csv"); try { FileWriter fw = new FileWriter(exportFile); fw.append("HAI"); String headerString = DataCollectorContract.DataEntry.COLUMN_NAME_ENTRY_ID + "," + DataCollectorContract.DataEntry.COLUMN_NAME_TIME + "," + DataCollectorContract.DataEntry.COLUMN_NAME_SIGNAL_STRENGTH + "," + DataCollectorContract.DataEntry.COLUMN_NAME_CONNECTION_TYPE + "," + DataCollectorContract.DataEntry.COLUMN_NAME_DOWNLOAD_SPEED + "," + DataCollectorContract.DataEntry.COLUMN_NAME_UPLOAD_SPEED + "," + DataCollectorContract.DataEntry.COLUMN_NAME_NOTE + "\n"; fw.append(headerString); c.moveToFirst(); while (c.moveToNext()) { String id = c.getString( c.getColumnIndex(DataCollectorContract.DataEntry.COLUMN_NAME_ENTRY_ID)); String time = c.getString(c.getColumnIndex(DataCollectorContract.DataEntry.COLUMN_NAME_TIME)); String signalStrength = c.getString( c.getColumnIndex( DataCollectorContract.DataEntry.COLUMN_NAME_SIGNAL_STRENGTH)); String connectionType = c.getString( c.getColumnIndex( DataCollectorContract.DataEntry.COLUMN_NAME_CONNECTION_TYPE)); String downloadSpeed = c.getString( c.getColumnIndex(DataCollectorContract.DataEntry.COLUMN_NAME_DOWNLOAD_SPEED)); String uploadSpeed = c.getString( c.getColumnIndex(DataCollectorContract.DataEntry.COLUMN_NAME_UPLOAD_SPEED)); String note = c.getString(c.getColumnIndex(DataCollectorContract.DataEntry.COLUMN_NAME_NOTE)); String line = id + "," + time + "," + signalStrength + "," + connectionType + "," + downloadSpeed + "," + uploadSpeed + "," + note + "\n"; fw.append(line); } fw.flush(); fw.close(); } catch (Exception e) { db.close(); Context context = getApplicationContext(); CharSequence text = "Export Failed :("; int duration = Toast.LENGTH_SHORT; Toast toast = Toast.makeText(context, text, duration); toast.show(); } db.close(); Context context = getApplicationContext(); CharSequence text = "Data Exported Successfully!"; int duration = Toast.LENGTH_SHORT; Toast toast = Toast.makeText(context, text, duration); toast.show(); }