java servlet 导入导出excel

最新推荐文章于 2023-05-17 11:10:01 发布

chengshizhen

最新推荐文章于 2023-05-17 11:10:01 发布

阅读量2k

点赞数 1

分类专栏： java

本文链接：https://blog.csdn.net/chengshizhen/article/details/78222980

版权

该Java Servlet实现检查上传文件是否为.xls或.xlsx格式，然后读取Excel内容并更新数据库。通过WorkbookFactory创建Workbook对象，遍历工作表并根据单元格数据执行数据库操作。

摘要由CSDN通过智能技术生成

/**
* 导出excel
*/
@WebServlet("/ExportEnrollExamine")
public class ExportAchieveExamineServlet extends HttpServlet {
   private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public ExportAchieveExamineServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

   /**
   * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
   */
   protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       // TODO Auto-generated method stub
   }

   /**
   * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
   */
   protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        String asd = request.getParameter("jsonData");
        JSONObject jsonData = JSONObject.fromObject(request.getParameter("jsonData"));
        String sqlString = BasicExamineeInfo.queryAchievementBycondition(jsonData.getString("examId"),
                                                                         jsonData.getString("name"),
                                                                         jsonData.getString("IDcard"),
                                                                         jsonData.getString("release_begin_date"),
                                                                         jsonData.getString("release_end_date"),
                                                                         jsonData.getString("apply_operate_type"),
                                                                         jsonData.getString("phone"),
                                                                         jsonData.getString("examinee_exam_result"),"","");
        LinkedList<HashMap<String,Object>> list = AccessDataBaseUtil.getDataTableListKeyValue(sqlString,
                                                                    "name;IDcard;"+
                                                                    "enrollTime;apply_operate_type;phone;examinee_exam_result");

        String sqlStringTitle =BasicExaminationInfo.selectExamInfoById(jsonData.getString("examId"));
        LinkedList<HashMap<String,Object>> titleList = AccessDataBaseUtil.getDataTableListKeyValue(sqlS