使用QT构建图书馆数据库系统 (qt图书馆数据库)

#include

#include

QSqlDatabase db = QSqlDatabase::addDatabase(“QSQLITE”);

db.setDatabaseName(“library”);

if (!db.open()) {

qDebug()

}

QSqlQuery query;

query.exec(“create table book (“

“id int primary key, “

“title varchar(255), “

“author_id int, “

“publisher_id int, “

“in varchar(20),”

“year int”

“)”);

query.exec(“create table author(“

“id int primary key, “

“name varchar(100)”

“)”);

query.exec(“create table publisher( “

“id int primary key, “

“name varchar(255)”

“)”);

QSqlQuery query;

query.prepare(“insert into book (id, title, author_id, publisher_id, in, year) “

“values (:id, :title, :author_id, :publisher_id, :in, :year)”);

query.bindValue(“:id”, 1);

query.bindValue(“:title”, “The Great Gaty”);

query.bindValue(“:author_id”, 1);

query.bindValue(“:publisher_id”, 1);

query.bindValue(“:in”, “9780141182636”);

query.bindValue(“:year”, 1925);

query.exec();

QSqlQuery query;

query.exec(“select * from book”);

while (query.next()) {

int id = query.value(0).toInt();

QString title = query.value(1).toString();

int author_id = query.value(2).toInt();

int publisher_id = query.value(3).toInt();

QString in = query.value(4).toString();

int year = query.value(5).toInt();

qDebug()