Day98 안드로이드 db Select문

<activity 
     android:name=".SelectActivity"></activity>

activity_select.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >
    <ListView 
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/select_listview"></ListView>    
 
</LinearLayout>
 

item_list.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical" >
    
    <TextView 
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/item_name_tv"/>
    <TextView 
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/item_phoneNum_tv"/>
    <TextView 
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:id="@+id/item_ageAndGender_tv"/>
 
</LinearLayout>
 

Person.java 모델클래스

public class Person {
    private String name;
    private String phoneNum;
    private String age;
    private String gender;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPhoneNum() {
        return phoneNum;
    }
    public void setPhoneNum(String phoneNum) {
        this.phoneNum = phoneNum;
    }
    public String getAge() {
        return age;
    }
    public void setAge(String age) {
        this.age = age;
    }
    public String getGender() {
        return gender;
    }
    public void setGender(String gender) {
        this.gender = gender;
    }
    
}

PersonAdapter.java 어댑터

 
 
import java.util.List;
 
import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.TextView;
 
public class PersonAdapter extends ArrayAdapter<Person>{
    private Context context;
    private int resource;
    private List<Person> personList;
    
    public PersonAdapter(Context context, int resource, List<Person> objects) {
        super(context, resource, objects);
        // TODO Auto-generated constructor stub
        this.context = context;
        this.resource = resource;
        this.personList = objects;
    }
 
    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        // TODO Auto-generated method stub
//        return super.getView(position, convertView, parent);
        if(convertView == null)
        {
            LayoutInflater inflater = (LayoutInflater)
                    context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
            convertView = inflater.inflate(resource, parent,false);
            
        }
        final Person person = personList.get(position);
        TextView nameTv = (TextView) convertView.findViewById(R.id.item_name_tv);
        TextView phoneNumTv = (TextView) convertView.findViewById(R.id.item_phoneNum_tv);
        TextView ageAndGenderTv = (TextView) convertView.findViewById(R.id.item_ageAndGender_tv);
        
        nameTv.setText(person.getName());
        phoneNumTv.setText(person.getPhoneNum());
        ageAndGenderTv.setText(person.getAge()+"세, "+"성별 : "+person.getGender());
        
        return convertView;
    }
    
 
}
 

---

SelectActivity.java

public class SelectActivity extends Activity{
    private PersonAdapter adapter;
    private List<Person> personList;
    private ListView listView;
    
    private SQLiteDatabase db;
    private static final String DBNAME = "person.db";
    private static final String TABLE_NAME = "person";
    
    private static final String DB_PATH = 
            Environment.getExternalStorageDirectory().getPath().toString();
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        // TODO Auto-generated method stub
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_select);
        listView = (ListView) findViewById(R.id.select_listview);
        //List객체 만들고 디비에서 조회해와서 데이터를 리스트뷰에 바인딩
        personList = new ArrayList<Person>();
        db = openOrCreateDatabase(DB_PATH + "/" + DBNAME, Context.MODE_PRIVATE, null);

        
        db.rawQuery("select * from person",null);
      

    }
    
}
 

        Cursor cursor = db.rawQuery("select * from person", null);
        cursor.moveToFirst();
        while(cursor.moveToNext())
        {
            Person p =  new Person();
            p.setName(cursor.getString(1));
            p.setPhoneNum(cursor.getString(2));
            p.setGender(cursor.getInt(3) == 0 ? "남자" : "여자");
            p.setAge(cursor.getInt(4) + "");
            personList.add(p);
            
        }
//        while(cursor.isAfterLast()){
//            cursor.moveToNext();
//        }

        adapter = new PersonAdapter(this,R.layout.item_list, personList);
        listView.setAdapter(adapter);

MainActivity.java

        selectBtn.setOnClickListener(new View.OnClickListener() {
            
            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub
                //여기에서 모든 레코드를 리스트뷰로 출력하는 다른 엑티비티를 호출
                Intent intent = new Intent(MainActivity.this, SelectActivity.class);
                startActivity(intent);
            }
        });