WebSVN - OpenInventory - Различия - Редакция 45 и 56


/************************************************************************************
** Êëàññ 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(); // ñîåäèíåíèå ñ áàçîé äàííûõ
    bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
    bool createListOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è êëàññîâ (Òàáëèöà ListOfClasses)
    bool createDescriptionOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses)
signals:

public slots:

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

protected:

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

    QString lasError();


};

#endif // MYSQL_H
 

Редакция 45	Редакция 56
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(); // ñîåäèíåíèå ñ áàçîé äàííûõ	40	bool connect(); // ñîåäèíåíèå ñ áàçîé äàííûõ
41	bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)	41	bool createDataBase(); // ñîçäàåò íåîáõîäèìûå òàáëèöû â þàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è îïèñàíèÿ êëàññîâ (Òàáëèöà ListOfClasses è Òàáëèöà DescriptionOfClasses)
-		42	bool createListOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ íàçâàíèÿ è êëàññîâ (Òàáëèöà ListOfClasses)
-		43	bool createDescriptionOfClassesTable(); // ñîçäàåò íåîáõîäèìóþ òàáëèöó â áàçå äàííûõ äëÿ õðàíåíèÿ îïèñàíèÿ êëàññîâ (Òàáëèöà DescriptionOfClasses)
42	signals:	44	signals:
43		45
44	public slots:	46	public slots:
45		47
46	private:	48	private:
47	QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå	49	QString sqlDatabaseName; // ïåðåìåííàÿ ñîäåðæèò èìÿ áàçû äàííûõ, ñ êîòîðîé áóäåì óñòàíàâëèâàòü ñîåäèíåíèå
48	QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ	50	QString sqlUserName; // ïåðåìåííàÿ ñîäåðæèò èìÿ ïîëüçîâàòåëÿ áàçû äàííûõ
49	QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ	51	QString sqlPassword; // ïåðåìåííàÿ ñîäåðæèò ïàðîëü ê áàçå äàííûõ
50	QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ	52	QString sqlHostName; // ïåðåìåííàÿ ñîäåðæèò èìÿ õîñòà, íà êîòîðîì íàõîäèòñÿ áàçà äàííûõ
51	QSqlDatabase db;	53	QSqlDatabase db;
52	QString mysqlLastError;	54	QString mysqlLastError;
53		55
54	protected:	56	protected:
55		57
56	public:	58	public:
57	void setDatabaseName(QString dbname);	59	void setDatabaseName(QString dbname);
58	void setUserName(QString uname);	60	void setUserName(QString uname);
59	void setPassword(QString passwrd);	61	void setPassword(QString passwrd);
60	void setHostName(QString hname);	62	void setHostName(QString hname);
61	bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó	63	bool createTable(SqlTable* table); // ñîçäàåò â áàçå äàííûõ òàáëèöó
62		64
63	QString lasError();	65	QString lasError();
64		66
65		67
66	};	68	};
67		69
68	#endif // MYSQL_H	70	#endif // MYSQL_H
69		71

Хранилища Subversion OpenInventory

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