Question

安卓sqlite中cursor问题，点击查询没有反应，怎么将查询的学号信息从数据库中显示在下面的三个EditText上

点击查询没有反应，怎么将查询的学号信息从数据库中显示在下面的三个EditText上（学号，姓名，宿舍号）？这是我的代码：public class thirdActivity extends Activity { EditText t1,t2,t3,t4; Button b1,b2; SQLiteDatabase db; Cursor cursor; public int id_this; static String TABLE_NAME="Users"; static String ID="_id"; static String USER_NAME="user_name"; static String NUM="num"; static String SNO="sno"; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.hey); t1=(EditText)findViewById(R.id.editText3); t2=(EditText)findViewById(R.id.editText20); t3=(EditText)findViewById(R.id.editText21); t4=(EditText)findViewById(R.id.editText22); b1=(Button)findViewById(R.id.button3); b1.setOnClickListener(new mClick()); b2=(Button)findViewById(R.id.button20); b2.setOnClickListener(new mClick1()); }class mClick implements OnClickListener{@Override public void onClick(View v){ db=openOrCreateDatabase("sql.db", SQLiteDatabase.CREATE_IF_NECESSARY,null); try { db.execSQL("create table if not exists "+TABLE_NAME+ " (ID integer primary key autoincrement, " + "USER_NAME text not null,NUM text not null, SNO text not null);"); } catch (SQLException e) { Toast.makeText(getApplicationContext(), "数据表创建失败", Toast.LENGTH_LONG).show(); } ContentValues values = new ContentValues(); values.put(USER_NAME,"1" ); values.put(SNO,"1" ); values.put(NUM,"1" ); db.insert(TABLE_NAME, null, values); String[] columns = new String[] { "ID", "USER_NAME", "NUM","SNO" }; String selection = "ID=?"; String[] selectionArgs = { String.valueOf(ID) }; String groupBy = null; String having = null; String orderBy = null; cursor= db.query(TABLE_NAME, columns, selection, selectionArgs, groupBy, having, orderBy); } }

Answer 1

if(cursor.moveToFirst()){
do{
String str1 = cursor.getString(0);
String str1 = cursor.getString(1);
String str1 = cursor.getString(2);
}while (cursor.moveToNext());
}
这样可以获取到数据库的数据，但是显示要修改主线程UI，需要用handler将消息传到主线程才能setText