qt mysql操作图片案例_Qt之操作数据库（SQLite）实例

#include#include#include#include#include#include#include

int main(int argc, char *argv[])

{

QCoreApplication a(argc, argv);

QSqlDatabase database= QSqlDatabase::addDatabase("QSQLITE");

database.setDatabaseName("CashSystem.db");if(database.open())

{

qDebug()<

QSqlQuery sql_query;

QString create_sql= "create table member (id int primary key, name varchar(30), address varchar(30))"; //创建数据表

QString insert_sql = "insert into member values(?,?,?)"; //插入数据

QString select_all_sql= "select * from member";

sql_query.prepare(create_sql);//创建表

if(!sql_query.exec()) //查看创建表是否成功

{

qDebug()<<:tr create failed>

qDebug()<

}else{

qDebug()<< "Table Created";//插入数据

sql_query.prepare(inse