2_qt+sqlite3_plug

#include "mainwindow.h" #include "ui_mainwindow.h" #include <QString> #include <QMessageBox> #include <QDebug> using namespace std; MainWindow::MainWindow(QWidget *parent) : QMainWindow(parent), ui(new Ui::MainWindow) { ui->setupUi(this); rows = 0; index = 0; //连接数据库 db = QSqlDatabase::addDatabase ("QSQLITE"); //设置驱动 db.setDatabaseName ("/apps/test.db"); if(!db.open ()) { QMessageBox::warning (0, QObject::tr("Database error"), db.lastError ().text ()); return; } qDebug()<<"Connect success\n"; //查询user表格中已有数据的行数 QSqlQuery query; query.exec("SELECT COUNT(*) FROM users"); if(query.next()) rows = query.value(0).toInt(); qDebug()<<"Rows: "<<rows; ui->horizontalSlider->setMaximum(rows); } MainWindow::~MainWindow() { qDebug()<<"Quit...\n"; db.close(); delete ui; } void MainWindow::on_pushButton_ct_clicked() { const char *sSQL = "create table users (" "id integer PRIMARY KEY AUTOINCREMENT, " "name varchar(40) NOT NULL, " "age integer NOT NULL, " "birthday datetime NOT NULL, " "email varchar(40) NOT NULL);"; //执行建表SQL QSqlQuery query; query.exec(sSQL); rows = 0; index = 0; qDebug()<<"Datebase table creator success!!\n"; } void MainWindow::on_pushButton_ic_clicked() { rows++; QString sSQL = QString("insert into users values" "(%1, 'ws_%2', %3, '1989-5-4', 'westlor@foxmail.com');") .arg(rows).arg(rows).arg(20+rows); //执行插入数据 QSqlQuery query; query.exec(sSQL); ui->horizontalSlider->setMaximum(rows); qDebug()<<"Datebase insert success!\n"; } void MainWindow::on_pushButton_sp_clicked() { if(index > 1) index--; else index = 1; ui->textEdit->clear(); QString sSQL = QString("select * from users where id=%1").arg(index); //执行查询操作 QSqlQuery query; query.exec(sSQL); while(query.next()){ ui->textEdit->append(QString("id: ") + query.value(0).toString()); ui->textEdit->append(QString("name: ") + query.value(0).toString()); ui->textEdit->append(QString("age: ") + query.value(0).toString()); ui->textEdit->append(QString("birthday: ") + query.value(0).toString()); ui->textEdit->append(QString("email: ") + query.value(0).toString()); } ui->horizontalSlider->setValue(index); qDebug()<<"Datebase inquire success!!\n"; } void MainWindow::on_pushButton_dt_clicked() { const char *sSQL = "drop table users"; //delete table QSqlQuery query; query.exec(sSQL); rows = 0; index = 0; qDebug()<<"Datebase table delete success!!\n"; } void MainWindow::on_pushButton_sn_clicked() { if(index < rows) index++; else index = rows; ui->textEdit->clear(); QString sSQL = QString("select * from users where id=%1").arg(index); //执行查询操作 QSqlQuery query; query.exec(sSQL); while(query.next()){ ui->textEdit->append(QString("id: ") + query.value(0).toString()); ui->textEdit->append(QString("name: ") + query.value(0).toString()); ui->textEdit->append(QString("age: ") + query.value(0).toString()); ui->textEdit->append(QString("birthday: ") + query.value(0).toString()); ui->textEdit->append(QString("email: ") + query.value(0).toString()); } ui->horizontalSlider->setValue(index); qDebug()<<"Datebase inquire success!!\n"; } void MainWindow::on_pushButton_dc_clicked() { if(rows > 0) rows--; else{ qDebug()<<"No more row.."; return; } QString sSQL = QString("delete from users where id=%1").arg(rows+1); //delete row QSqlQuery query; query.exec(sSQL); ui->horizontalSlider->setMaximum(rows); qDebug()<<"Datebase delete success!\n"; }