这可能是一个重复的问题,但找到的答案没有解决我的问题。我正在尝试在QT中创建一个客户端服务器应用程序,其中客户端发送一个字符串消息代码给服务器,服务器必须连接到SQL服务器数据库并检索与客户端消息代码相关的数据。
下面是我目前编写的服务器部分。但是我得到了这个错误:无法打开包括文件:'QtSql':没有这样的文件或目录。当我制作独立项目并运行数据库部分时,它工作得很好,但当我将它们放在一起时,它失败了。
有人有一些建议来解决这个问题吗?
ServerSocket.pro
ServerSocket.pro
QT += core
QT += network
QT += sql
QT -= gui
TARGET = ServerSocket
CONFIG += console
CONFIG -= app_bundle
TEMPLATE = app
SOURCES += main.cpp \
server.cpp
HEADERS += \
server.h
ServerSocket.h
#ifndef SERVER_H
#define SERVER_H
#include <QObject>
#include <QDebug>
#include <QTcpServer>
#include <QTcpSocket>
class Server : public QObject
{
Q_OBJECT
public:
explicit Server(QObject *parent = 0);
signals:
public slots:
void newConnection();
private:
QTcpServer *server;
};
#endif // SERVER_H
ServerSocket.cpp
#include "server.h"
#include <QtSql>
Server::Server(QObject *parent) :
QObject(parent)
{
server = new QTcpServer(this);
connect(server, SIGNAL(newConnection()),this,SLOT(newConnection()));
if(!server->listen(QHostAddress::Any,1234)){
qDebug() << "Server could not start";
} else {
qDebug() << "Server started";
}
}
void Server::newConnection(){
QTcpSocket *socket = server->nextPendingConnection();
socket->write("hello client");
socket->waitForBytesWritten(1000);
socket->waitForReadyRead(1000);
QString appCode = socket->readAll();
QString servername = "LOCALHOST\\SQLEXPRESS";
QString dbname = "ApplicationsDB";
QString connectionTemplate = "DRIVER={SQL SERVER};SERVER=%1;DATABASE=%2;";
QSqlQuery query;
QStringList results;
QString connectionString = connectionTemplate.arg(servername).arg(dbname);
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName(connectionString);
if (db.open())
{
qDebug() << "Opened";
query = db.exec("select Code from Application a where a.Name = '") + appCode + "';";
while (query.next())
{
QString result = query.record().value(0).toString();
results.append(result);
}
for(QString res : results){
qDebug() << res;
}
}
else
{
qDebug() << "Error = " << db.lastError().text();
}
db.close();
}
-d
选项运行qmake,以查看是否设置了includepath,但我认为你应该尝试进行清理,因为我无法重现此问题。您是否已正确安装SQL,就像通过官方qt安装程序安装其他模块一样? - László Papp