package kr.ac.gnu.cs.SavePocketMoney;

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

import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.os.Bundle;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.TextView;

public class TodayTotalListActivity extends Activity implements OnItemClickListener {

private DBAdapter dbadapter;
ArrayList<MyItem> arItem;

@Override
public void onCreate(Bundle savedInstanceState) {
try {

super.onCreate(savedInstanceState);
setContentView(R.layout.todaytotallist);
// TODO Auto-generated method stub
ListView MyList = (ListView) findViewById(R.id.todaytotallist);

arItem = new ArrayList<MyItem>();

MyItem mi;

dbadapter = new DBAdapter(this);
dbadapter.openDB();

java.util.Date currentDate = new java.util.Date();
java.text.SimpleDateFormat format = new java.text.SimpleDateFormat(
"yyMMdd");
String _date = format.format(currentDate);

Cursor result = dbadapter
.fetchDB("SELECT * FROM list WHERE date = '" + _date + "'");
startManagingCursor(result);
result.moveToFirst();

for (int i = 0; i < result.getCount(); i++) {

int img_src_idx = result.getColumnIndex("img_src");
int img_src = Integer.parseInt(result.getString(img_src_idx));

int name_idx = result.getColumnIndex("name");
String name = result.getString(name_idx);
int price_src_idx = result.getColumnIndex("price");
int price = Integer.parseInt(result.getString(price_src_idx));
int calorie_src_idx = result.getColumnIndex("calorie");
int calorie = Integer.parseInt(result.getString(calorie_src_idx));
int time_src_idx = result.getColumnIndex("time");
String time = result.getString(time_src_idx);

mi = new MyItem(img_src,name, price, calorie, time);
arItem.add(mi);
result.moveToNext();
}

MyListAdapter MyAdapter = new MyListAdapter(this, R.layout.adapter,
arItem);
MyList.setAdapter(MyAdapter);

for (MyItem item : arItem) {
MyAdapter.addData(item);
}
dbadapter.closeDB();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
@Override
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2, long arg3) {
// TODO Auto-generated method stub
}
}

// 리스트 뷰에 출력할 항목
class MyItem {

int img_src;
String name;
int price;
int calorie;
String time;
MyItem(int _img_src, String _name, int _price, int _calorie, String _time) {
this.img_src = _img_src;
this.name = _name;
this.price = _price;
this.calorie = _calorie;
this.time = _time;
}

}

// 어댑터 클래스
class MyListAdapter extends ArrayAdapter<MyItem> {

Context context;
int layout;
int textViewResourceId;
List<MyItem> item;

public MyListAdapter(Context context, int textViewResourceId,
List<MyItem> objects) {

super(context, textViewResourceId, objects);

try {
// TODO Auto-generated constructor stub
this.context = context;
this.textViewResourceId = textViewResourceId;
this.item = objects;
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}

public void addData(MyItem item) {
add(item);
}

// 각 항목의 뷰 생성
@SuppressWarnings("finally")
public View getView(int position, View convertView, ViewGroup parent) {
View row = null;
try {
row = convertView;

if (row == null) {
Activity activity = (Activity) context;
LayoutInflater inflater = activity.getLayoutInflater();

row = inflater.inflate(textViewResourceId, null);
}
MyItem item = this.item.get(position);

if (item != null) {
ImageView imgView = (ImageView) row
.findViewById(R.id.image_menu);
imgView.setImageResource(item.img_src);

TextView name = (TextView) row.findViewById(R.id.textname);
name.setText(item.name);
TextView price = (TextView) row.findViewById(R.id.textprice);
price.setText(item.price);
TextView calorie = (TextView) row.findViewById(R.id.textcalorie);
calorie.setText(item.calorie);
TextView time = (TextView) row.findViewById(R.id.texttime);
time.setText(item.time);

}

} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
return row;
}
}
}

커스텀리스트뷰소스입니다.
이상하게 리스트뷰로 출력을 시키면 첫번째 항목이 마지막에 한번더 출력이 되네요ㅜㅜ
도와주세요...
이 게시물을