mardi 5 janvier 2016

How to connect client server system with SQlite

In client server program I want the message that received save in "SQLite" database.I mean as code below shows "IPAddress, message and date" from server save in database.How should i connect these together? Thanks in advance.

    QString IPAddress= m_client->peerAddress().toString();

    qDebug()<<"IP Address:"<< IPAddress;
}

void myserver::readSocket()
{
   QByteArray message = m_client->readAll();

   qDebug() <<" Data in: " << message;

   QDate date=QDate::currentDate() ;

   qDebug() << date;

   m_client->write(message);
  }


 void MainWindow::createdata()
 {
    QSqlQuery query;
    query.exec("DROP TABLE messages");
    query.exec("CREATE TABLE messages("
               "id INTEGER PRIMARY KEY AUTOINCREMENT,"
               "IPAddress VARCHAR(20),"
               "date VARCHAR(10),"
               "message VARCHAR(30))");


    query.prepare("INSERT INTO messages(IPAddress, date, message) values(?,?,?)");

Aucun commentaire:

Enregistrer un commentaire