xls to mysql ????

Following up on posts from @anuj_sharma, @javaAddict, @peter_budo and @jwenting: import is two steps—read the workbook and write to the DB. Read the uploaded file directly in a servlet (no disk save needed) and pass the InputStream to Apache POI. Use JDBC prepared statements with batch updates and a transaction for reliability. The snippet below is a minimal, practical example that shows how to create a POI Workbook from the uploaded InputStream and insert rows into MySQL.

@MultipartConfig
public class ExcelUploadServlet extends HttpServlet {
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        Part filePart = req.getPart("file"); // form field name
        try (InputStream is = filePart.getInputStream();
             Workbook wb = WorkbookFactory.create(is);
             Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPass)) {

            conn.setAutoCommit(false);
            String sql = "INSERT INTO marks (student_id,name,mark) VALUES (?,?,?)";
            try (PreparedStatement ps = conn.prepareStatement(sql)) {
                boolean header = true;
                Sheet sheet = wb.getSheetAt(0);
                for (Row row : sheet) {
                    if (header) { header = false; continue; } // skip header row
                    int id = (int) row.getCell(0).getNumericCellValue();
                    String name = row.getCell(1).getStringCellValue();
                    double mark = row.getCell(2).getNumericCellValue();
                    ps.setInt(1, id);
                    ps.setString(2, name);
                    ps.setDouble(3, mark);
                    ps.addBatch();
                }
                ps.executeBatch();
            }
            conn.commit();
        } catch (Exception e) {
            // rollback and proper error handling here
        }
    }
}

Notes and troubleshooting tips: use WorkbookFactory.create(InputStream) so both .xls and .xlsx work; for Servlet 2.x use Apache Commons FileUpload instead of @MultipartConfig; validate and coerce cell types (cells can be blank, strings, numbers, dates); wrap DB work in a transaction and roll back on error; for very large files avoid loading the whole workbook—use POI’s streaming/event APIs (XSSF event model or a streaming reader) to prevent OOM; if you can produce a CSV and have DB access, LOAD DATA INFILE will be much faster. As @jwenting noted, keep upload/processing in a servlet/back-end component rather than embedding logic in a JSP.