从xml文档中读取数据并插入mysql数据库中

// TODO: Add your control notification handler code hereCMarkup xml;xml.Load("色谱案例表.xml");xml.IntoElem();int i=0,j=0;for (i=0;xml.FindChildElem();i++){xml.IntoElem();for (int j=0;xml.FindChildElem();j++){field_name[i][j]=xml.GetChildTagName();field_value[i][j]=xml.GetChildData();}column=j;xml.OutOfElem();}row=i;for (i=0;i<row;i++){sql="INSERT DELAYED INTO test.tabledgacase (";for (j=0;j<column-1;j++){sql=sql+field_name[i][j]+",";}sql=sql+field_name[i][j];sql+=") VALUES (\"";for(j=0;j<column-1;j++){sql=sql+field_value[i][j]+"\",\"";}sql=sql+field_value[i][j];sql+="\")";mysql=mysql_init(NULL);mysql_real_connect(mysql,svr,usr,pwd,db,0,NULL,0);mysql_query(mysql,"set names gbk");int a=mysql_real_query(mysql,sql,(unsigned long)strlen(sql));mysql_close(mysql);}AfxMessageBox("数据添加完成！");