QT读写Sqlite数据库
//.h
/******************************************************************************** Date : 2010-05-08** Author : furtherchan
** If you have any questions , please contact me******************************************************************************/
#ifndef SQLITEDB_H#define SQLITEDB_H
#include <QObject>#include <QSqlDatabase>#include <QSqlQuery>#include <QSqlQueryModel>#include <QMessageBox>#include <QString>#include <QStringList>
class SqliteDB : public QObject{
public: SqliteDB(); QStringList strListUser; QStringList strListId; QStringList strListName;
void connectDB(); void closeDB(); void getUserInfo( QString id ); void updateUserLogStat( QString id, QString stat ); int insertNewUser( QString id, QString password, QString name, QString ip, QString port); void getUserAllOnline(); void updateUserIp(QString id, QString ip);
private: QSqlDatabase db;
};
#endif // SQLITEDB_H
//.cpp
/******************************************************************************** Date : 2010-05-08** Author : furtherchan
** If you have any questions , please contact me******************************************************************************/
#include “sqlitedb.h”
SqliteDB::SqliteDB(){}
void SqliteDB::connectDB(){ db = QSqlDatabase::addDatabase(“QSQLITE”); db.setDatabaseName(“chat.db”); if ( !db.open()) { QMessageBox::critical(NULL, “Connect to db…”, “Connect failed.”); }}
void SqliteDB::closeDB(){ db.close();}
void SqliteDB::getUserInfo(QString id){ this->connectDB(); QSqlQuery query; strListUser.clear();
if (!(query.exec(“SELECT id, password, name, logstat,ip FROM user”))) { QMessageBox::critical(NULL, “exec”, “Exec failed.”); }
while (query.next()) { if ( query.value(0).toString() == id ) { strListUser.append(query.value(0).toString()); strListUser.append(query.value(1).toString()); strListUser.append(query.value(2).toString()); strListUser.append(query.value(3).toString()); strListUser.append(query.value(4).toString()); } } this->closeDB();}
void SqliteDB::updateUserLogStat(QString id, QString stat){ this->connectDB(); QSqlQuery query; strListUser.clear(); if(!(query.prepare(“UPDATE user SET logstat = :stat WHERE id = :id”))) { QMessageBox::critical(NULL, “prepare”, “Prepare failed.”); } query.bindValue(“:id”,id); query.bindValue(“:stat”,stat); if(!query.exec()) { QMessageBox::critical(NULL, “exec”, “Exec failed.”); } this->closeDB();}
void SqliteDB::updateUserIp(QString id, QString ip){ this->connectDB();
QSqlQuery query; strListUser.clear();
if(!(query.prepare(“UPDATE user SET ip = :ip WHERE id = :id”))) { QMessageBox::critical(NULL, “prepare”, “Prepare failed.”+id); } query.bindValue(“:id”,id); query.bindValue(“:ip”,ip); if(!query.exec()) { QMessageBox::critical(NULL, “exec”, “Exec failed.”); }
this->closeDB();}
有一种旅行，叫单车旅行。它没有奢侈准备，
