做一个简单的出入库管理系统。

wuxusen

jishuang 发表于 2013-2-18 12:01
一个data的增删改只对主概念起作用，join中的不能，需要自己代码控制

管理大哥，你说的很模糊，我想知道一个明确的步骤，先谢谢你了，，

jishuang

join只能查询多个表中的数据，不能同时对多个表中的数据进行增删改
如果要修改join中关系表中的记录需要代码控制，用java写sql也可以在ui层定义data，通过data操作也可以

wuxusen

jishuang 发表于 2013-2-18 15:32
join只能查询多个表中的数据，不能同时对多个表中的数据进行增删改
如果要修改join中关系表中的记录需要代 ...

1. public class CRKGL {
   
2. 
   
3. 
   
4.         public static Table newAction_2(){
   
5.                 String mssql="select mc,sum(shul),sum(jiage),sum(heji) from (select mc,shul,jiage,heji from ruku union all select mc,-shul,-jiage,-heji from chuku from chuku) t0 group by mc";
   
6.                 HashMap<String,String> sqlMap=new HashMap<String,String>;
   
7.                 System.out.println(mssql);
   
8.                 sqlMap.put(DatabaseProduct.MSSQL.name(), mssql);
   
9.                 return SQL.select(sqlMap, null, "/CRKGL/CRKGL/data");       

复制代码

帮忙看下代码对不对，谢谢了，，，我运行的时候出现错误。。。这是什么原因嗯

zhaixin

把控制台的完整错误发一下

lsp121043

wuxusen 发表于 2013-2-18 13:39
给说说怎么做的，，想你学习学习。。。

问题到不大，可怎么说呢

wuxusen

wuxusen 发表于 2013-2-18 18:41
帮忙看下代码对不对，谢谢了，，，我运行的时候出现错误。。。这是什么原因嗯
...

1. 2013-02-19 08:34:25 invokeActions error！
   
2. com.justep.model.exception.ModelException: com.justep.model.exception.ModelException: process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
   
3.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
4.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
5.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
6.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
   
7.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
   
8.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
   
9.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   
10.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
11.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
12.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
13.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
14.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
15.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
16.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
17.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
18.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
19.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
20.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
21.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
22.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
23.         at java.lang.Thread.run(Thread.java:595)
    
24. Caused by: com.justep.model.exception.ModelException: process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
    
25.         at com.justep.util.Utils.checkNotNull(Unknown Source)
    
26.         at com.justep.model.impl.ActivityImpl.getAction(Unknown Source)
    
27.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
28.         ... 21 more
    
29. 2013-02-19 08:34:25 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
    
30. <action direct-execute="true" process="/CRKGL/CRKGL/process/HZB/hZBProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="newAction_0"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="variables"/></parameters></action>
    
31. com.justep.model.exception.ModelException: com.justep.model.exception.ModelException: process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
    
32.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
33.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
34.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
35.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
36.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
37.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
38.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
39.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
40.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
41.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
42.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
43.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
44.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
45.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
46.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
47.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
48.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
49.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
50.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
51.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
52.         at java.lang.Thread.run(Thread.java:595)
    
53. Caused by: com.justep.model.exception.ModelException: process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
    
54.         at com.justep.util.Utils.checkNotNull(Unknown Source)
    
55.         at com.justep.model.impl.ActivityImpl.getAction(Unknown Source)
    
56.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
57.         ... 21 more
    
58. [ERROR] 2013-02-19 08:34:25,184 com.justep.report.controller.DataController - 报表数据获取失败
    
59. process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
    
60. com.justep.report.exception.ReportServerException: 报表数据获取失败
    
61.         at com.justep.report.controller.DataController.execute(Unknown Source)
    
62.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
    
63.         at com.justep.report.controller.InitController.execute(Unknown Source)
    
64.         at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
    
65.         at com.justep.report.Servlet.a(Unknown Source)
    
66.         at com.justep.report.Servlet.doPost(Unknown Source)
    
67.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    
68.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
69.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
70.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
71.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
72.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
73.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
74.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
75.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
76.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
77.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
78.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
79.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
80.         at java.lang.Thread.run(Thread.java:595)
    
81. Caused by: com.justep.report.exception.ReportServerException: process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
    
82.         at com.justep.report.controller.DataController.a(Unknown Source)
    
83.         at com.justep.report.controller.DataController.a(Unknown Source)
    
84.         ... 20 more
    
85. Caused by: java.lang.Exception
    
86.         ... 22 more
    

复制代码

会的给看一下把，谢谢了

xwnabc

process(/CRKGL/CRKGL/process/HZB/hZBProcess), activity(mainActivity)中不存在action(newAction_0)不能为空!
你需要给process文件(/CRKGL/CRKGL/process/HZB/hZBProcess)的业务环节设置动作
设置以后
前台.w文件引用的动作才会具备权限
引用可以去参考基础教学视频。

崔个大气球

lsp121043 发表于 2013-2-18 12:33
我快做完了。

是啊，分享一下。怎么做的？

fig112000

这么好系统，三表联查，有点sql基础都应该的,不懂可以联系我：qq：157525639