#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
//判断数据库是否存在
//函数原型:static bool contains(const QString& connectionName = QLatin1String(defaultConnection));
//返回值:bool类型 存在则放回true 否则false
if( !db.contains("stuInfo.db"))
{
//说明数据库不存在
db = QSqlDatabase::addDatabase("QSQLITE"); //创建一个数据库 驱动为sqlite3
//给数据库命名
db.setDatabaseName("stuInfo.db");
}
//打开数据库
if( !db.open() )
{
//说明数据库打开失败
QMessageBox::information(this,"","打开数据库失败!");
return;
}
//程序运行至此,说明数据库创建成功并且打开
//创建数据库表
//实例化一个执行sql语句的对象
QSqlQuery query;
//准备sql语句
QString sql = "create table if not exists stu_info_table("
"id integer primary key autoincrement,"
"numb integer,"
"name varchar(20),"
"sex varchar(4),"
"score integer)";
//执行sql语句
if( query.exec(sql) )
{
QMessageBox::information(this,"","数据库表创建成功!");
}
else
{
QMessageBox::information(this,"","数据库表创建失败!");
return;
}
}
Widget::~Widget()
{
delete ui;
}
//添加按钮对应的槽函数处理
void Widget::on_addBtn_clicked()
{
//获取ui界面上的信息
int numb = ui->numEdit->text().toInt();
QString name = ui->nameEdit->text();
QString sex = ui->sexEdit->text();
int score = ui->scoreEdit->text().toInt();
//保证信息填写完整
if(numb == 0 || name.isEmpty() || sex.isEmpty() || score == 0)
{
QMessageBox::information(this,"","请将信息填写完整");
return;
}
//准备sql语句
QString sql = QString("insert into stu_info_table(numb,name,sex,score)"
"values(%1,'%2','%3',%4)").arg(numb).arg(name).arg(sex).arg(score);
//实例化一个执行sqL语句的对象
QSqlQuery query;
//执行sql语句
if( query.exec(sql))
{
QMessageBox::information(this,"","添加成功");
}
else
{
QMessageBox::information(this,"","添加失败");
return;
}
}
//显示按钮对应的槽函数处理
void Widget::on_showBtn_clicked()
{
//准备sql语句
QString sql = "select * from stu_info_table";
//实例化一个执行sql语句对象
QSqlQuery query;
//执行sql语句
if( !query.exec(sql) )
{
QMessageBox::information(this,"","查询失败");
return;
}
//程序运行至此,意味着已经将查询所有的内容放入query中
int i=0; //记录行数
while (query.next())
{
for(int j=0; j<query.record().count(); j++)
//列的总数
{
//将第i行第j列的元素放入ui界面上
ui->tableWidget->setItem(i,j,new QTableWidgetItem(query.value(j+1).toString()));
}
i++;
}
}