基本语句
注意:命令不区分大小写 比如insert和INSERT是一样的
·创建表
create table tab_test(date int , time int, contents varchar(20))
·增
insert into tab_test(date,time, contents) values (1,2,“test”)
·删
delete from tab_test where date>10
·改
update tab_test set date= 1 where time=2
·查
select date from tab_test where time=10
代码示例
QSqlQuery query;
QSqlDatabase sql_test;
//1.检查链接是否存在
if(QSqlDatabase::contains("qsqlite_test"))
//qsqlite_test是定义的连接名 不填将使用默认连接名
sql_test = QSqlDatabase::database("QSQLITE","qsqlite_test");
else
sql_test = QSqlDatabase::addDatabase("QSQLITE","qsqlite_test");
//2.根据日期命名数据库
QString str_dbname = QDate: