如何将输入的变量添加到查询字符串中？

[亚细亚]

string sql;
string name;
cin>>name;
sql="select * from user ";
想让变量name作为sql的一个where查询条件，请问如何处理？

[yellowhwb]

string好像是可以用＋的吧！！
sql += "where name='"+ name+"'"

[星羽]

#include "iostream"
#include "string"
using namespace std;

int main()
{
    string sql; 
    string name; 
    cin>>name; 
    sql = string("select * from user = \"") + name + string("\"");

    cout<<sql<<endl;
    return 0;
}

[xiaoyisnail]

#include <iostream>
#include <stdio.h>
#include <string>
using namespace std;

int main()
{
    char sql[128] = {0};
	string name;
	cin>>name;
	sprintf(sql, "select * from user %s", name.c_str());

	cout<<sql<<endl;
	return 0;
}

[亚细亚]

sprintf(sql, "select * from user where loadName='%s'", name.c_str());
这样好像有错误.

[xiaoyisnail]

[Quote=引用 4 楼 yaxiya 的回复:]
sprintf(sql, "select * from user where loadName='%s'", name.c_str());
这样好像有错误.
[/Quote]

没有啊

#include <iostream>
#include <stdio.h>
#include <string>
using namespace std;

int main()
{
    char sql[128] = {0};
	string name;
	cout<<"please enter the name."<<endl;
	cin>>name;
	sprintf(sql, "select * from user where loadName='%s'", name.c_str()); 

	cout<<sql<<endl;
	return 0;
}

运行结果：

please enter the name.
abc
select * from user where loadName='abc'
Press any key to continue

[waizqfor]

[Quote=引用 2 楼 Chiyer 的回复:]
C/C++ code#include "iostream"
#include "string"
using namespace std;

int main()
{
string sql;
string name;
cin>>name;
sql = string("select * from user = \"") + name + string("\"");

cout<<sql<<endl;
return 0;
}
[/Quote]
UP

[亚细亚]

[Quote=引用 2 楼 Chiyer 的回复:]
C/C++ code#include"iostream"#include"string"usingnamespacestd;intmain()
{stringsql;stringname;
cin>>name;
sql=string("select * from user = \"")+name+string("\"");

cout<<sql<<endl;return0;
}
[/Quote]
ok,结贴！