C++QT SqlLite数据库简单使用

//Database.h
#pragma once
#include <QObject>
#include <QSqlQuery>
#include <QDebug>
#include <QSqlError>
#include <QMutex>
#include <QDir>
#include <QCoreApplication>
#include <QDate>
#include <QDateTime>
struct InfoEquipPatient
{
  QString Hospital;
  QString Doctor;
  QString PatientId;
  QString PatientName;
  QString PatientSex;
  QString PatientAge;
  QString Disease;
  QString Location;
  QString Time;
  QString CodeEquip;
};
class Database : public QObject
{
  Q_OBJECT
public:
  static Database* instance()
  {
  static QMutex mutex;
  if (!m_instance)
  {
    QMutexLocker locker(&mutex);
    if (!m_instance)
    {
    m_instance = new Database();
    }
  }
  return m_instance;
  }
  static void destroy()
  {
  if (m_instance)
    delete m_instance;
  }
  explicit Database(QObject *parent = 0);
  ~Database();
  //建立数据库连接
  bool CreateConnect();
  //关闭连接
  void CloseConnect();
  //创建表
  void CreateTable();
  //获取所有设备手术信息
  void GetAllInfoEquips(QVector<InfoEquipPatient> &infos);
  QSqlDatabase m_dbconn;
private:
  static Database* m_instance;
};

//Database.cpp
#include "Database.h"
Database *Database::m_instance = 0;
Database::Database(QObject *parent)
  : QObject(parent)
{
}
Database::~Database()
{
}
bool Database::CreateConnect()
{
  m_dbconn = QSqlDatabase::addDatabase("QSQLITE", "MyConnect");
  QString fullpath = "spine.db";//数据库文件在debug/release根目录下，一般会自己创建
  m_dbconn.setDatabaseName(fullpath);
  //数据库登录用户名和密码设置
  m_dbconn.setUserName("root");
  m_dbconn.setPassword("123456");
  if (!m_dbconn.open())
  {
  qDebug() << "Database::CreateConnect()::failed connect.";
  return false;
  }
  else
  {
  qDebug() << "Database::CreateConnect()::success connect.";
  CreateTable();
  return true;
  }
}
void Database::CloseConnect()
{
  m_dbconn.close();
}
void Database::CreateTable()
{
  QSqlQuery query(this->m_dbconn);
  QString str_SqlEquipInfo = "CREATE TABLE InfoEquip(Hospital varchar(1024),Doctor varchar(1024),PatientId varchar(1024),PatientName varchar(1024),PatientSex varchar(10),PatientAge varchar(10),Disease varchar(1024),Location varchar(100),Time varchar(100),EquipCode varchar(100));";
  if (query.exec(str_SqlEquipInfo))
  {
  qDebug() << "Database::::Create Tables successful!";
  }
  else
  {
  qDebug() << "Database::::Tables Exist!";
  }
}
void Database::GetAllInfoEquips(QVector<InfoEquipPatient> &infos)
{
  QSqlQuery query(this->m_dbconn);
  QString str_SqlSelectAll = "select * from InfoEquip";
  query.prepare(str_SqlSelectAll);
  if (!query.exec())
  {
  qDebug() << query.lastError();
  }
  else
  {
  qDebug() << "Database::get_all_infoEquips!";
  while (query.next())
  {
    InfoEquipPatient info;
    info.Hospital = query.value("Hospital").toString();
    info.Doctor = query.value("Doctor").toString();
    info.PatientId = query.value("PatientId").toString();
    info.PatientName = query.value("PatientName").toString();
    info.PatientSex = query.value("PatientSex").toString();
    info.PatientAge = query.value("PatientAge").toString();
    info.Disease = query.value("Disease").toString();
    info.Location = query.value("Location").toString();
    info.Time = query.value("Time").toString();
    info.CodeEquip = query.value("EquipCode").toString();
    infos.push_back(info);
  }
  } 
}

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
  //创建数据库连接
  Database *m_database = Database::instance();
  m_database->CreateConnect();
    return a.exec();
}

//XXX.h
#include"Database.h"
Database *m_database;//类内声明
//XXX.cpp调用数据库查询
m_database = Database::instance();
QVector<InfoEquipPatient> infos;
m_database->GetAllInfoEquips(infos);