[Android]_ch8.7_SQLiteDB瀏覽資料(物件導向)

[Android]_ch8.7_SQLiteDB瀏覽資料(物件導向)



package com.derek.ch25_db;



public class DBData {

String id;

String name;

String phoneNo;

String address;

public DBData(String id,String name,String phoneNo,String address){

this.id=id;

this.name=name;

this.phoneNo=phoneNo;

this.address=address;

}

public String getId(){

return id;

}

public String getName(){

return name;

}

public String getPhoneNo(){

return phoneNo;

}

public String getAddress(){

return address;

}

}

public ArrayList<DBData> queryAll(){

SQLiteDatabase db=getWritableDatabase();

Cursor cursor=db.rawQuery("SELECT * FROM teacher;",null);

ArrayList<DBData> list=new ArrayList<DBData>();

while(cursor.moveToNext()){

String id=cursor.getString(0);

String name=cursor.getString(1);

String phoneNo=cursor.getString(2);

String address=cursor.getString(3);

DBData data=new DBData(id, name, phoneNo, address);

list.add(data);

}

return list;

}

btn5.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

index=index-1;

if(index<0)

index=AL.size()-1;

showData(index);

}

});

        btn6.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

index=index+1;

if(index>=AL.size())

index=0;

showData(index);

}

});

public void showData(int index){

    if(AL.size()>0){

    tv1.setText("第幾筆/總筆數.."+(index+1)+"/"+AL.size());

    DBData data=AL.get(index);

    et1.setText(data.getId());

    et2.setText(data.getName());

    et3.setText(data.getPhoneNo());

    et4.setText(data.getAddress());

    }else{

    tv1.setText("第幾筆/總筆數...0/0");   

    et1.setText("");

    et2.setText("");

    et3.setText("");

    et4.setText("");

    }

    }