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

// TODO: Add your control notification handler code here

CMarkup 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

{

sql="INSERT DELAYED INTO test.tabledgacase (";

for (j=0;j

{

sql=sql+field_name[i][j]+",";

}

sql=sql+field_name[i][j];

sql+=") VALUES (\"";

for(j=0;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("数据添加完成！");