创建SQLite数据库（2）

1. 判断文件存不存在

     QString filename = "./test.db";
    QFileInfo info(filename);
    bool ret = info.exists();
    if (ret)
    {
        qDebug() << filename << "is exist";
    }
    else
    {
        qDebug() << filename << "is not exist";
    }

2. 包含
   .pro 文件：QT += sql
   头文件：#include
   #include
3. 支持中文

//support chinese
query.exec("SET NAMES'Latin1'");

4. 插入内容

//insert content
            QString cmd_type1 = "insert into type values('0','TV')";
            QString cmd_type2 = "insert into type values('1','WM')";
            QString cmd_brand1 = "insert into brand values('01','0','brand1', '1000', '10', '3', '7')";
            QString cmd_brand2 = "insert into brand values('02','1','brand2', '2000', '20', '6', '14')";
            query.exec(cmd_type1);
            query.exec(cmd_type2);
            query.exec(cmd_brand1);
            query.exec(cmd_brand2);

5. 查询

QSqlQuery query(db);
        query.exec(QString("select name from  type"));
        QStringList strlist1;
        while(query.next())
        {
            strlist1 << query.value("name").toString();
        }
        qDebug() << "select name from  type:" << strlist1;

        query.exec(QString("select id1 from  brand"));
        QStringList strlist2;
        while(query.next())
        {
            strlist2 << query.value("id1").toString();
        }
        qDebug() << "select id1 from  brand:" << strlist2;

        query.exec(QString("select * from  brand where type = 'brand1'"));
        QStringList strlist3;
        while(query.next())
        {
            strlist3 << query.value("type").toString();
        }
        qDebug() << "select * from  brand where type = 'brand1':" << strlist3;