在程序中组合SQL语句时,输入字符串类型要加单引号,否则当输入字符为非数字类型时,会SQL语句执行失败
//例子
std::string sSql;
std::string sTypeChar = "abcdef";
std::string sTypeNumber = "123456";
sprintf(sSql, "SELECT * FROM table WHERE type = %s;", sTypeChar);
sprintf(sSql, "SELECT * FROM table WHERE type = %s;", sTypeNumber);
sprintf(sSql, "SELECT * FROM table WHERE type = '%s';, sTypeChar);
sprintf(sSql, "SELECT * FROM table WHERE type = '%s';, sTypeNumber);