C++ (Cpp) sqlInsert示例

示例#1

文件： FLUtil.cpp 项目： AliYousuf/abanq-port

bool FLUtil::writeDBSettingEntry( const QString & key, const QString & value ) {
  int size;
  bool result;
  sqlSelect( "flsettings", "valor", "flkey = '" + key + "'", "flsettings", &size );
  if ( size > 0 )
    result = sqlUpdate( "flsettings", "valor", value, "flkey = '" + key + "'" );
  else
    result = sqlInsert( "flsettings", "flkey,valor", key + "," + value );
  return result;
}

示例#2

文件： FLUtil.cpp 项目： afibanez/eneboo

bool FLUtil::writeDBSettingEntry(const QString &key, const QString &value)
{
  int size;
  bool result;
  QString where(QString::fromLatin1("flkey='") + key + QString::fromLatin1("'"));
  sqlSelect("flsettings", "valor", where, "flsettings", &size);
  if (size > 0) {
    result = sqlUpdate("flsettings", "valor", value, where);
  } else {
    result = sqlInsert("flsettings", "flkey,valor", key + QString::fromLatin1(",") + value);
  }
  return result;
}