public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
try{
SQLiteDatabase myDatabase=this.openOrCreateDatabase("User",MODE_PRIVATE,null);
myDatabase.execSQL("CREATE TABLE IF NOT EXISTS user(name VARCHAR,age INTEGER(2),id INTEGER PRIMARY KEY )");
myDatabase.execSQL("INSERT INTO user(name,age) VALUES('gaurav',20)");
myDatabase.execSQL("INSERT INTO user(name,age) VALUES('saurav',16)");
Cursor c=myDatabase.rawQuery("SELECT * FROM user",null);
int nameIndex=c.getColumnIndex("name");
int ageIndex=c.getColumnIndex("age");
c.moveToFirst();
while(c!=null){
Log.i("Name",c.getString(nameIndex));
Log.i("Age", Integer.toString(c.getInt(ageIndex))); //tring to get this things in logs but instead it shows an error.
c.moveToNext();
}
} catch (Exception e){
e.printStackTrace();
}
}
}
错误是
::E/ CursorWindow :无法从具有18行2列的CursorWindow读取第0行、第1列。
https://stackoverflow.com/questions/51013804
复制相似问题