String sql = "insert into usr(name) values ('zhangSam')";
db.execSQL(sql);
db.execSQL(sql);
db.execSQL(sql);
sql = "select * from usr";
Cursor cs = db.rawQuery(sql,null);
if(cs.moveToFirst()){
for(int i=0;i<cs.getCount();i++){
cs.move(i);
int uid = cs.getInt(cs.getColumnIndex("id"));
Log.d("TEST2:",String.valueOf(uid));
}
}
result:
TEST2:1
TEST2:4
TEST2:5
TEST2:11
shut down vm
CursorIndexOutOfBounds exception...
没有理由cursor越界啊?
//发现个情况cs.getString(cs.getColumnIndex("name"));
//取String没事 好像取int型有问题,但值是对的,就是报个越界错误