使用mybatis实现,文件使用的是csv文件
xml
<select id="loadTest">
LOAD DATA INFILE 'E:/load_test.csv' ignore into table newmedia_base.load_test fields
terminated by ',' enclosed by ""
</select>
dao
public void loadTest();
service
public void loadTest(){
accountDao.loadTest();
}
controller
@RequestMapping(value="loadTest", method = RequestMethod.GET, produces = "application/json;charset=UTF-8")
@ResponseBody
public ResponseData loadTest(HttpServletRequest request){
ResponseData responseData=new ResponseData();
try{
accountService.loadTest();
responseData.setMsg("成功");
responseData.setStatus(0);
} catch (Exception e) {
e.printStackTrace();
responseData.setStatus(1);
responseData.setMsg("失败");
}
return responseData;
}