WebSVN - OpenInventory - Различия - Редакция 42 и 44


/************************************************************************************
** Êëàññ MySQL ñîäåðæèò ìåòîäû äëÿ ðàáîòû ñ áàçàìè äàííûõ
** MySQL class contains methods for working with databases
**
**
*************************************************************************************/






#ifndef MYSQL_H
#define MYSQL_H

#include "settingsdialog.h"
#include "tablefield.h"
#include "sqltable.h"

#include <QObject>
#include <QtGui>
#include <QMainWindow>
#include <QString>
#include <QtSql>
#include <QSqlTableModel>
#include <QTableView>
#include <QSqlDriverPlugin>
#include <QIcon>
#include <QVariant>
#include <QProcess>
#include <QByteArray>


class MySql : public QObject
{
Q_OBJECT
public:
    explicit MySql(QObject *parent = 0);

    bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ

signals:

public slots:

private:
    QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå
    QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ
    QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ
    QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ
    QSqlDatabase db;

protected:

public:
    void setDatabaseName(QString dbname);
    void setUserName(QString uname);
    void setPassword(QString passwrd);
    void setHostName(QString hname);
    bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó
    QString mysqlLastError;
    QString lasError();

};

#endif // MYSQL_H
 

Редакция 42	Редакция 44
1	/************************************************************************************	1	/************************************************************************************
2	** Êëàññ MySQL ñîäåðæèò ìåòîäû äëÿ ðàáîòû ñ áàçàìè äàííûõ	2	** Êëàññ MySQL ñîäåðæèò ìåòîäû äëÿ ðàáîòû ñ áàçàìè äàííûõ
3	** MySQL class contains methods for working with databases	3	** MySQL class contains methods for working with databases
4	**	4	**
5	**	5	**
6	*************************************************************************************/	6	*************************************************************************************/
7		7
8		8
9		9
10		10
11		11
12		12
13	#ifndef MYSQL_H	13	#ifndef MYSQL_H
14	#define MYSQL_H	14	#define MYSQL_H
15		15
16	#include "settingsdialog.h"	16	#include "settingsdialog.h"
17	#include "tablefield.h"	17	#include "tablefield.h"
18	#include "sqltable.h"	18	#include "sqltable.h"
19		19
20	#include <QObject>	20	#include <QObject>
21	#include <QtGui>	21	#include <QtGui>
22	#include <QMainWindow>	22	#include <QMainWindow>
23	#include <QString>	23	#include <QString>
24	#include <QtSql>	24	#include <QtSql>
25	#include <QSqlTableModel>	25	#include <QSqlTableModel>
26	#include <QTableView>	26	#include <QTableView>
27	#include <QSqlDriverPlugin>	27	#include <QSqlDriverPlugin>
28	#include <QIcon>	28	#include <QIcon>
29	#include <QVariant>	29	#include <QVariant>
30	#include <QProcess>	30	#include <QProcess>
31	#include <QByteArray>	31	#include <QByteArray>
32		32
33		33
34	class MySql : public QObject	34	class MySql : public QObject
35	{	35	{
36	Q_OBJECT	36	Q_OBJECT
37	public:	37	public:
38	explicit MySql(QObject *parent = 0);	38	explicit MySql(QObject *parent = 0);
39		39
40	bool connect(QString* errorString); // ñîåäèíåíèå ñ áàçîé äàííûõ	40	bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ
41		41
42	signals:	42	signals:
43		43
44	public slots:	44	public slots:
45		45
46	private:	46	private:
47	QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå	47	QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå
48	QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ	48	QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ
49	QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ	49	QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ
50	QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ	50	QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ
51	QSqlDatabase db;	51	QSqlDatabase db;
52		52
53	protected:	53	protected:
54		54
55	public:	55	public:
56	void setDatabaseName(QString dbname);	56	void setDatabaseName(QString dbname);
57	void setUserName(QString uname);	57	void setUserName(QString uname);
58	void setPassword(QString passwrd);	58	void setPassword(QString passwrd);
59	void setHostName(QString hname);	59	void setHostName(QString hname);
60	bool createTable(SqlTable* table, QString* errorString); // ñîçäàåò â áàçå äàííûõ òàáëèöó	60	bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó
-		61	QString mysqlLastError;
-		62	QString lasError();
61		63
62	};	64	};
63		65
64	#endif // MYSQL_H	66	#endif // MYSQL_H
65		67

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/mysql.h - Редакция 42 → 44