QT5 数据库操作与数据库可视化
.h 文件
【QT5 数据库操作与数据库可视化】#pragma once
#ifndef _DATABASE_H_
#define _DATABASE_H_
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include "database_global.h"
class DATABASE_EXPORT DataBase
{
public:
DataBase();
~DataBase();
void CreateTable(std::string fileDataBase);
bool ModelOperateDatabase(std::string fielPath);
bool Connect(const QString &dbName);
void VisualDataBase(std::string fielPath);
private:
std::string filepath;
enum ColumnIndex
{
Column_ID = 0,
Column_Name = 1,
Column_Age = 2
};
};
#endif
>>>>>.cpp 文件 代码
#include "DataBase.h"
DataBase::DataBase()
{
}
bool DataBase::Connect(const QString &dbName)
{
QSqlDatabase m_Db = QSqlDatabase::addDatabase("QSQLITE");
m_Db.setHostName("regen");
// seting hostname
m_Db.setUserName("haung");
m_Db.setPassword("123456");
// seting log password
m_Db.setDatabaseName(dbName);
if (!m_Db.open()) {
QMessageBox::critical(0, QObject::tr("Database Error"),
m_Db.lastError().text());
return false;
}
return true;
}
void DataBase::CreateTable(std::string fileDataBase)
{
QFile::remove(fileDataBase.c_str());
// mkaing sure sys.db do not exist
if (Connect(fileDataBase.c_str()))//connect Table
{
QSqlQuery m_Query;
boolSuccessFlg = m_Query.exec("create table REGEN("
"id int primary key,"
"LastName varchar(100),"
"FirstName varchar(100),"
"Address varchar(255),"
"City varchar(50))");
// Create REGENTable
m_Query.exec("CREATE TABLE student ("//Create student table
"id INTEGER PRIMARY KEY AUTOINCREMENT,"
"name VARCHAR,"
"age INT)");
/*
CREATE TABLE Persons
(
Id_P int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (Id_P)
)
*/
// PRIMARY KEY 约束唯一标识数据库表中的每条记录。
if (SuccessFlg)
{
qDebug() << " Create REGEN TABLE successful ";
m_Query.prepare("INSERT INTO student (name, age) VALUES (?, ?)");
// Insert student Table
QVariantList m_Names;
// continus operate database
m_Names << "huang" << "LI" << "Tom" << "Jack";
m_Query.addBindValue(m_Names);
QVariantList m_Ages;
m_Ages << "18" << "50" << "80" << "25";
m_Query.addBindValue(m_Ages);
if (!m_Query.execBatch())
{
QMessageBox::critical(0, QObject::tr("Database Error"),
m_Query.lastError().text());
}
m_Query.finish();
m_Query.exec("SELECT name, age FROM student");
while (m_Query.next()) {
QString name = m_Query.value(0).toString();
int age = m_Query.value(1).toInt();
qDebug() << name << ": " << age;
}
}
else
{
qDebug() << " Create Table failed ! ";
QMessageBox::critical(0, QObject::tr("Database Error"),
m_Query.lastError().text());
}
m_Query.clear();
}
}
bool DataBase::ModelOperateDatabase(std::string fielPath)// QSqlTableModel 进行 SELECT 操作：
{
//row 行 col 列
if (Connect("demo.db")) {
QSqlTableModel model;
model.setTable("student");
model.setFilter("age > 20 and age < 25");
if (model.select()) {
for (int i = 0;
i < model.rowCount();
++i) {
QSqlRecord record = model.record(i);
QString name = record.value("name").toString();
int age = record.value("age").toInt();
qDebug() << name << ": " << age;
}
}
}
else {
return 1;
}
}
void DataBase::VisualDataBase(std::string fielPath)
{
if (Connect(fielPath.c_str())) {
QSqlTableModel *model = new QSqlTableModel;
model->setTable("student");
model->setSort(Column_Name, Qt::AscendingOrder);
model->setHeaderData(Column_Name, Qt::Horizontal, "Name");
model->setHeaderData(Column_Age, Qt::Horizontal, "Age");
model->select();
QTableView *view = new QTableView;
view->setModel(model);
view->setSelectionMode(QAbstractItemView::SingleSelection);
view->setSelectionBehavior(QAbstractItemView::SelectRows);
view->setColumnHidden(Column_ID, true);
// hide function
view->resizeColumnsToContents();
view->setEditTriggers(QAbstractItemView::NoEditTriggers);
QHeaderView *header = view->horizontalHeader();
header->setStretchLastSection(true);
view->show();
}
}
》》》》》》》》使用时的代码
m_DataBase = new DataBase;
m_DataBase->CreateTable(DataFilePath);
m_DataBase->VisualDataBase(DataFilePath);
在设置好 model 之后，我们又创建了QTableView对象作为视图。注意这里的设置：单行选择，按行选择。resizeColumnsToContents()说明每列宽度适配其内容；setEditTriggers()则禁用编辑功能。最后，我们设置最后一列要充满整个窗口。我们的代码中有一行注释，设置第一列不显示。由于我们使用了QSqlTableModel方式，不能按列查看，所以我们在视图级别上面做文章：将不想显示的列隐藏掉。
接下来运行代码即可看到效果：
文章图片
推荐阅读
- Docker应用:容器间通信与Mariadb数据库主从复制
- 2.6|2.6 Photoshop操作步骤的撤消和重做 [Ps教程]
- MongoDB，Wondows下免安装版|MongoDB，Wondows下免安装版 （简化版操作）
- 在线版的迅捷思维导图怎么操作（）
- 操作系统|[译]从内部了解现代浏览器(1)
- 数据库设计与优化
- 数据库总结语句
- JS常见数组操作补充
- MySql数据库备份与恢复
- 7、前端--jQuery简介、基本选择器、基本筛选器、属性选择器、表单选择器、筛选器方法、节点操作、绑定事件