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();
}
SQLite官方网站例子：
#include <stdio.h>
#include <sqlite3.h>
static int callback(void *NotUsed, int argc, char **argv, char **azColName){
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
i ......
