针对特定日期结果的android sqlite查询语句

Question

我想从pro_price查询今年的总金额。sqlite查询语句getDate().endWith(getThisYear())中是否存在错误？

 public double SumPriceYear(){

Cursor sum = ourDatabase.rawQuery("SELECT SUM( " + Pro_Price + " ) FROM "+ TABLE_NAME + " Where " + Pro_Date + " = '" + getDate().endsWith(getThisYear()) + "' ", null);
if(sum.moveToFirst())
{
    return sum.getDouble(0);
}

return sum.getDouble(0);

}

Answer 1

select sum应该有一个列名，而不是一个值。此外，您不应该将日期仅与一年进行比较。它不匹配。你需要一年比一年。

试试这个：

public double SumPriceYear(){

Cursor sum = ourDatabase.rawQuery("SELECT SUM(COLUMN_NAME) FROM "+ TABLE_NAME + " WHERE date(" + Pro_Date + ",'%Y') = '" + getDate().endsWith(getThisYear()) + "' ", null);
if(sum.moveToFirst())
{
    return sum.getDouble(0);
}

    return sum.getDouble(0);
}

我对以下内容进行了更改：

• SUM(COLUMN_NAME)
• WHERE date(“+ Pro_Date + "，'%Y')