java datahelper_Java Android。在DatabaseHelper中执行查询时出错

我想从sqlite中退出所有与Spinner中选择的产品具有相同市场的产品

我从databasehelper的函数是:

public String getSelectedData(String market) {

// TODO Auto-generated method stub

String[] columns = new String[]{KEY_PRODNAME, KEY_PRODAMOUNT ,KEY_AMOUNTTYPE, KEY_MARKETID};

Cursor c= myDatabase.query(DATABASE_PRODTABLE, columns, KEY_MARKETID + "=" + market, null, null, null, null);

String result = "";

//int iRow = c.getColumnIndex(KEY_PRODROWID);

int iName = c.getColumnIndex(KEY_PRODNAME);

int iAmount = c.getColumnIndex(KEY_PRODAMOUNT);

int iAmountType = c.getColumnIndex(KEY_AMOUNTTYPE);

int iMarket = c.getColumnIndex(KEY_MARKETID);

int i=0;

for(c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){

i++;

result = result + i + ". " + c.getString(iName) + " " + c.getString(iAmount) + " " + c.getString(iAmountType) + " " + c.getString(iMarket) + "\n";

}

return result;

}它执行getSelectedData(市场)时给了我一个错误,

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

// setare continut din layout

setContentView(R.layout.viewlist);

TextView tv=(TextView)findViewById(R.id.tvSQLinfo);

buton = (Button)findViewById(R.id.button1);

buton.setOnClickListener(this);

Bundle bundle = getIntent().getExtras();

String market = bundle.getString("market");

//tv.setText("Data send from previous intent nSite Name = +" + market );

//Afisare produse din baza de date

DatabaseHelper info= new DatabaseHelper(ViewProductsActivity.this);

try {

info.open();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

String data = info.getSelectedData(market);

tv.setText(data);

info.close();

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值