ACESS+ADO,添加记录的问题
CString id,name,sexual,age,tel,address,specialty,classs;
cout<<"请输入您要增加的学生的学号:"<<endl;
scanf("%s",id);
cout<<"请输入姓名:"<<endl;
scanf("%s",name);
cout<<"请输入性别:"<<endl;
scanf("%s",sexual);
cout<<"请输入年龄:"<<endl;
scanf("%s",age);
cout<<"请输入电话:"<<endl;
scanf("%s",tel);
cout<<"请输入地址:"<<endl;
scanf("%s",address);
cout<<"请输入专业:"<<endl;
scanf("%s",specialty);
cout<<"请输入班级:"<<endl;
scanf("%s",classs);
try{
CString strSQL;
strSQL.Format("insert into student(id,name,sexual,age,tel,address,specialty,classs) values('%s','%s','%s','%s','%s','%s','%s','%s')",id,name,sexual,age,tel,address,specialty,classs);
m_connection->Execute((_bstr_t)strSQL,NULL,adCmdText);
cout<<"添加成功!!!!!!!!!"<<endl;
}
catch(_com_error *e) //捕获异常
{
cout<<e->ErrorMessage()<<endl; //如有错误 ,将错误输出
}
能够插入数据库,但是存进去的全是和classs相同的记录,将变量存入数组再插入数据库,仍然一样,请高手赐教!!!