In client server program I want to write SQLite Database in server that save received messages from client . I wrote this code in myserver.cpp for query:
void insertMessage(QString IPAddrress, QDate date, QString message)
{
QSqlQuery query;
query.addBindValue(IPAddrress);
query.addBindValue(date);
query.addBindValue(message);
query.exec();
}
void createdata()
{
QSqlQuery query;
query.exec("DROP TABLE messages");
query.exec("CREATE TABLE messages ("
"id INTEGER PRIMARY KEY AUTOINCREMENT,"
"HostAddress integer"
"date char(10), "
"message varchar(30))");
}
And in mainwindow I wrote connection:
bool MainWindow::createConnection()
{
QSqlDatabase database = QSqlDatabase::addDatabase("QSQLITE");
database.setDatabaseName("Message");
if(! database.open())
{
qDebug()<<"can not open database";
}
QSqlQuery query;
query.prepare("INSERT INTO messages(IPAddress, date, message)"
" values(?,?,?)");
}
Now i want to ask how should I connect the server and received data to database? I am so thankful if you could help me.
Aucun commentaire:
Enregistrer un commentaire