C++ QSqlQuery::seek方法代码示例

/*----------------------------------------------------------------------------*/
void SelSessionBox::onSessionChanged(QModelIndex idx)
{
  QSqlQuery q = sessionModel->query();
  q.seek(idx.row());
  int id = q.value(0).toInt();
  database->measureSession(id, m_session);
}

void TablePrivate::init()
{
    Q_Q(Table);

    q->setTable(name);
    q->setEditStrategy(QSqlTableModel::OnFieldChange);
    q->select();

    QSqlRecord columnNames = q->record();
    int columnCount = columnNames.count();
    columns.reserve(columnCount);
    for(int i = 0; i < columnCount; ++i) {
        Column *column = new Column(columnNames.field(i), q);
        column->setIndex(i);
        columns.append(column);
        columnsByName.insert(column->name(), column);
    }

    while(q->canFetchMore())
        q->fetchMore();

    QSqlQuery query = q->query();
    int rowCount = q->rowCount();
    int idIndex = q->record().indexOf(QLatin1String("id"));
    int id = 0;
    rows.reserve(rowCount);
    rowsById.reserve(rowCount);
    for(int i = 0; i < rowCount; ++i) {
        query.seek(i);
        id = query.value(idIndex).toInt();
        Row *row = new Row(i, id, q);
        rows.append(row);
        rowsById.insert(id, row);
    }
}

int OrderAdapter::getOrderLineFromOrderIdAndByModelIndex(int orderId, const QModelIndex& modelIndex)
{
	QModelIndex index = modelIndex;

	if (index.isValid())
	{
		std::ostringstream tQuery;

		//! TODO - actually query model (instead of duplicating + assumption)
		tQuery << "(SELECT ALL bLine.id, pizza.fqn, bLine.price FROM pizza, purchasable purch, bikeLine bLine " <<
				"WHERE pizza.id = purch.pizzaId AND bLine.pRef = purch.id " <<
				"AND bLine.oRef = " << orderId <<
				") UNION ALL (" <<
				"SELECT ALL bLine.id, menu.name, bLine.price FROM menu, bikeLine bLine, misc, purchasable " <<
				"WHERE menu.id = misc.menuId AND misc.id = purchasable.pizzaId AND bLine.pRef = purchasable.id " <<
				"AND bLine.oRef = " << orderId << ") ORDER BY id ASC;";

		QSqlQuery query;
		query.prepare(tQuery.str().c_str());
		query.exec();

		query.seek(index.row());
		int id = query.value(0).toInt();

		return id;
	}

	return -1;
}

void MainWindow::readAd(int adId)//读取广告
{
    QSqlQuery adQuery;//对广告表单搜索
    if(adQuery.exec("SELECT aditem FROM adtable WHERE id = "+QString().setNum(adId)))
    {
        int adNumRows = 0;//定义搜索返回的行数
        if(db.driver()->hasFeature(QSqlDriver::QuerySize))//判断驱动是否包含QuerySize
        {
            adNumRows = adQuery.size();//将返回的行数赋于fstNumRows
        }
        else
        {
            adQuery.last();//移至最后一行
            adNumRows = adQuery.at()+1;//将返回的行数赋于fstNumRows
            adQuery.seek(-1);//返回第一行
        }
        if(adNumRows>0)//判断是否大于0
        {
            while(adQuery.next())
            {
                this->adView->loadMap(adQuery.value(0).toByteArray());//读取广告
            }
        }
    }
}

const float Database::spriteActionTime(int index) const
{
    QSqlQuery query;
    query.exec("SELECT actionTime FROM sprite");
    query.seek(index-1);
    float actionTime = query.value(0).toInt();
    return actionTime;
}

const int Database::spriteActionRate(int index) const
{
    QSqlQuery query;
    query.exec("SELECT actionRate FROM sprite");
    query.seek(index-1);
    int actionRate = query.value(0).toInt();
    return actionRate;
}

const int Database::spriteMovementRange(int index) const
{
    QSqlQuery query;
    query.exec("SELECT movementRange FROM sprite");
    query.seek(index-1);
    int movementRange = query.value(0).toInt();
    return movementRange;
}

const int Database::spriteAttackRange(int index) const
{
    QSqlQuery query;
    query.exec("SELECT attackRange FROM sprite");
    query.seek(index-1);
    int attackRange = query.value(0).toInt();
    return attackRange;
}

const int Database::spriteHitPoints(int index) const
{
    QSqlQuery query;
    query.exec("SELECT hitPoints FROM sprite");
    query.seek(index-1);
    int HP = query.value(0).toInt();
    return HP;
}

const int Database::spriteAttackPower(int index) const
{
    QSqlQuery query;
    query.exec("SELECT attackPower FROM sprite");
    query.seek(index-1);
    int AP = query.value(0).toInt();
    return AP;
}

QString Database::spriteFileName(int index) const
{
    QSqlQuery query;
    query.exec("SELECT imageFileName FROM sprite");
    query.seek(index-1);
    QString fileName = query.value(0).toString();
    return fileName;
}

QString Database::userName(int index) const
{
    QSqlQuery query;
    query.exec("SELECT name FROM user");
    query.seek(index-1);
    QString name = query.value(0).toString();
    return name;
}

//--------------------utech--------------------utech--------------------utech--------------------
bool USkladProgOptions::organizCinaZPodatkom()
{
	QSqlQuery query;
	query.exec("SELECT CinaZPodatkom FROM orgInfo WHERE PidprId=1");
	if (query.seek(0)){
		return query.value(0).toBool();
	}
	else{
		qDebug() << "SQL Table orgInfo has no record with id=1.";
		return true;
	}
}

/*
	Значення податків:
		0. Фіксований патент ПП
		1. ПДВ
		2. Єдиний податок
*/
int USkladProgOptions::organizPodatok()
{
	QSqlQuery query;
	query.exec("SELECT Podatok FROM orgInfo WHERE PidprId=1");
	if (query.seek(0)){
		return query.value(0).toInt();
	}
	else{
		qDebug() << "SQL Table orgInfo has no record with id=1.";
		return -1;
	}
}

//--------------------utech--------------------utech--------------------utech--------------------
double USkladProgOptions::organizVidsotokPodatku()
{
	QSqlQuery query;
	query.exec("SELECT PodatokVal FROM orgInfo WHERE PidprId=1");
	if (query.seek(0)){
		return query.value(0).toDouble();
	}
	else{
		qDebug() << "SQL Table orgInfo has no record with id=1.";
		return 0;
	}
}