spring - java 根据上传的excel文件生成Oracle数据库中的表

Question

    /**
     * 上传excel文件
     */
    public void uploadExcel(HttpServletRequest request,HttpServletResponse response){
        try {
            // upload file
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    /**
     * 根据excel数据得到query查询结果
     * @return
     */
    public List<?> getQueryList(String fileName,String sheetName){
        
        return null;
    }

    /**
     * 创建临时表数据
     * @return
     */
    public String createNewData(){
        return  null;
    }

Answer 1

Java can use poi to parse excel

Answer 2

You can also use jxl