关于数据库的问题 帮帮忙 我新手

strConnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
strConnstr += "info.mdb;Mode=ReadWrite|Share Deny None;Persist Security Info=False";

this->ADOConnection1->ConnectionString = strConnstr;
if(!this->ADOConnection1->Connected)
{
this->ADOConnection1->Open();
}
this->ADODataSet1->ConnectionString = strConnstr;

this->ADODataSet1->CommandText = "Insert into etitle(user,password,ip) Values(username,password,ip)";

this->ADOCommand1->Execute();

里边的username password ip 都是字符串类型 有什么问题啊

"Insert into etitle(user,password,ip) Values(username,password,ip)"

里边的username password ip 作为变量的话就应该这样

"Insert into etitle(user,password,ip) Values('"+username+"','"+password+"','"+ip+"')"

字符串类型的在数据库操作的时候要用单引号引起来。

Insert into etitle(user,password,ip) Values(username,password,ip)

改成

Insert into etitle([user],[password],[ip]) Values(username,password,ip)";