如何将Servlet接收的Excel文件首字段解析并存入数据库？

本文共计206个文字，预计阅读时间需要1分钟。

javaFileupload ApachePOI 包含在 com.carfi.product 包中；导入 java.io.File，java.io.FileInputStream，java.io.IOException，java.sql.Connection，java.sql.DriverManager，java.sql.ResultSet，java.util.ArrayList。

Fileupload+ApachePOI

package com.carfi.product; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Iterator; import java.util.List; import javax.servlet.ServletException; import javax.servlet.39.108.60.83:3306/device_info", "readeruser", "qwezxc"); PreparedStatement statement1 = (PreparedStatement) conn.prepareStatement(sql1); PreparedStatement statement2 = (PreparedStatement) conn.prepareStatement(sql2); statement1.execute(); ResultSet resultSet = statement2.executeQuery(); // 遍历结果集装载 while (resultSet.next()) { device_status status = new device_status(); status.setId(resultSet.getString("id")); status.setGnss_time(resultSet.getDate("gnss_time")); status.setLat(resultSet.getDouble("lat")); status.setLng(resultSet.getDouble("lng")); list.add(status); } conn.close(); request.setAttribute("statusList", list); request.getRequestDispatcher("main.jsp").forward(request, response); } catch (Exception e) { e.printStackTrace(); } } public void init() throws ServletException { File uploadFile = new File(uploadPath); if (!uploadFile.exists()) { uploadFile.mkdirs(); } File tempPathFile = new File(tempPath); if (!tempPathFile.exists()) { tempPathFile.mkdirs(); } } }