• 3853阅读
  • 1回复

以下情况如何创建数据库表? [复制链接]

上一主题 下一主题
离线liumingguang
 
只看楼主 倒序阅读 楼主  发表于: 2009-11-02
    我的表名开始没有确定,而是通过一个字符串确定,如下:
    QString tab="mytab";
    QSqlQuery query;
    query.exec("CREATE TABLE  表名 (id INTEGER PRIMARY KEY AUTOINCREMENT,"//这里要求表名=tab字符串
                                                   "datetime  VARCHAR(30) ,"
                                                   "name VARCHAR(30) ,"
                                                   "addr VARCHAR(16),"
                                                   "type VARCHAR(20) ,"
                                                   "explain VARCHAR(10) )");
离线liumingguang
只看该作者 1楼 发表于: 2009-11-02
摸索了老半天终于找到了一个好的方法,呵呵,自己动手丰衣足食。
QString aaa="messageofalarm_fault";
query.exec(QString("CREATE TABLE %1(id INTEGER PRIMARY KEY AUTOINCREMENT,"
                                                   "datetime  VARCHAR(30) ,"
                                                   "name VARCHAR(30) ,"
                                                   "addr VARCHAR(16),"
                                                   "type VARCHAR(20) ,"
                                                   "explain6VARCHAR(10) )").arg(aaa));
快速回复
限100 字节
 
上一个 下一个