//创建人员组别表，2个参量 组别ID 和组别名称
31. QSqlQuery query;
32. if(!query.exec("CREATE TABLE table_group(group_id INTEGER PRIMARY KEY, group_name VCHAR(10))"))
33. {
34. return query.lastError();
35. }
36.
37. //添加数据
38. query.exec("INSERT INTO table_group VALUES(1, 'teacher')");
39. query.exec("INSERT INTO table_group VALUES(2, 'student')");
40.
41. //查看数据库
42. query.exec("SELECT * FROM table_group");
43.
44. while(query.next())
45. {
46. int group_id = query.value(0).toInt();
47. QString group_name = query.value(1).toString();
48. qDebug() << "group id=" << group_id;
49. qDebug() << "group name=" << group_name;
50. }
http://blog.csdn.net/fzu_dianzi/article/details/6960580
http://blog.csdn.net/markely/article/details/8025998
