9月15日微服务架构周六-优快云博客

本文链接：https://blog.youkuaiyun.com/helloworld_1996/article/details/82719176

本文介绍了一个使用Spring MVC框架实现的用户管理控制器，包括用户列表展示和Excel文件导出的功能。通过与数据库交互获取用户信息，并利用ExcelUtils工具类将数据导出为Excel格式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.hao.controller;

import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.hao.dto.User;
import com.hao.service.IUserService;
import com.hao.util.ExcelUtils;

@Controller
public class UserController {

    @Autowired
    private IUserService iUserService;
    @RequestMapping("list")
    public String list(HttpServletRequest request){
        List<Map<String, Object>> uList = iUserService.findUserList();
        request.setAttribute("uList", uList);
        return "list";
    }

    @RequestMapping("toHere")
    public void toHere(HttpServletResponse response){
        List<User> userList = iUserService.findAllList();
        String [] columnNames = {"ID","姓名","性别","年龄","型号"};
        String [] columns = {"userid","username","sex","age","carname"};
        ExcelUtils.exportExcel(response, userList, columnNames, columns, "User信息", "导出信息");
    }

}