QString lastQuery = query.executedQuery();
for (int i = 0, j = 0; j < query.boundValues().size(); ++j)
{
i = lastQuery.indexOf(QLatin1Char('?'), i);
if (i <= 0) break;
const QVariant& var = query.boundValue(j);
QSqlField field(QString(""), var.type());
if (var.isNull()) field.clear();
else field.setValue(var);
QString formatV = query.driver()->formatValue(field);
lastQuery.replace(i, 1, formatV);
i += formatV.length();
}
qDebug()<<"SQL Query error:"<<lastQuery;
void RequestProcessor::run()
{
QObject localObject;
/*QSslSocket **/socket = new QSslSocket(&localObject);
if (!socket) {
qDebug("not enough memory to create new QSslSocket");
return;
}
if (!socket->setSocketDescriptor(mSocketDescriptor))
{
qDebug("couldn't set socket descriptor");
CloseSocket(socket);
return;
}
socket->setProtocol(QSsl::AnyProtocol);
socket->setPeerVerifyMode(QSslSocket::VerifyNone);
startServerEncryption(socket);
socket->waitForReadyRead();
this->onReadyRead();
socket->waitForDisconnected();
socket->close();
socket->deleteLater();
// delete socket;
}
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL","CurrentThread");
db.setDatabaseName("table");
db.setUserName("username");
db.setHostName("localhost");
db.setPassword("123456");
db.open();
QSqlQuery query(db);
if(query.exec("SELECT * FROM `Users`"))
while(query.next())
{
//query.record().value("Name").toString();
}