需求
Java读取XML文件内容存储到MySQL,这里仅用了dom的读取方法
分层结构
分为三层:controller、service、mapper
代码
controller层
package com.xmltomysql.controller;
import com.xmltomysql.mapper.XMLtoMySQLMapper;
import com.xmltomysql.service.XMLtoMySQLService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class XMLtoMySQLController {
@Autowired
XMLtoMySQLService xmLtoMySQLService;
@Autowired
XMLtoMySQLMapper mySQLMapper;
@RequestMapping("/insert")
public String readXML(){
if (xmLtoMySQLService.readXML()){
System.out.println("成功");
return "成功"; //return返回到页面上,如果定义成void方法则不返回
} else {
System.out.println("失败");
return "失败";
}
}
@RequestMapping("/select")
public List<Person> select(){
System.out.println(xmLtoMySQLService.select());
return xmLtoMySQLService.select();
}
}
service层
package com.xmltomysql.service;
import com.xmltomysql.mapper.XMLtoMySQLMapper;
import com.xmltomysql.po.Person;
import org.junit.jupiter.api.Test;
import org.