获取xml文档中存储过程并执行(mysql)

来源:互联网 发布:车螺纹编程实例 编辑:程序博客网 时间:2024/05/18 10:16
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);

原创粉丝点击