数据库单条插入命令，这的为什么不行

QSqlQuery query;
query.exec("INSERT INTO employee (id, name, salary) " "VALUES (1001, 'Thad Beaumont', 65000)");
"INSERT INTO employee (id, name, salary) " "VALUES (1001, 'Thad Beaumont', 65000)" 这个字符串怎么用QString 做出来
我这样做
str.append("INSERT INTO RecordsConsumption (data,time,money) ");
str.append("VALUES (");
str.append("'");
str.append(date.toString("yyyy-MM-dd"));
str.append("'");
str.append(",");
str.append("'");
str.append(time.toString("hh:mm:ss"));
str.append("'");
str.append(",");
str.append(money->text());
str.append(")");
if (!query->exec(str))
QMessageBox::critical(0, QObject::tr("测试插入数据"),inquire->lastError().text());
为什么不行呢? 提示有错误