Android sqlite查询乘法与编辑文本整数

Question

protected void cal() {
    // TODO Auto-generated method stub
    Company obj1 = new Company();
    String val1 = obj1.getCompanyID();
    edite.getText().toString();
    Cursor sumw = dbObject.rawQuery(
            "SELECT sum(Volume)FROM SHARE WHERE _id2 LIKE ?",
            new String[] { "%" + val1 + "%" });
    sumw.moveToFirst();
    editT.setText(sumw.getString(0));
}

我想获得EditText值的值，与查询的选择和值相乘

Answer 1

试试这个，

protected void cal() {
    // TODO Auto-generated method stub
    Company obj1 = new Company();
    String val1 = obj1.getCompanyID();
    int n = Integer.parseInt(edite.getText().toString());
    Cursor sumw = dbObject.rawQuery(
            "SELECT sum(Volume)FROM SHARE WHERE _id2 LIKE ?",
            new String[] { "%" + val1 + "%" });
    sumw.moveToFirst();
    editT.setText(sumw.getString(0)*n);
}

Answer 2

如果它们是整数值，则尝试如下:

int multiplierOne = Integer.parseInt(edite.getText().toString());
....
int multiplierTwo = sumw.getInt(0);
int product = multiplierOne * multiplierTwo;
editT.setText("" + product);