QT¶ÁдSqliteÊý¾Ý¿â FurtherChan

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();
}