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; } }