xml.Load("sql.xml");
xml.ResetMainPos();
int i=0;
while(xml.FindChildElem("sqls"))
{
xml.IntoElem();
xml.FindChildElem("sql");
strsql[i]=xml.GetChildData();
i++;
xml.OutOfElem();
}
count=i;
dat=mysql_init(NULL);
mysql_real_connect(dat,svr,usr,pwd,db,0,NULL,0);
mysql_query(dat,"set names gbk");
// if(mysql_real_query(dat,strsql,(unsigned long)strlen(strsql)))
// AfxMessageBox("创建表成功!");
int flag=0;
for (i=0;i<count;i++)
{
int tmp=mysql_real_query(dat,strsql[i],(unsigned long)strlen(strsql[i]));
flag+=tmp;
}
if (count==flag)
{
AfxMessageBox("创建表成功!");
}
mysql_close(dat);
获取xml文档中存储过程并执行(mysql)
最新推荐文章于 2022-08-24 10:46:18 发布