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);
이부분을 이용해서 화면에 리스트뷰를 만들엇는데요~~ 근데 이 리스트뷰 밑에 버튼 하나만들고 싶은데
어떻게 해야될지 몰라서요 ㅠㅠ
고수님들 부탁드려요~