但每次只能显示最后一次登录的名字代码 请问怎么改
public class student extends Activity {
MyDatabaseHelper database;
TextView tv_name,tv_age,tv_sex;
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.student);
tv_name=(TextView)findViewById(R.id.tv_name);
tv_age=(TextView)findViewById(R.id.tv_age);
tv_sex=(TextView)findViewById(R.id.tv_sex);
database=new MyDatabaseHelper(this,"RE.db",null, 1);
SQLiteDatabase db=database.getWritableDatabase();
Cursor cursor = db.query("student", null, null, null, null, null, null);
if (cursor != null) {
while (cursor.moveToNext()) {
String name = cursor.getString(cursor.getColumnIndex("username"));
String age = cursor.getString(cursor.getColumnIndex("age"));
String sex=cursor.getString(cursor.getColumnIndex("sex"));
String id=cursor.getString(cursor.getColumnIndex("id"));
tv_name.setText(name.toString());
tv_sex.setText(sex.toString());
tv_age.setText(age.toString());
}
cursor.close();
}
}
}
AAAAAAAAAAAAAAA
你可以稍微想一下,如果有多条数据,全部显示出来,那么是要用容器装的,然后放在一个可以显示多条数据的控件里面,你这样写数据会覆盖,第二sql是不是太简单了,感觉要用bean集合先装起来,
提问题,语言描述建议清晰点
Cursor cursor = db.query("student", null, null, null, null, null, null); 数据库查询不对