WebSVN - OpenInventory - Различия - Редакция 73 и 96


/************************************************************************************
** Êëàññ 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>
#include <QSqlQuery>


class MySql : public QObject
{
Q_OBJECT
public:
    explicit MySql(QObject *parent = 0);
 ~MySql();
    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();
    QSqlError dbLastError(); // ôóíêöèÿ ôîçâðàùàåò ïîñëåäíþþ îøèáêó áàçû äàííûõ


};

#endif // MYSQL_H
 

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

Хранилища Subversion OpenInventory

(root)/trunk/ClassEditor/mysql.h @ 210 - Редакция 73 → 96