上傳一張excel到多個資料表(Table)

594狂

那這個又是甚麼原因?

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151044; 提示: 编译模块"/dfs/dfs1/process/upload_excel"中的类"Upload_excelProcess"出错
warning: [options] bootstrap class path not set in conjunction with -source 1.5
warning: [options] source value 1.5 is obsolete and will be removed in a future release
warning: [options] target value 1.5 is obsolete and will be removed in a future release
warning: [options] To suppress warnings about obsolete options, use -Xlint:-options.
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:16: error: cannot find symbol
                ImportConfig importConfig = (ImportConfig) ModelUtils.getRequestContext().getActionContext().getParameter("config");
                ^
  symbol:   class ImportConfig
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:16: error: cannot find symbol
                ImportConfig importConfig = (ImportConfig) ModelUtils.getRequestContext().getActionContext().getParameter("config");
                                             ^
  symbol:   class ImportConfig
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:17: error: cannot find symbol
                List<ImportRelationConfig> list = importConfig.getExtendConfig("option");// 这的参数是import.mapping.xml中要自己要导入表的的节点名称
                ^
  symbol:   class List
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:17: error: cannot find symbol
                List<ImportRelationConfig> list = importConfig.getExtendConfig("option");// 这的参数是import.mapping.xml中要自己要导入表的的节点名称
                     ^
  symbol:   class ImportRelationConfig
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:18: error: cannot find symbol
                Sheet sheet = workBook.getSheetAt(1);// 獲得sheet2中的數據
                ^
  symbol:   class Sheet
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:18: error: cannot find symbol
                Sheet sheet = workBook.getSheetAt(1);// 獲得sheet2中的數據
                              ^
  symbol:   variable workBook
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:19: error: cannot find symbol
                Iterator<Row> it = sheet.iterator();
                ^
  symbol:   class Iterator
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:20: error: cannot find symbol
                Map map = new HashMap();
                ^
  symbol:   class Map
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:20: error: cannot find symbol
                Map map = new HashMap();
                              ^
  symbol:   class HashMap
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:21: error: cannot find symbol
                List listName = new ArrayList();
                ^
  symbol:   class List
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:21: error: cannot find symbol
                List listName = new ArrayList();
                                    ^
  symbol:   class ArrayList
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:22: error: cannot find symbol
                List listValue = new ArrayList();
                ^
  symbol:   class List
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:22: error: cannot find symbol
                List listValue = new ArrayList();
                                     ^
  symbol:   class ArrayList
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:24: error: cannot find symbol
                Cell cell = null;
                ^
  symbol:   class Cell
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:25: error: cannot find symbol
                for (ImportRelationConfig irc : list) {
                     ^
  symbol:   class ImportRelationConfig
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:30: error: cannot find symbol
                        Iterator<Cell> ce = row.cellIterator();
                        ^
  symbol:   class Iterator
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:30: error: cannot find symbol
                        Iterator<Cell> ce = row.cellIterator();
                                 ^
  symbol:   class Cell
  location: class Upload_excelProcess
C:\bex5_36\model\BIZ\dfs\dfs1\process\upload_excel\dsrc\Upload_excelProcess.java:30: error: cannot find symbol
                        Iterator<Cell> ce = row.cellIterator();
                                               ^
  symbol:   method cellIterator()
  location: variable row of type Row
18 errors
4 warnings

        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)
        at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)
        at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:121)
        at Excel.importExcel(Excel.java:88)
        ... 27 more

594狂

• 把process的java文件設為源瑪路徑後看到如下圖，java編譯有錯,如何得知到底要import哪些類?
• 如果已經把sa/excel/logic/code添加為建構路徑了後,lib資料夾卻還留在下面是否是正常的?
  

jishuang

根据错误提示在java中把相关的类import进去

594狂

嘗試著自己import類進去 但是有很多選項可以選 不確定自己導的是否是正確的
然而嘗試多次，不管怎麼導入都無法讓所有紅線消失!

jishuang

看看平台的excel相关的java文件中导入的是哪些

594狂

全部都導入了
但是workbook依舊有紅線
而且也沒有在其他的class中看到有共用的workbook阿

jishuang

workBook变量怎么定义的？

594狂

jishuang 发表于 2016-12-14 13:47
workBook变量怎么定义的？

完全按照你給的連結照抄的
http://bbs.wex5.com/forum.php?mod=viewthread&tid=49351
也可以配置一个概念然后自己在事件中把其他表对应的列直接用sql或者ksql的方式插入到数据库

jishuang

链接中有Workbook workBook = (Workbook)ModelUtils.getRequestContext().getActionContext().getParameter("excel");
你的代码中没有啊

594狂

jishuang 发表于 2016-12-14 14:40
链接中有Workbook workBook = (Workbook)ModelUtils.getRequestContext().getActionContext().getParameter ...

1.
我是用連結裡的"第二種方法" 裡面是沒有寫的 請看下圖

2.照你說的,我剛剛把Workbook workBook = (Workbook)ModelUtils.getRequestContext().getActionContext().getParameter("excel");加進去了
結果還是不行啊在點擊"確認"後,出現下列錯誤

java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeAction(Native Method)
        at com.justep.system.action.Engine.invokeAction(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.invokeAction(Unknown Source)
        at com.justep.system.action.ActionUtils.invokeAction(Unknown Source)
        at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:121)
        at Excel.importExcel(Excel.java:88)
        ... 27 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP151058; 提示: 模块"/excel"不存在
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadExtAttribute(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelLoader.loadModel(Unknown Source)
        at com.justep.model.impl.ModelImpl.getModel(Unknown Source)
        at com.justep.model.impl.UtilImplementInstance.getModel(Unknown Source)
        at com.justep.model.ModelUtils.getModel(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at Upload_excelProcess.upload_excelProcessAfterImportExcelBeforeAction(Upload_excelProcess.java:80)
        ... 37 more

3.
您直接幫我看看這份java文件哪裡有錯需要修改吧