헬퍼부분
public
class
DataManager {
private
Context context =
null
;
private
SubjectListDBHelper dbHelper =
null
;
ArrayList<MyItem> slist =
null
;
public
DataManager(Context context) {
this
.context = context;
dbHelper =
new
SubjectListDBHelper(
this
.context);
}
public
ArrayList<MyItem> getsubjectList() {
slist =
new
ArrayList<MyItem>();
SQLiteDatabase db = dbHelper.getReadableDatabase();
String sql =
"select * from subjectlist2"
;
Cursor cursor = db.rawQuery(sql,
null
);
while
(cursor.moveToNext()) {
int
no = cursor.getInt(
0
);
int
image = cursor.getInt(
1
);
String pro_name = cursor.getString(
2
);
String pro_phone = cursor.getString(
3
);
String subject = cursor.getString(
4
);
String subject_memo = cursor.getString(
5
);
MyItem item =
new
MyItem(no, image, pro_name, pro_phone, subject, subject_memo);
slist.add(item);
Toast.makeText(context,
"S"
, Toast.LENGTH_SHORT).show();
}
cursor.close();
dbHelper.close();
return
slist;
}
커스텀어댑터 갯뷰 부분
@Override
public
View getView(
int
position, View convertView, ViewGroup parent) {
if
(convertView ==
null
) {
convertView = inflater.inflate(layout, parent,
false
);
}
ImageView img = (ImageView)convertView.findViewById(R.id.image);
img.setImageResource(items.get(position).getImage());
TextView pro_name =(TextView)convertView.findViewById(R.id.pro_name);
pro_name.setText(items.get(position).getPro_name());
TextView subject =(TextView)convertView.findViewById(R.id.subject);
subject.setText(items.get(position).getSubject());
return
convertView;
}
디비에 저장된 리스트 불러오기 부분
protected
void
onCreate(Bundle savedInstanceState) {
super
.onCreate(savedInstanceState);
setContentView(R.layout.subjectlist_layout);
dataManager =
new
DataManager(
this
);
subList = (ListView)findViewById(R.id.listview1);
subjectList = dataManager.getsubjectList();
adapter =
new
MyAdapter(
this
, android.R.layout.simple_list_item_1, subjectList);
subList.setAdapter(adapter);
}
}
저는 제코드가 틀린게 없는 것 같아 보이는데....
돌리면 바로 튕기네요.. .. 리스트뷰가 없어요
로그캣을 보면 갯뷰에서 set하는 부분들이 전부 널포인터라고 합니다 ㅜㅠㅜ
뭐가문제일까죠 ㅠㅠㅠ