jeudi 16 juillet 2015

How can I delete task by ID instead of Taskname in Android?

I have an Task app and at this moment I can delete tasks by taskname, but how can I delete tasks by id? How is it possible to get id from database?

This my code for MainActivity

public class MainActivity extends AppCompatActivity {
private TaskDBHelper helper = new TaskDBHelper(MainActivity.this);
private ListAdapter listAdapter;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    updateUI();
}



protected void onRestart(){
       super.onRestart();
       updateUI();
   }


public void updateUI() {
    helper = new TaskDBHelper(MainActivity.this);
    SQLiteDatabase sqlDB = helper.getReadableDatabase();

    Cursor cursor = sqlDB.query(TaskContract.TABLE,
            new String[]{TaskContract.Columns._ID, TaskContract.Columns.TASK},
            null,null,null,null,null);

    listAdapter = new SimpleCursorAdapter(
            this,
            R.layout.task_view,
            cursor,
            new String[] { TaskContract.Columns.TASK},
            new int[] { R.id.taskTextView},
            0
    );

    ListView listView = (ListView)findViewById(R.id.list);
    listView.setAdapter(listAdapter);

}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.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);
}

public void startActivity(View view){
    Intent intent = new Intent(this, Additem.class);
    startActivity(intent);
}

public void onDoneButtonClick(View view) {
    View v = (View) view.getParent();
    TextView taskTextView = (TextView) v.findViewById(R.id.taskTextView);
    String task = taskTextView.getText().toString();

    String sql = String.format("DELETE FROM %s WHERE %s = '%s'",
            TaskContract.TABLE,
            TaskContract.Columns.TASK,task
            );

    helper = new TaskDBHelper(MainActivity.this);
    SQLiteDatabase sqlDB = helper.getWritableDatabase();
    sqlDB.execSQL(sql);
    updateUI();
    Log.d("delete", sql);




    updateUI();
    Log.d("delete", sql);

}

public void onRefresh(View view){

    updateUI();

  }
}

This is TaskContract:

public class TaskContract {
    public static final String DB_NAME = "com.example.agendaapp_a.db.tasks";
    public static final int DB_VERSION = 1;
    public static final String TABLE = "tasks";

    public class Columns {
        public static final String TASK = "task";
      //  public static final String _ID = BaseColumns._ID;
        public static final String _ID = "_id";
    }
}

And this is TaskDBHelper:

public class TaskDBHelper extends SQLiteOpenHelper {

public TaskDBHelper(Context context) {
    super(context, TaskContract.DB_NAME, null, TaskContract.DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase sqlDB) {
    String sqlQuery =
            String.format("CREATE TABLE %s (" +
                            "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                            "%s TEXT)", TaskContract.TABLE,
                    TaskContract.Columns.TASK);

    Log.d("TaskDBHelper", "Query to form table: " + sqlQuery);
    sqlDB.execSQL(sqlQuery);
}

@Override
public void onUpgrade(SQLiteDatabase sqlDB, int i, int i2) {
    sqlDB.execSQL("DROP TABLE IF EXISTS "+TaskContract.TABLE);
    onCreate(sqlDB);
  }
}

Aucun commentaire:

Enregistrer un commentaire