从SQLite，Android检索数据时出错

本文介绍了从SQLite，Android检索数据时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

你好:) 我尝试从android中的SQLite检索某些数据时遇到问题 仿真器在执行期间停止工作， 这是我的代码

Hello :) I have a problem when I try to retrieve some data from SQLite in android the emulator stop working during the execution, this is my code

public class StartTest extends Activity { // Objects And Variables public HtTester _testclass; private CommentsDataSource datasource2; private SQLiteDatabase db; private String _select; // User Information Variables String _c1; String _c2; String _c3; String _c4; String _c5; String _c6; String _pregnant; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.starttest); // Casting Controls To variables Button _strattest = (Button) findViewById(R.id.btnsendtest); final EditText _systolic = (EditText) findViewById(R.id.etsystolic); final EditText _diastolic = (EditText) findViewById(R.id.etdiastolic); //CheckBox _pregnant = (CheckBox) findViewById(R.id.cbpregnant); final TextView _result = (TextView) findViewById(R.id.tvresult); //Start Test Button Operation _strattest.setOnClickListener(new OnClickListener() { public void onClick(View v) { datasource2 = new CommentsDataSource(); db = datasource2.SQLiteDatabaseget(StartTest.this); _select = "SELECT * FROM USERSTABLE WHERE _id=" + getIntent().getExtras().getString("USERID"); Cursor c1 = db.rawQuery(_select, null); _c1 = getString(c1.getColumnIndex("USERC1")); _c2 = getString(c1.getColumnIndex("USERC2")); _c3 = getString(c1.getColumnIndex("USERC3")); _c4 = getString(c1.getColumnIndex("USERC4")); _c5 = getString(c1.getColumnIndex("USERC5")); _c6 = getString(c1.getColumnIndex("USERC6")); _result.setText(_c1 + "," +_c2 + "," +_c3 + "," +_c4 + "," +_c5+ "," +_c6 ); } }); } }

错误是:

the error is:

02-25 22:06:43.290: E/AndroidRuntime(850): android.content.res.Resources$NotFoundException: String resource ID #0x8

推荐答案

NotFoundException:字符串资源ID#0x8 NotFoundException: String resource ID #0x8

我发现了问题 我应该在这里在每行中添加c1 I found out the problem I should add c1 to each line here _c1 = getString(c1.getColumnIndex("USERC1")); _c2 = getString(c1.getColumnIndex("USERC2")); _c3 = getString(c1.getColumnIndex("USERC3")); _c4 = getString(c1.getColumnIndex("USERC4")); _c5 = getString(c1.getColumnIndex("USERC5")); _c6 = getString(c1.getColumnIndex("USERC6"));

看起来像这样

to look like this

_c1 = getString(c1.getColumnIndex("USERC1")); _c2 = c1.getString(c1.getColumnIndex("USERC2")); _c3 = c1.getString(c1.getColumnIndex("USERC3")); _c4 = c1.getString(c1.getColumnIndex("USERC4")); _c5 = c1.getString(c1.getColumnIndex("USERC5")); _c6 = c1.getString(c1.getColumnIndex("USERC6"));