学习CoolWeather的demo,编写完activity后,报错:
java.lang.IllegalStateException: Couldn't read row 0, col -1 from CursorWindow.
Make sure the Cursor is initialized correctly before accessing data from it.
之前在其他博客看到过此类型错误,大概是因为数据库的错误,于是回去检查数据库相关代码。
在CoolWeatherOpenHelper.java中建立了三张表,如province的表如下:
<span style="font-size:18px;">public static final String CREATE_PROVINCE="create table Province("
+"id integer primary key autoincrement,"
+"province_name text,"
+"province_code text)";</span>
而在CoolWeatherDB.java中将Province实例存储到数据库的代码如下:
<span style="font-size:18px;">public void saveProvince(Province province){
if(province!=null){
ContentValues values=new ContentValues();
values.put("province_name", province.getProvinceName());
values.put("province_code", province.getProvinceCode());
db.insert("Province", null, values);
}
}</span>
从数据库读取Province信息:
<span style="font-size:18px;">public List<Province> loadProvinces(){
List<Province> list=new ArrayList<Province>();
Cursor cursor=db.query("Province", null, null, null, null, null, null);
if(cursor.moveToFirst()){
do{
Province province=new Province();
province.setId(cursor.getInt(cursor.getColumnIndex("id")));
province.setProvinceName(cursor.getString(cursor.getColumnIndex("provinceName")));
province.setProvinceCode(cursor.getString(cursor.getColumnIndex("provinceCode")));
list.add(province);
}while(cursor.moveToNext());
}
return list;
}</span>
在读取省份name和code的时候,由于cursor.getColumnIndex的索引值为provinceName和provinceCode,建表时的索引为province_name和province_code,所以导致读取省份信息时出错,city和county的情况类似,修改后成功。