示例#1
0
void getImage(){
   db = QSqlDatabase::addDatabase("QSQLITE");
   db.setDatabaseName("/home/seven7up/ImageData.sqlite");

   if(!db.open()){
       cout<< "connect to database fail";
   }
   else{
       QList<ImageObject> myList;
       ImageObject object;
       QSqlQuery q(db);
       int r;
       q.exec("select * from (LinkImage join Alphabet) where (LinkImage.idLetter = Alphabet.id)");
       for (r = 0, q.first(); q.isValid(); q.next(),++r) {

           object.SetId(q.value(0).toInt());
           object.SetLink(q.value(1).toString());
           object.SetLetterId(q.value(4).toString());
           myList.append(object);
       }

       foreach (const ImageObject &o, myList) {
               cout<< itos(o.GetId())+ "---" + o.GetLink().toStdString() + "--- "+ o.GetLetterId().toStdString() << endl;
       }
   }