mysql-insert into语句可执行不报错就是添不进去。请大神帮忙解答

程序员文章站 2022-04-11 20:43:21

...

mysqlmfc数据库

MYSQL m_sqlCon;
mysql_init(&m_sqlCon);
if(!mysql_real_connect(&m_sqlCon,"localhost","root","0412qwer","xscj",3306,NULL,0))
{AfxMessageBox(_T("数据库连接失败"));}
else
{AfxMessageBox(_T("数据库连接成功"));}

 string sqlstr; string str1("sas"); string str2("dfsd"); int result; sqlstr="insert into xs(XH,XM) values('"+str1+"','"+str2+"')"; result=mysql_query(&m_sqlCon,sqlstr.c_str()); if(0!=result)   mysql_close(&m_sqlCon);