mysql读取本地xml文件

从服务器 本地读取java上传的xml文件，存到数据库的表中，利用存储过程去实现后续操作

一、xml文件代码

<?xml version="1.0" standalone="yes"?>
<RECORDS>
<RECORD>
<id>1</id>
<username>222</username>
<job>aa</job>
<age>44</age>
<hometown>333</hometown>
</RECORD>
<RECORD>
<id>2</id>
<username>3444</username>
<job>SW</job>
<age>30</age>
<hometown>wuhan</hometown>
</RECORD>
<RECORD>
<id>3</id>
<username>shihuc</username>
<job>SW</job>
<age>30</age>
<hometown>wuhan</hometown>
</RECORD>
<RECORD>
<id>4</id>
<username>shihuc</username>
<job>SW</job>
<age>30</age>
<hometown>wuhan</hometown>
</RECORD>
<RECORD>
<id>5</id>
<username>shihuc</username>
<job>SW</job>
<age>30</age>
<hometown>wuhan</hometown>
</RECORD>
<RECORD>
<id>6</id>
<username>shihuc</username>
<job>SW</job>
<age>30</age>
<hometown>wuhan</hometown>
</RECORD>
</RECORDS>

二、文件的位置

三、新建数据表

USE test;

CREATE TABLE person (
    person_id INT NOT NULL PRIMARY KEY,
    fname VARCHAR(40) NULL,
    lname VARCHAR(40) NULL,
    created TIMESTAMP
);

四、执行sql语句

LOAD XML INFILE 'user.xml'
INTO TABLE user
ROWS IDENTIFIED BY '<RECORD>';

五、结果