package exam.com;

import java.util.ArrayList;
import java.util.List;

import android.app.ListActivity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.Toast;

public class search extends ListActivity{
 String result[]; int result2[];Cursor cursor;
    totaldb totalcon; SQLiteDatabase totdb;
    String resultt=""; int i=0;
    static String a; static int b;
   
    void setA(String a){
  this.a=a;
 }
 String getA(){
  return a;
 }
 int getB(){
  return b;
 }
 void setB(int b){
  this.b=b;
 }
 public void backbtn(String title,int addr){
  setA(title);
  setB(addr);     
     Intent intent=new Intent(search.this, total_sub.class);
     intent.putExtra(title,addr);
     startActivity(intent);
    }

 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  totalcon = new totaldb(this, "total", null, 1);
  totdb=totalcon.getWritableDatabase(); 
          
  Cursor cursor = totdb.rawQuery("select name,addr from totaldb",null);
  int i=0;
  result=new String[30]; result2=new int[30];
     cursor.moveToFirst();
        do{               
   String imsi=cursor.getString(0);
   int imsi2=cursor.getInt(1);
   result[i]=imsi;  result2[i]=imsi2;
   i++;
          }while(cursor.moveToNext()); 
       
     List<String> name = getnames();
  ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, name);
  setListAdapter(adapter);
  
 }
 }


 public List<String> getnames(){
  Cursor cursor = totdb.rawQuery("select name,addr from totaldb",null);
  List<String> result = new ArrayList<String>();
  cursor.moveToFirst();
  do{
   result.add(cursor.getString(0));
   
     }while (cursor.moveToNext());
  return result;
 }
 
}
DB에서 자료 받아와서
 ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, name);
  setListAdapter(adapter);
이부분을 이용해서 화면에 리스트뷰를 만들엇는데요~~  근데 이 리스트뷰 밑에 버튼 하나만들고 싶은데
어떻게 해야될지 몰라서요 ㅠㅠ
고수님들 부탁드려요~