//定义数据库。Tip:temp数据库和student数据库定义一样,只是一个媒介表。
QSqlQuery sql(my_db);
//删除temp表格中的数据
sql.exec("delete from temp;");
//将student数据按照id升序导入进temp
sql.exec("insert into temp select * from student order by id desc");
//删除student数据
sql.exec("delete from student;");
//将temp数据导入student
sql.exec("insert into student select * from temp;");
效果前:
效果后(点击倒序后):