/trunk/ClassEditor/classeditor.ui |
---|
14,16 → 14,32 |
<string>ClassEditor</string> |
</property> |
<widget class="QWidget" name="centralWidget"> |
<widget class="QLineEdit" name="lineEdit"> |
<widget class="QLabel" name="label"> |
<property name="geometry"> |
<rect> |
<x>20</x> |
<y>30</y> |
<width>571</width> |
<height>32</height> |
<x>10</x> |
<y>40</y> |
<width>581</width> |
<height>21</height> |
</rect> |
</property> |
<property name="text"> |
<string>TextLabel</string> |
</property> |
</widget> |
<widget class="QLabel" name="label_2"> |
<property name="geometry"> |
<rect> |
<x>10</x> |
<y>70</y> |
<width>581</width> |
<height>21</height> |
</rect> |
</property> |
<property name="text"> |
<string>TextLabel</string> |
</property> |
</widget> |
</widget> |
<widget class="QMenuBar" name="menuBar"> |
<property name="geometry"> |
31,7 → 47,7 |
<x>0</x> |
<y>0</y> |
<width>600</width> |
<height>28</height> |
<height>27</height> |
</rect> |
</property> |
</widget> |
/trunk/ClassEditor/sqltable.cpp |
---|
1,18 → 1,48 |
#include "sqltable.h" |
SqlTable::SqlTable(QString tname, QObject *parent): |
SqlTable::SqlTable(QString tname, QObject *parent) : |
QObject(parent) |
{ |
TableField field_tmp; |
tableName = tname; |
//field_tmp = new TableField(tr("ID")); // ïðè ñîçäàíèè òàáëèöû äîáàâèì ïîëå "ID" (ñ÷åò÷èê) |
field_tmp.setType(tr("INT(10)")); |
fields.append(&field_tmp); |
field_tmp = new TableField("ID", this); // ïðè ñîçäàíèè òàáëèöû äîáàâèì ïîëå "ID" (ñ÷åò÷èê) |
field_tmp->setType(tr("INT(10)")); |
tableFields.append(field_tmp); // äîáàâëÿåì íîâîå ïîëå (óêàçàòåëü) â ñïèñîê (óêàçàòåëåé) ïîëåé |
primaryKey = field_tmp->name(); // äåëàåì íàøå åäèíñòâåííîå ïîëå ïåðâè÷íûì êëþ÷îì |
//delete field_tmp; |
} |
/*************************************************************************************** |
** ôóíêöèÿ ïðèñâàèâàåò èìÿ òàáëèöå, íîâîå èìÿ ïåðåäàåòñÿ â ïàðàìåòðå ôóíêöèè tname |
** |
** |
***************************************************************************************/ |
void SqlTable::setName(QString tname){ |
SqlTable::tableName = tname; |
} |
/*************************************************************************************** |
** ôóíêöèÿ âîçâðàùàåò èìÿ òàáëèöû |
** |
** |
***************************************************************************************/ |
QString SqlTable::name(){ |
return SqlTable::tableName; |
} |
/*************************************************************************************** |
** ôóíêöèÿ âîçâðàùàåò ñïèñîê óêàçàòåëåé íà ïîëÿ òàáëèöû |
** |
** |
***************************************************************************************/ |
QList<TableField*> SqlTable::fields(){ |
return SqlTable::tableFields; |
} |
/trunk/ClassEditor/mysql.h |
---|
13,6 → 13,10 |
#ifndef MYSQL_H |
#define MYSQL_H |
#include "settingsdialog.h" |
#include "tablefield.h" |
#include "sqltable.h" |
#include <QObject> |
#include <QtGui> |
#include <QMainWindow> |
/trunk/ClassEditor/classeditor.cpp |
---|
10,16 → 10,21 |
settdialog.show(); |
sql.setDatabaseName(tr("an_db")); |
field = new TableField(tr("Ñîòðóäíèêè"), this); |
// field->setNotNull(true); |
field->setNotNull(true); |
field->setDefaultValue(tr("ñîòðóäíèê")); |
ui->lineEdit->insert(field->sqlString()); |
//delete field; |
table = new SqlTable (tr("NewTable"), this); |
table->setName(tr("NewTable")); |
ui->label_2->setText(table->name()); |
ui->label->setText(table->fields().at(0)->sqlString()); |
} |
ClassEditor::~ClassEditor() |
{ |
delete ui; |
// delete field; |
// delete settdialog; |
} |
/trunk/ClassEditor/sqltable.h |
---|
8,22 → 8,27 |
class SqlTable : public QObject |
{ |
Q_OBJECT |
Q_OBJECT |
public: |
explicit SqlTable(QString tname, QObject *parent = 0); |
void setName(QString tname); |
void setName(QString tname); // ôóíêöèÿ ïðèñâàèâàåò èìÿ òàáëèöå, èìå ïåðåäàåòñÿ â ïàðàìåòðå ôóíêöèè tname |
QString name(); // ôóíêöèÿ áåç ïàðàìåòðîâ âîçâðàùàåò èìÿ òàáëèöû |
QList<TableField*> fields(); // âîçâðàùàåò ñïèñîê óêàçàòåëåé íà ïîëÿ òàáëèöû |
private: |
QString tableName; // èìÿ òàáëèöû |
QString SqlString; // ñòðîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ òàáëèöû â áàçå äàííûõ |
QList<TableField*> fields; // â ýòîì ñïèñêå íàõîäòñÿ âñå ïîëÿ òàáëèöû |
//TableField *field_tmp; |
QString tableName; // èìÿ òàáëèöû |
QString SqlString; // ñòðîêà Sql-çàïðîñà äëÿ ñîçäàíèÿ òàáëèöû â áàçå äàííûõ |
QString characterSet; // ïåðåìåííàÿ ñîäåðæèò êîäèðîâêó, â êîòîðîé õðàíÿòüñÿ òåêñòîâûå äàííûå |
QString primaryKey; // èìÿ ïîëÿ, ÿâëÿþùåãîñÿ ïåðâè÷íûì êëþ÷îì òàáëèöû |
int primaryKeyIndex; // ïîðÿäêîâûé íîìåð ïîëÿ (â ñïèñêå ïîëåé fields), êîòîðîå ÿâëÿåòñÿ ïåðâè÷íûì êëþ÷îì òàáëèöû |
QList<TableField*> tableFields; // â ýòîì ñïèñêå íàõîäòñÿ âñå ïîëÿ òàáëèöû |
TableField *field_tmp; |
protected: |
}; |
#endif // SQLTABLE_H |
/trunk/ClassEditor/tablefield.h |
---|
28,8 → 28,7 |
***********************************************************************************************/ |
/////explicit |
TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL"); |
explicit TableField(QString fname = "ID", QObject *parent = 0, QString ftype = "CHAR(30)", QString fdefaultValue = "NULL"); |
signals: |
/trunk/ClassEditor/classeditor.h |
---|
3,9 → 3,9 |
#include <QMainWindow> |
#include "mysql.h" |
#include "settingsdialog.h" |
#include "tablefield.h" |
namespace Ui { |
class ClassEditor; |
} |
24,6 → 24,7 |
MySql sql; |
SettingsDialog settdialog; |
TableField *field; |
SqlTable *table; |
}; |
#endif // CLASSEDITOR_H |