Your code using a model was not so far try this
http://doc.qt.io/qt-4.8/qsqltablemodel.html/#details