利用poi将数据库数据导出excel

spring+springmvc+mybatis

1.控制层controller

@Controller 
@RequestMapping("/user") 
public class UserController { 

@Autowired 
private UserService userService; 
/** 
* 用于导出excel的查询结果 
* @param queryJson 
* @return 
*/ 
@RequestMapping("/export") 
public void export(HttpServletRequest request, HttpServletResponse response, 
@RequestParam(value = "queryJson") String queryJson) {


User user = JSON.parseObject(queryJson, User.class); 
List<User> userlList = userService.getUserForExcel(user); 
ExportExcel<User> ee= new ExportExcel<User>(); 
String[] headers = { "序号", "姓名", "性别", "年龄" }; 
String fileName = "用户信息表"; 
ee.exportExcel(headers,userlList,fileName,response); 
} 
} 

2.