#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QUuid>
MainWindow::MainWindow(QWidget *parent) :
QMainWindow(parent),
ui(new Ui::MainWindow)
{
ui->setupUi(this);
qDebug() << QSqlDatabase::drivers();
//建立数据库连接
m_db = QSqlDatabase::addDatabase("QSQLITE");
m_db.setDatabaseName("db.sqlite");
m_db.setUserName("qt");
m_db.setPassword("111111");
m_db.setHostName("127.0.0.1");
m_db.setPort(0);
//打开数据库
bool ok = m_db.open();
if (!ok){
qDebug() << m_db.lastError().text();
}
else{
qDebug() << "打开成功!可以进行数据库查询操作";
}
//建立查询链接
QSqlQuery query(m_db);
ok = query.exec(
if (!query.exec("CREATE TABLE student ("
"id INT PRIMARY KEY AUTOINCREMENT,"
"name VARCHAR(255),"
"age INT)"));
if (!ok) {
qDebug() << query.lastError().text();
}
// :name :id;
//定义id name 两个性质 初始值为任意
QString sql = "INSERT into t_user(id,name) values(?, ?)";
if (query.prepare(sql)) {
query.bindValue(0, QUuid::createUuid().toString()); //赋值user
query.bindValue(1, "qt.name"); //
query.exec();
qDebug() << query.lastError().text();
}
else{
qDebug() << query.lastError().text();
}
query.exec("select * from vlure");
while (query.next()){
QSqlRecord r = query.record();
qDebug() << r;
qDebug() << "--------------------------------------------";
qDebug() << r.field(0).name() << ":" << r.field("id").value();
qDebug() << r.field(1).name() << ":" << r.field("name").value();
}
//定义数据库表格模型
m_model = new QSqlTableModel(this, m_db);
m_model->setTable("t_user");
m_model->select();
ui->tableView->setModel(m_model);
}
MainWindow::~MainWindow()
{
delete ui;
}