mercredi 23 décembre 2015

Connecting SQLite database to server

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