那在创建表的时候,应该把那个字段的类型定义为什么呢?
另外当我执行下面程序会显示:"11111" "zzz",
很奇怪~我定义成char(0)居然也是同样的输出
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("zzz");
db.setDatabaseName("user");
db.setUserName("zzz");
db.setPassword("zzlm0221");
if(!db.open())
{
ui->textBrowser->setText("NO");
}else{
ui->textBrowser->setText("YES");
}
QSqlQuery query;
query.exec("drop table user");
query.exec("create table user (idnum char(4) primary key, name QString )");
query.prepare("insert into user values('11111',:name1)");
query.bindValue(":name1", tr("zzz"));
query.exec();
query.exec("select * from user");
while(query.next())
qDebug() << query.value(0).toString() << query.value(1).toString();