Java读取XML文件内容存储到MySQL

package com.xmltomysql.service; import com.xmltomysql.mapper.XMLtoMySQLMapper; import com.xmltomysql.po.Person; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.w3c.dom.Document; import org.w3c.dom.Element; import org.w3c.dom.Node; import org.w3c.dom.NodeList; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import java.util.List; /** * @version 1.0 */ @Service public class XMLtoMySQLService { @Autowired XMLtoMySQLMapper xmLtoMySQLMapper; //读取xml文件并添加到mysql @Test public Boolean readXML(){ //List<Person> persons = new ArrayList<>(); //文件存放路径 String filePath = "D:\\idea\\information.XML"; try { // 创建DocumentBuilder对象--解析工厂 DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance(); //解析器 DocumentBuilder builder = factory.newDocumentBuilder(); // 将XML文件加载到Document对象中 Document document = builder.parse(filePath); // 获取根元素 Element root = document.getDocumentElement(); // 获取'person'元素的列表 NodeList personList = root.getElementsByTagName("person"); // 遍历'person'元素并提取数据 for (int i = 0; i < personList.getLength(); i++) { Node personNode = personList.item(i); //判断当前的 personNode是否为一个节点 if (personNode.getNodeType() == Node.ELEMENT_NODE) { //将personNode节点强制转换为Element类，使用其类中方法，personElement对象来访问该元素节点的名称、属性、子节点等 Element personElement = (Element) personNode; Person person = new Person(); // 获取'name'元素 //getElementsByTagName()返回的是一个集合，.item(0)表示返回第一个元素 Element nameElement = (Element) personElement.getElementsByTagName("name").item(0); String name = nameElement.getTextContent(); //获取nameElement元素节点的文本内容 person.setName(name); // 获取'gender'元素 Element genderElement = (Element) personElement.getElementsByTagName("gender").item(0); String gender = genderElement.getTextContent(); person.setGender( Integer.parseInt(gender) ); //Integer.parseInt()将string转换为Integer // 获取'address'元素 Element addressElement = (Element) personElement.getElementsByTagName("address").item(0); String address = addressElement.getTextContent(); person.setAddress(address); // 获取'phoneNumber'元素 Element phoneNumberElement = (Element) personElement.getElementsByTagName("phoneNumber").item(0); String phoneNumber = phoneNumberElement.getTextContent(); person.setPhoneNumber(phoneNumber); //给集合添加内容 //persons.add(person); System.out.println(person); xmLtoMySQLMapper.insert(person); } } } catch (Exception e) { e.printStackTrace(); } return true; } //查询mysql public List<Person> select(){ return xmLtoMySQLMapper.select(); } }