qtforum.de

Code: Alles auswählen

QSqlTableModel * ESqlQuery::createVehicleModel(){

	QSqlRecord myRecord,myNewRecord;
	int myColumn=0,myRow=0;
	//int aI[8] = {0,23,26,35,42,43,48,49};
	
	QSqlDatabase myDB = QSqlDatabase::database("con",true);
	QSqlTableModel*  myVehicleModel = new QSqlTableModel(0,myDB);
	      myVehicleModel->setEditStrategy(QSqlTableModel::OnManualSubmit);
	myVehicleModel->setTable("Vehicle");
	//myVehicleModel->select();
	myColumn=myVehicleModel->columnCount(QModelIndex());
	myRow=myVehicleModel->rowCount(QModelIndex());

	QString sQuery = "SELECT idv, \"purchaseDate\",\"purchasePrice\","
							 "mileage, \"mileageDate\", \"firstDayOfPermission\", "
							 "\"vehicleName\", \"codePlate\" "
							 "FROM \"Vehicle\""
							 "ORDER BY idv";
	QSqlQuery query(sQuery,myDB);
	myVehicleModel->setQuery(query);// hier protecected,WARUM???
	
	myVehicleModel-> setHeaderData(0, Qt::Horizontal, QObject::tr("ID"));
    myVehicleModel-> setHeaderData(1, Qt::Horizontal, QObject::tr("Anschaffungsdatum"));
	myVehicleModel-> setHeaderData(2, Qt::Horizontal, QObject::tr("Anschaffungspreis"));
	myVehicleModel-> setHeaderData(3, Qt::Horizontal, QObject::tr("km-Stand"));
	myVehicleModel-> setHeaderData(4, Qt::Horizontal, QObject::tr("Datum km-Stand"));
	myVehicleModel-> setHeaderData(5, Qt::Horizontal, QObject::tr("Zulassungsdatum"));
	myVehicleModel-> setHeaderData(6, Qt::Horizontal, QObject::tr("Fahrzeugtyp"));
	myVehicleModel-> setHeaderData(7, Qt::Horizontal, QObject::tr("Kennzeichen"));
	
	myDB.close();
	return myVehicleModel;

}

Code: Alles auswählen

   myVehicleModel->select();

Code: Alles auswählen

QSqlTableModel *model = new QSqlTableModel;
model->setTable("Waren");
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
model->removeColumn(0); // Feld "ID" nicht anzeigen!
model->setHeaderData(0, Qt::Horizontal, QObject::tr("Name"));
model->setHeaderData(1, Qt::Horizontal, QObject::tr("Preis"));

QTableView *view = new QTableView;
view->setModel(model);
view->show();

Code: Alles auswählen

removeColumns()

Code: Alles auswählen

#include <QSqlTableModel>

class EMyModel : public QSqlTableModel
{
	Q_OBJECT

	public:
		EMyModel(QObject * parent = 0, QSqlDatabase db = QSqlDatabase());
		~EMyModel(void);	
};

Code: Alles auswählen

QSqlDatabase myDB = QSqlDatabase::database("con",true);
QSqlTableModel*  myVehicleModel = new QSqlTableModel(0,myDB);
myVehicleModel->setTable("Vehicle");
myVehicleModel->select();
myColumn=myVehicleModel->columnCount(QModelIndex());

	for(int i=myColumn;i>0;i--)
	{
		if( i != 49 && i != 48 && i != 43 && i != 42 && i != 35 && i!= 26 && i!= 23 && i!= 0)
		{		
			myVehicleModel->removeColumn(i);		
		}
	}

Code: Alles auswählen

typedef QMap<int, QStringList> resQueryArray;

resQueryArray ClassName::SqlDataGenerator(QString fullquery)
{
     resQueryArray res;
     QString tablequery = fullquery;
     QString line;
     QString rowone;
     QSqlQuery query;
     query.exec(tablequery);
     QSqlRecord rec = query.record();  /* nummer col */
     int numcol = rec.count();
     QStringList RowDataAll;
     int loop;
     int line = 0 - 1;
          while (query.next()) {
            RowDataAll.clear();
            line++;
            qDebug() << "### zeileNr. >> " << line << "##############################";
              for(loop=0; loop < numcol; loop++) {
                  QString felddata = query.value(loop).toString();
                  qDebug() << "### daten feld >> " << felddata;
                  RowDataAll.append(felddata);
              }
         res.insert(line,RowDataAll);
        }
return res;
}

/* die taten holen ... */


                           resQueryArray relist = SqlDataGenerator(QString( "SELECT firma, name, id  FROM %1 WHERE ort='%2' and land_code='%3' order by name" ).arg( TABLE_ADDO , pas , coustr));
                            resQueryArray::Iterator it;
                            for ( it = relist.begin(); it != relist.end(); ++it ) {
                               QStringList roxe = it.value();
                               QString firma = roxe.at(0).toLocal8Bit().constData();
                               QString name = roxe.at(1).toLocal8Bit().constData();
                               QString id = roxe.at(2).toLocal8Bit().constData();
                                /* oder noch einen zeilen for  um 0,1,2,3 ecc zu bekommen */
                                qDebug() << "###  die daten Iher weiter im table firma >> " << firma;    
                            }

Code: Alles auswählen

class CustomModel : public AbstractTableModel
{
   public:
   ...
   void setTableName(QString table);
   void setColumns(QList<QString> columnNames);
   int rowCount(const QModelIndex &parent = QModelIndex()) const;
   int columnCount(const QModelIndex &parent = QModelIndex()) const;
   QVariant data(const QModelIndex &index, int role = Qt::DisplayRole) const;
   QVariant headerData(int section, Qt::Orientation orientation, int role = Qt::DisplayRole) const;

private:
   QString m_queryString;
   
}