关于excel文件导入数据库

瓦尔登湖

public static void read07() throws Exception
    {
        //创建输入流
        FileInputStream fis = new FileInputStream(new File("E:\\testFile.xlsx"));               
        //由输入流得到工作簿
        XSSFWorkbook workbook = new XSSFWorkbook(fis);
        //得到工作表
        int numberOfSheets = workbook.getNumberOfSheets();
        System.out.println(numberOfSheets);
        for (int i = 0; i < numberOfSheets; i++) {
                    Sheet sheet = workbook.getSheetAt(i);
                    for (int j = 1; j < sheet.getPhysicalNumberOfRows(); j++) { // 获取每行
                    XSSFRow row = (XSSFRow) sheet.getRow(j);
                    if(row!=null){
                    //List list = new ArrayList();
                            for (int k = 0; k < sheet.getRow(0).getPhysicalNumberOfCells(); k++) { // 获取每个单元格
                            Cell  cell = row.getCell(k);
                            cell.setCellType(1);  // 1 代表设置单元个类型为文本格式
                            //String material_number = cell.toString();
                           
                            System.out.println(cell);
                    }
            }
        workbook.close();
        fis.close();
    }
        }
    }
        public static void main(String[] args) throws Exception {
                read07();
        }


在后台运行main函数能运行成功!!!!   但是在前台调用basssend 调用该方法报错报错如下：
HTTP Status 500 - 执行Action：courseManage/uploadExcel/myUploadExcel失败，Action[courseManage/uploadExcel/myUploadExcel]执行失败，org/apache/xmlbeans/XmlObject

type Exception report

message 执行Action：courseManage/uploadExcel/myUploadExcel失败，Action[courseManage/uploadExcel/myUploadExcel]执行失败，org/apache/xmlbeans/XmlObject

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: 执行Action：courseManage/uploadExcel/myUploadExcel失败，Action[courseManage/uploadExcel/myUploadExcel]执行失败，org/apache/xmlbeans/XmlObject
        com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        com.justep.baas.servlet.BaasServlet.service(Unknown Source)

root cause

com.justep.baas.action.ActionException: Action[courseManage/uploadExcel/myUploadExcel]执行失败，org/apache/xmlbeans/XmlObject
        com.justep.baas.action.Engine.execAction(Unknown Source)
        com.justep.baas.action.Engine.execAction(Unknown Source)
        com.justep.baas.servlet.BaasServlet.execService(Unknown Source)
        com.justep.baas.servlet.BaasServlet.service(Unknown Source)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.41 logs.

jar包都导入了

瓦尔登湖

这谁什么原因哈   急待解决

liangyongfei

http://docs.wex5.com/wex5-studio-question-list-2015

这里拷贝了吗？
runtime\BaasServer\WEB-INF\lib

瓦尔登湖

没有导入进去,现在可以了!!!!