控制层
/***
* 导入员工薪资
* @return
*/
@RequestMapping("/uploadEmpSal")
public String uploadEmpSal(){
String file = "C:\\Users\\Administrator\\Desktop\\salariesTable.xlsx";
ImportParams params = new ImportParams();
params.setHeadRows(1);
List<EmpSalaries> list = ExcelImportUtil.importExcel(new File(file),
EmpSalaries.class, params);
//输出导入信息到控制台,执行导入业务
empSalService.addEmpSal(list);
//省略导入业务,根据自身项目需要进行调整
return "导入成功";
}
Mapper层
@Mapper
public interface SalMapper {
void addEmpSal(List<EmpSalaries> list);
}
mybatis的sql语句
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="cn.qqcn.emp.mapper.SalMapper">
<insert id="addEmpSal" parameterType="java.util.List">
insert into emp_salaries values
<foreach collection="list" item="model" index="index" separator=",">
(#{model.empId},#{model.sal},#{model.bonus},#{model.subsidy},#{model.empName})
</foreach>
</insert>
</mapper