我有一个活动,用户可以在该活动中填写这些信息。 但是,如果用户未填写任何此微调器,然后单击“保存”按钮,则必须显示AlertDialog。
但是,这不是我所期望的。 当我单击“保存”按钮时,它显示一个错误:“ 请求CursorIndexOutOfBoundsException索引0,大小为0 ”
我该如何解决这种错误?
DatabaseHandler.java
public Cursor getReport_DistrictCode(String district)
{
SQLiteDatabase dbSqlite = this.getReadableDatabase();
Cursor c = dbSqlite.query(Constants.TABLE_DISTRICT, new String[]
{Constants.DISTRICT_ID, Constants.DISTRICT_CODE,Constants.DISTRICT_NAME,Constants.DISTRICT_DESCRIPTION},
Constants.DISTRICT_NAME+" = ?" , new String[]{district}, null, null, null);
if (c != null) {
c.moveToFirst();
}
dbSqlite.close();
return c;
}
MainActivity.java
spn_District.setOnItemSelectedListener(new OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView> parentView, View SelectedItem, int position, long id)
{
int rowid = (int)parentView.getItemIdAtPosition(position);
int districtId = rowid;
if(districtId == 0)
{
List Province = new ArrayList();
ArrayAdapter adapter= new ArrayAdapter(S_10th_IReportMain.this, android.R.layout.simple_spinner_item, Province);
spn_Province.setAdapter(adapter);
}
List Province = databaseHandler.setItemOnProvinceSpinner(districtId);
ArrayAdapter adapter = new ArrayAdapter(S_10th_IReportMain.this, R.layout.spinnerattributecell, Province) {
public View getView(int position, View convertView, ViewGroup parent)
{
View v = super.getView(position, convertView, parent);
Typeface externalFont=Typeface.createFromAsset(getAssets(), "Gothic_Regular.TTF");
((TextView) v).setTypeface(externalFont);
return v;
}
public View getDropDownView(int position, View convertView, ViewGroup parent) {
View v =super.getDropDownView(position, convertView, parent);
Typeface externalFont=Typeface.createFromAsset(getAssets(), "Gothic_Regular.TTF");
((TextView) v).setTypeface(externalFont);
return v;
}
};
adapter.setDropDownViewResource(R.layout.spinnerdropdownitem);
spn_Province.setAdapter(adapter);
}
@Override
public void onNothingSelected(AdapterView> arg0) {
}
});
我的CursorAdapter到MainActivity.java的实现
String District = spn_District.getSelectedItem().toString();
Cursor rDistrict = databaseHandler.getReport_DistrictCode(District);
String DistrictCode = rDistrict.getString(rDistrict.getColumnIndex(Constants.DISTRICT_CODE));