创建表:
QString sql = "create table user(id int primary key, name varchar(30), age int)";
插入记录:
QString sql = "insert into user values (?, ?, ?)";
修改:
QString sql = "update userset name = :name where id = :id";
查询指定字段:
QString sql = "select id, name from user";
查询表中所有记录:
QString select_all_sql = "select * from user";
根据id删除记录:
QString sql = "delete from user where id = ?";
删除表中所有记录:
QString clear_sql = "delete from student";
后续公众号会发布系列教程,更多内容请关注公众号:程序猿学习日记