mysqltablemodel.h

跨平台,多数据库查看编辑和查询工具,平台支持windows,linux,数据库支持oracle,odbc,mysql,slite等

#ifndef MYSQLTABLEMODEL_H
#define MYSQLTABLEMODEL_H

#include <QtGui>
#include <QtSql>
#include "struct.h"
#include "tableviewfilter.h"

class MySqlTableModel: public QSqlTableModel
{
	Q_OBJECT
public:
	MySqlTableModel(QObject *parent=0, QSqlDatabase db = QSqlDatabase());
	~MySqlTableModel();
	void setKeyField(const QSqlIndex &index);
	bool selectResult();
	bool save();
	void cancel();
	bool setData ( const QModelIndex & index, const QVariant & value, int role = Qt::EditRole );
	void setRelation ( int column, const QSqlRelation & relation );
	QSqlRelation getRelation(int column);
	QMap <int,
	      QList<QPair<QString, QString> >
	     > mapValues;
	     
	QString connectName;

protected:
	bool updateRowInTable(int row, const QSqlRecord &values);
private :
	QMap <int,QSqlRelation> mapRelation;
	
};

#endif