dbcontent.JPG

 

 

DBHandler, DBHelper 있고요.


DBHandler 안에 메소드를 넣었습니다.

 

 

DBHandler


public boolean delete(long rowID) { // 레코드 삭제

return db.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowID, null) > 0;

}

 


리스트뷰에서 아이템을 클릭하면 상세 페이지로 넘어가고요.


상세 페이지에서 삭제 버튼을 누르면 그 행(row)이 삭제되면서 다시 리스트뷰 페이지로 돌아가게 하려 합니다.



TextView text_content;

TextView date_content;

TextView text_url;


@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.content);


Intent intent = getIntent();

String content_text = intent.getStringExtra("message_text");

String content_url = intent.getStringExtra("address");

String content_date = intent.getStringExtra("date");


text_content = (TextView) findViewById(R.id.tv1);

text_content.setText(String.valueOf(content_text));

text_url = (TextView) findViewById(R.id.tv2);

text_url.setText(String.valueOf(content_url));


date_content = (TextView) findViewById(R.id.date2);

date_content.setText(String.valueOf(content_date));


for (int btnId : BUTTONS) {

Button btnUnderButton = (Button) findViewById(btnId);

btnUnderButton.setOnClickListener(this);

}

}


public void onClick(View v) {

// TODO Auto-generated method stub


switch (v.getId()) {

/* 삭제를 구현한다. */


case R.id.btn_del:

                                                                                                                                                                                   

                                                                                                                                                                                   

                                                                                                                                                                                   

                                                                                                                                                                                   

                                                                                                                                                                                   

 

finish();

break;

}

case --------------------------------후략 --------------------

}

 

 


 

하늘색 공간에 여러 방법으로 DB로의 접근을 시도했는데요.


db.delete도 써보고 혹은 쿼리문도 써봤는데요. 답을 못찾겠네요.


조언 부탁드릴게요.

 

언뜻 기초적인 것처럼도 보이는데 막상 하면 너무 어려워요.