Question

android Sqlite查询问题

at com.cxw.sqliteopenhelper.OpenHelperMainActivity$MyDBHelper.query(OpenHelperMainActivity.java:57)
private void query()
{
Cursor c=getWritableDatabase().query("TempTb1", null, null, null, null, null, null);
if(c.moveToFirst())
{
for(int i=0;i<c.getCount();i++)
{
c.move(i);
int id=c.getInt(0);

String name=c.getString(1);

System.out.println(id+":"+name);

}
c.close();
}

Answer 1

StackTrace没有完全粘上来，不过大概也明白是怎么回事了，试一下这段代码吧：
SQLiteDatabase db = SQLiteOpenHelper.getReadableDatabase();
Cursor c = db.rawQuery("SELECT id, name FROM TempTb1", null);
while(c.moveToNext()){
int id = c.getInt(0);
String name = c.getString(1);
System.out.println(id+":"+name);
}
c.close();
db.close();
--------------------
上边SQLiteOpenHelper用你已经有的helper就可以。没用IDE不知道有没有错。

Answer 2

问题呢？
没有说啊

追问

09-20 06:21:55.330: E/AndroidRuntime(2302): at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:68)
int id=c.getInt(0);