Intent intent1 = getIntent();
String key1 = intent1.getStringExtra("one");
String sum_turnover = "select sum(turnover) from svalue where date like "+"'%" + key1 + "%'";
String sum_tc = "select sum(tc) from svalue where date like "+"'%" + key1 + "%'";
Cursor cursor1 = db.rawQuery(sum_turnover,null);
while ((cursor1.moveToNext())) {
String stu = cursor1.getString(4);
sturnover.setText(stu);
cursor1.close();
這是代碼，但是運行后會報錯,請問如何將sqlite查詢求和后賦值呢
uj5u.com熱心網友回復：
String stu = cursor1.getString(cursor1.getColumnIndex(“sum(turnover)”));
你試試這樣改能不能出來
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/62367.html
標籤：其他數據庫