从SQLite，Android检索数据时出错 [英] Error When Retrieving data from 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"));

这篇关于从SQLite，Android检索数据时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！