关于QT和SQLite以及XML

#include
#include
#include
#include 
#include
#include 
#include 
#include "connection.h"
#include 

int main(int argc, char * argv[]){

    QApplication a(argc,argv);

    qDebug() << QDir::currentPath();
    QDomDocument doc;
    QFile file("../database/important.xml");
    if(!file.open(QIODevice::ReadOnly)) {
        qDebug() <<"open failed";
        return 0;
    }
    if(!doc.setContent(&file)){
        file.close();
        return 0;
    }

    file.close();


    if(!createConnection()) {
        qDebug() <<"connection failed";
        return 1;
    }


    QSqlQuery query;

    QDomElement docElem = doc.documentElement();
    QDomNodeList list = doc.elementsByTagName(QString("Row"));

    for(int i=1; i){
        QString s = "";
        int index = 1;
        QDomNodeList attrs = list.at(i).childNodes();
        for(int j=0; j){
            if(attrs.at(j).toElement().attribute(QString("ss:Index"))!=""){　　　　//这里处理费了一阵功夫,因为这个xml文档中,当有些字段为空时,它会直接加一个index的标示符,而之前的就不生成节点了.
                while(index "ss:Index")).toInt()){
                    s = s+"\'" + "\'" + ",";
                    index ++;
                }

            }
            index ++;
            s += '\''+attrs.at(j).toElement().text()+'\'';
            if(index<=96){
                s += ',';
            }
        }
        while(index <= 96){　　　　//一共有96个字段
            s = s+ "\'" + "\'";
            if(index !=96){
                s+=",";
            }
            index++;
        }
        QString sr = "insert into tablename values("+s+")";
        query.exec(sr+";");
        qDebug() <<"--------------------------------";
        qDebug() << qPrintable(sr);

    }
    qDebug() << list.length();

    return a.exec();
}

/*******connectdb.h***********/
#ifndef CONNECTDB_H
#define CONNECTDB_H

#include 
#include 
#include 
#include 
#include 

class ConnectDB
{
public:
    ConnectDB(QString dbname="database.db
");
    //ConnectDB();
    ~ConnectDB();

    QSqlDatabase db;
    QSqlQuery select(QString sql);

    void getSubstance(QComboBox *box);
};

#endif // CONNECTDB_H



/****************connectdb.cpp*************/
#include "connectdb.h"
#include 

ConnectDB::ConnectDB(QString dbname)
{
    db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(dbname);
    if( !db.open() ){
        QMessageBox::critical(0, "Cannot open database",
                              "Unable to establish a database connection.", QMessageBox::Cancel);
    }
}

ConnectDB::~ConnectDB(){

}

QSqlQuery ConnectDB::select(QString sql){
    QSqlQuery query;
    query.exec(sql);
    return query;
}

//这个函数作用是获取数据库中的物质名称填充到组件的comboBox中去
void ConnectDB::getSubstance(QComboBox *box){
   QString sql = "select 中文名称 from tablename order by id";
   QSqlQuery query = this->select(sql);
   while(query.next()){
       QString item = query.value(0).toString();
       box->addItem(QString(item));
   }
}



/**********调用方法************/


#include "connectdb.h"

......

ConnectDB *db = new ConnectDB();

    ComboBox *nameSelect = new QComboBox;
    db->getSubstance(nameSelect);