void Widget::initDB()
{
    // 創(chuàng)建并打開數(shù)據(jù)庫
    QSqlDatabase database;
    database = QSqlDatabase::addDatabase("QSQLITE");
//    qDebug() << QApplication::applicationDirPath(); // 獲取應(yīng)用程序當(dāng)前目錄

    database.setDatabaseName("test.sqlite3");
    if(!database.open())
    {
        qDebug() << "Error: Failed to connect database." << database.lastError();
    }
    else
    {
        qDebug() << "Succeed to connect database.";
    }

    // 創(chuàng)建表格
    QSqlQuery sql_query = database.exec("DROP TABLE student");
    // 先清空一下表，可按需添加此句
//    sql_query.exec("DROP TABLE student");
    // 創(chuàng)建表格student
    if(!sql_query.exec("create table student(UserId int primary key, UserName text, PassWord text)"))
    {
        qDebug() << "Error: Fail to create table." << sql_query.lastError();
    }
    else
    {
        qDebug() << "Table created!";
    }
    // 填充表
    if(!sql_query.exec("INSERT INTO student VALUES(1, 'AppleCai', '23')"))
    {
        qDebug() << "Error: Fail to create table." << sql_query.lastError();
    }
    else
    {
        qDebug() << "add one created!";
    }
    // 批量填充表
    QStringList names;
    names << "小A" << "小B" << "小C" << "小D" << "小E" << "小F" << "小G" << "小H" << "小I";

    QStringList password;
    password << "12" << "23" << "34" << "45" << "56" << "67" << "78" << "89" << "90";
    // 綁定關(guān)鍵字后才能進行操作
    sql_query.prepare("INSERT INTO student (UserId, UserName, PassWord) "
                      "VALUES (:UserId, :UserName, :PassWord)");
    qint8 i = 0;
    foreach (QString name, names) // 從names表里獲取每個名字
    {
        sql_query.bindValue(":UserId", i+2); // 向綁定值里加入名字
        sql_query.bindValue(":UserName", name); // 成績
        sql_query.bindValue(":PassWord", password[i]); // 班級
        if(!sql_query.exec())
        {
            qDebug() << "Error: Fail." << sql_query.lastError();
        }
        i++;
    }
    // 讀取sqlite
    studentInfo tmp;
    QVector<studentInfo> infoVect; // 數(shù)據(jù)庫緩存
    sql_query.exec("SELECT * FROM student WHERE UserId >= 5 AND UserId <= 9;");
    while (sql_query.next())
    {
        tmp.UserId = sql_query.value(0).toInt();
        tmp.UserName = sql_query.value(1).toString();
        tmp.Password = sql_query.value(2).toString();
        qDebug() << tmp.UserId << tmp.UserName << tmp.Password;
        infoVect.push_back(tmp);
    }
    qDebug("done");

    // 更改表中數(shù)據(jù)
    sql_query.prepare("UPDATE student SET PassWord = 'admin' WHERE UserName = 'AppleCai'");
    if(!sql_query.exec())
    {
        qDebug() << "Error: Fail." << sql_query.lastError();
    }

    // 刪除表中數(shù)據(jù)
    sql_query.prepare("DELETE FROM student WHERE UserName = '小H'");
    if(!sql_query.exec())
    {
        qDebug() << "Error: Fail." << sql_query.lastError();
    }
}

#include "sqlitedatabase.h"

SqliteDatabase::SqliteDatabase()
{
    qDebug() << "hhh";
//    initPickNameDB();
}

void SqliteDatabase::initPickNameDB()
{
    // 創(chuàng)建并打開數(shù)據(jù)庫
    QSqlDatabase database;
    database = QSqlDatabase::addDatabase("QSQLITE");
//    qDebug() << QApplication::applicationDirPath();

    database.setDatabaseName(QApplication::applicationDirPath() + "/CONFIG/" + "PickNameDB.sqlite3");
    if(!database.open())
    {
        qDebug() << "Error: Failed to connect database." << database.lastError();
    }
    else
    {
        qDebug() << "Succeed to connect database.";
    }

    // 創(chuàng)建表格 先清空一下表
    QSqlQuery sql_query = database.exec("DROP TABLE department");
    sql_query = database.exec("DROP TABLE person");

    if(!sql_query.exec("create table department (Id int primary key not null, "
                       "DeptName vchar(50) not null )"))
    {
        qDebug() << "Error: Fail to create department table." << sql_query.lastError();
    }
    else
    {
        qDebug() << "Department table created!";
    }
    if(!sql_query.exec("create table person (Id int primary key not null , "
                       "DeptID integer not null , "
                       "PerName vchar(50) not null, "
                       "foreign key(DeptID) references department (Id))"))
    {
        qDebug() << "Error: Fail to create person table." << sql_query.lastError();
    }
    // 填充表
//    sql_query.exec("insert into department (id, name) values (1, '辦領(lǐng)導(dǎo)')");
//    sql_query.exec("insert into department (id, name) values (2, '綜合處')");
//    sql_query.exec("insert into department (id, name) values (3, '政策法規(guī)處')");
//    sql_query.exec("insert into department (id, name) values (4, '機構(gòu)改革處')");
//    sql_query.exec("insert into department (id, name) values (5, '黨群政法行政機構(gòu)編制管理處')");
//    sql_query.exec("insert into department (id, name) values (6, '政府行政機構(gòu)編制管理處')");
//    sql_query.exec("insert into department (id, name) values (7, '市縣行政機構(gòu)編制管理處')");
//    sql_query.exec("insert into department (id, name) values (8, '事業(yè)機構(gòu)編制管理處')");
//    sql_query.exec("insert into department (id, name) values (9, '事業(yè)單位登記管理處')");
//    sql_query.exec("insert into department (id, name) values (10, '機構(gòu)編制監(jiān)督檢查處')");
//    sql_query.exec("insert into department (id, name) values (11, '人事處')");
//    sql_query.exec("insert into department (id, name) values (12, '機關(guān)黨委')");
//    sql_query.exec("insert into department (id, name) values (13, '省機構(gòu)編制電子政務(wù)中心')");
//    sql_query.exec("insert into department (id, name) values (14, '省機構(gòu)編制研究中心')");

    // 批量填充表
    QStringList deptNames;
    deptNames << "辦領(lǐng)導(dǎo)" << "綜合處" << "政策法規(guī)處" << "機構(gòu)改革處"
              << "黨群政法行政機構(gòu)編制管理處" << "政府行政機構(gòu)編制管理處"
              << "市縣行政機構(gòu)編制管理處" << "事業(yè)機構(gòu)編制管理處" << "事業(yè)單位登記管理處"
              << "機構(gòu)編制監(jiān)督檢查處" << "人事處" << "機關(guān)黨委"
              << "省機構(gòu)編制電子政務(wù)中心" << "省機構(gòu)編制研究中心";

    // 綁定關(guān)鍵字后才能進行操作
    sql_query.prepare("INSERT INTO department (Id, DeptName) "
                      "VALUES (:Id, :DeptName)");
    qint8 i = 0;
    foreach (QString deptName, deptNames)
    {
        sql_query.bindValue(":Id", i + 1);
        sql_query.bindValue(":DeptName", deptName);
        if(!sql_query.exec())
        {
            qDebug() << "Error: Fail." << sql_query.lastError();
        }
        i++;
    }
    // 讀取sqlite
    department dept;
    QVector<department> tmpDept; // 數(shù)據(jù)庫緩存
    sql_query.exec("SELECT * FROM ");
}