sqlite 统计数据

--统计每月合计
select strftime("%m", GoodInTime) 月,round(sum(GoodMoney)) 合计 from sx_jinhuo
 group by strftime("%Y", GoodInTime),strftime("%m", GoodInTime)

static bool InitSqlCon()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName("sx.db");
    if(!db.open())
        return false;
    return true;
}

struct tongji_Select_Fields
{
    int   month;
    int   Money;
};

///[测试]
void MainWindow::on_pushButton_tc_sel_clicked()
{
    QString sTemp = QString(tongji);

    QList<tongji_Select_Fields> zdlist;

    QSqlQuery query;

    query.setForwardOnly(true);

    query.exec(sTemp);
    while (query.next())
    {
        tongji_Select_Fields bag;
        bag.month = query.value(0).toInt();
        bag.Money = query.value(1).toInt();

        zdlist.append(bag);
    }

    for (int var = 0; var < zdlist.count(); ++var) {

        QString _tmp = QString::asprintf("month=%d , Money=%d",zdlist.at(var).month,zdlist.at(var).Money);

        LOGINFO(">>" + _tmp);
    }

}
///![]