#ifndef MYWIDGET_H
#define MYWIDGET_H
#include <QWidget>
#include <QtSql>
#include <QTimer>
#include <QPushButton>
#include <QLabel>
#include <QHBoxLayout>
#include <QVBoxLayout>
class MyWidget : public QWidget {
Q_OBJECT
public:
MyWidget(QWidget *parent = 0);
~MyWidget();
private slots:
void linkSqlData();
void sql();
private:
QLabel *text;
QPushButton *link;
QPushButton *addVideo;
QPushButton *addMatch;
void init();
};
#endif // MYWIDGET_H
#include "mywidget.h"
MyWidget::MyWidget(QWidget *parent)
{
this->setWindowTitle("***网站管理");
this->setFixedSize(200,100);
QLabel *text = new QLabel("数据库未连接",this);
QPushButton *link = new QPushButton("连接数据库",this);
QPushButton *addVideo = new QPushButton("添加视频",this);
QPushButton *addMatch = new QPushButton("添加比赛",this);
addVideo->setFixedSize(60,30);
addMatch->setFixedSize(60,30);
QHBoxLayout *hlayout = new QHBoxLayout;
QVBoxLayout *vlayout = new QVBoxLayout;
vlayout->addWidget(text);
vlayout->addWidget(link);
vlayout->setAlignment(Qt::AlignHCenter);
hlayout->addWidget(addVideo);
hlayout->addWidget(addMatch);
vlayout->addLayout(hlayout);
this->setLayout(vlayout);
QObject::connect(link,SIGNAL(clicked()),this,SLOT(linkSqlData()));
}
MyWidget::~MyWidget()
{
}
void MyWidget::init()
{
}
void MyWidget::linkSqlData()
{
link->setEnabled(false);
text->setText("<font style='color:red;'>数据库连接中...</font>");
QTimer::singleShot(6,this,SLOT(sql()));
}
void MyWidget::sql()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("***.***.***.***");
db.setDatabaseName("1234");
db.setUserName("1234");
db.setPassword("1234");
bool ok = db.open();
if(ok)
{
text->setText("<font style='color:red;'>数据库连接成功</font>");
}
else
{
text->setText("<font style='color:red;'>数据库连接成功</font>");
//link->setEnabled(true);
}
}
