代码帮忙

木夕筱梦

   这里我传送了w文件和相关要求，请帮忙解决

jishuang

参考如下的，拍照后给img显示图片，点上传以附件组件的字段格式保存的相关的字段中，在文档中心也可以查看到， mainActivity.w (1.76 KB, 下载次数: 361)

2014-7-22 14:48 上传

点击文件名下载附件 mainActivity.js (2.62 KB, 下载次数: 507)

2014-9-11 15:48 上传

点击文件名下载附件
保存后提交到文档中心是通过action实现的，action对应的java代码具体如下

1. public static void insertDocName(String fFJ) throws Exception {
   
2.                 JSONArray ja = new JSONArray(fFJ);
   
3.                 String skind = "image/jpeg";
   
4.                 String sDocDisplayPath = "文档中心";
   
5.                 String sCreatorDeptName = "";
   
6.                 String sCreatorFID = ContextHelper.getPersonMember().getFID();
   
7.                 String sCreatorName = ContextHelper.getPersonMember().getName();
   
8.                 if (ContextHelper.getPersonMember().getDept() != null) {
   
9.                         sCreatorDeptName = ContextHelper.getPersonMember().getDept().getName();
   
10.                 }
    
11.                 for (int i = 0; i < ja.length(); i++) {
    
12.                         JSONObject jsonObject = ja.getJSONObject(i);
    
13.                         String sID = jsonObject.getString("docID");
    
14.                         String sdocName = jsonObject.getString("docName");
    
15.                         Float ssize = Float.valueOf(jsonObject.getString("size"));
    
16.                         String sdocPath = jsonObject.getString("docPath");                        
    
17.                         String dateText = jsonObject.getString("time");
    
18.                         String sCreateTime = dateText.replace("T", " ").substring(0, 19);
    
19.                         String sfileID = jsonObject.getString("fileID");               
    
20.                         String sql = "insert into SA_DOCNODE(sID,sParentid,sdocName,ssize,skind,sdocpath,sDocDisplayPath,sCreatorFID," +                        
    
21.                                         "sCreatorName,sCreatorDeptName,sCreateTime,sFileID,sDocLiveVersionID,sFlag,version," +
    
22.                                         "sLastWriterFID,sLastWriterName,sLastWriterDeptName,sLastWriteTime)"
    
23.                                         + "values('"+ sID+ "','defaultDocNameSpace','"+ sdocName+ "',"+ ssize+ ",'"+ skind+ "','"+ sdocPath+ "','"+ sDocDisplayPath + "','" + sCreatorFID + "'," +
    
24.                                                   "'" + sCreatorName + "','" + sCreatorDeptName + "',to_date('"+sCreateTime+"','yyyy-mm-dd hh24:mi:ss'),'"+sfileID+"',1,1,0," +
    
25.                                                         "'" + sCreatorFID + "','" + sCreatorName + "','" + sCreatorDeptName + "',to_date('"+sCreateTime+"','yyyy-mm-dd hh24:mi:ss'))";
    
26. 
    
27.                         HashMap<String, String> sqlMap = new HashMap<String, String>();
    
28.                         sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
    
29.                         SQL.executeUpdate(sqlMap, null, "/system/data");
    
30.                         createVersionDoc(sID,sdocName);
    
31.                 }
    
32.         }
    
33. 
    
34.         public static void createVersionDoc(String docID,String docName) throws UnsupportedEncodingException, DocumentException, Exception{               
    
35.                  Docs docs = new Docs();
    
36.                  Doc doc = docs.query(null, "/defaultDocNameSpace", null, null, null).get(docID);
    
37.                  File outPutFile =new File("c:/"+docName);
    
38.                  doc.download(new FileOutputStream(outPutFile));
    
39.                  DocUtils.lock(docID);
    
40.                  doc.setsDocName("手机拍照"+docName);
    
41.                  doc.upload(new File("c:/"+docName));
    
42.                  docs.createVersion();      
    
43.                  outPutFile.delete();
    
44.         }

复制代码

木夕筱梦

jishuang 发表于 2014-7-22 14:39
参考如下的，拍照后给img显示图片，点上传以附件组件的字段格式保存的相关的字段中，在文档中心也可以查看 ...

您好，为什么上传时是{‘code’ ."IUSTEP323004","message":"保存失败"{\“message\":\"执行KSQL出错，KSQL：INSERT INTO GO_CSZX GO_CSZX(GO_CSZX,GO_CSZX.version,GO_CSZX.fCode,GO_"}

fpj

木夕筱梦 发表于 2014-7-22 16:42
您好，为什么上传时是{‘code’ ."IUSTEP323004","message":"保存失败"{\“message\":\"执行KSQL出错，KS ...

贴一下详细TOMCAT信息看一下。

木夕筱梦

2014-07-22 17:21:49 开始-中间文件生成缓存文件: /mobileUI/goodsinfo/tardemo/process/resultquery/mainActivity.w
2014-07-22 17:21:49 结束-中间文件生成缓存文件: /mobileUI/goodsinfo/tardemo/process/resultquery/mainActivity.w
2014-07-22 17:21:49 [JVM]start...5C67948BC86149F8B6EE7AD8A07974DC, process: /goodsinfo/tardemo/process/resultquery/resultqueryProcess, activity: mainActivity, action: getSysParamsAction
2014-07-22 17:21:49 [JVM]end.....5C67948BC86149F8B6EE7AD8A07974DC, process: /goodsinfo/tardemo/process/resultquery/resultqueryProcess, activity: mainActivity, action: getSysParamsAction, operator: PSN01, system, total: 1972MB, free: 746MB, use: 1225MB, leak free: 0MB, leak use: 0MB
2014-07-22 17:21:50 [JVM]start...A2E41A4A61E84BC584695F1A9B0494F9, process: /goodsinfo/tardemo/process/resultquery/resultqueryProcess, activity: mainActivity, action: createGO_CSZXAction
2014-07-22 17:21:50 [JVM]end.....A2E41A4A61E84BC584695F1A9B0494F9, process: /goodsinfo/tardemo/process/resultquery/resultqueryProcess, activity: mainActivity, action: createGO_CSZXAction, operator: PSN01, system, total: 1972MB, free: 746MB, use: 1225MB, leak free: 0MB, leak use: 0MB
2014-07-22 17:22:02 [JVM]start...AA3DA11963484241958AB5D697BC952B, process: /SA/doc/system/systemProcess, activity: mainActivity, action: queryNoPermissionHostAction
2014-07-22 17:22:02 [JVM]end.....AA3DA11963484241958AB5D697BC952B, process: /SA/doc/system/systemProcess, activity: mainActivity, action: queryNoPermissionHostAction, operator: PSN01, system, total: 1972MB, free: 747MB, use: 1225MB, leak free: 0MB, leak use: 0MB
2014-07-22 17:22:15 [JVM]start...8895B8CF10CA4798BA8C1E0D67470890, process: /goodsinfo/tardemo/process/resultquery/resultqueryProcess, activity: mainActivity, action: saveGO_CSZXAction
2014-07-22 17:22:16 action:<?xml version="1.0" encoding="UTF-8"?>
<actions><action content-type="application/json" accept="application/json, text/javascript, */*"><![CDATA[{"process":"/goodsinfo/tardemo/process/resultquery/resultqueryProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"saveGO_CSZXAction","parameters":{"table":{"@type":"table","userdata":{"relationTypes":"Integer,Text,String,String","relations":"GO_CSZX.version,GO_CSZX.fCode,GO_CSZX.fName,GO_CSZX.fFJ","model":"/goodsinfo/tardemo/data","updateMode":"whereVersion","idColumnName":"GO_CSZX","idColumnType":"String","idColumnDefine":"GO_CSZX","conceptAlias":"GO_CSZX","relationAlias":"version,fCode,fName,fFJ"},"rows":[{"fName":{"changed":"1","value":"167-DOC.jpg","originalValue":null},"fCode":{"changed":"1","value":"001","originalValue":null},"fFJ":{"changed":"1","value":"[{\"docID\":\"C63C60EA45300001ABBB1CBC3092152A\",\"docName\":\"167-DOC.jpg\",\"size\":\"720311\",\"fileID\":\"167-DOC\",\"docPath\":\"/defaultDocNameSpace\",\"time\":\"2014-07-22T17:22:10.000Z\"}]","originalValue":null},"version":{"changed":"1","value":0,"originalValue":null},"userdata":{"recordState":"new","id":{"changed":"0","value":"8719892109B4475D84C78D7921C6FA3D","originalValue":null}},"rows":[]}]}},"translateParameter":null}]]></action></actions>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO GO_CSZX GO_CSZX(GO_CSZX, GO_CSZX.version, GO_CSZX.fCode, GO_CSZX.fName, GO_CSZX.fFJ) VALUES (:GO_CSZX, :version, :fCode, :fName, :fFJ)
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.impl.TableImpl.save(Unknown Source)
        at com.justep.system.data.BizData.save(Unknown Source)
        at BizProcedure.save(BizProcedure.java:18)
        ... 26 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO GO_CSZX (GO_CSZX.fID, GO_CSZX.VERSION, GO_CSZX.FCODE, GO_CSZX.FNAME, GO_CSZX.FFJ) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ), binds: [8719892109B4475D84C78D7921C6FA3D, 0, 001, 167-DOC.jpg, [{"docID":"C63C60EA45300001ABBB1CBC3092152A","docName":"167-DOC.jpg","size":"720311","fileID":"167-DOC","docPath":"/defaultDocNameSpace","time":"2014-07-22T17:22:10.000Z"}]]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 35 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fFJ' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 36 more

我把2楼的代码放入自定义的action后，设为源码路径后，发现有挺多错，试着改了改，没改对

jishuang

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'fFJ' at row 1
数据库中字段长度不够

dsrc所在的code目录的model.config.xml引用/SA/doc/logic/code

木夕筱梦

还是哪里出问题了。调用失败。2014-07-23 09:44:54 UnsupportedEncodingExceptionjava.lang.NoClassDefFoundError: UnsupportedEncodingException
        at java.lang.Class.getDeclaredMethods0(Native Method)
        at java.lang.Class.privateGetDeclaredMethods(Class.java:2395)
        at java.lang.Class.privateGetPublicMethods(Class.java:2519)
        at java.lang.Class.getMethods(Class.java:1406)
        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.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.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:595)

jishuang

点击红叉，根据提示导入不同的包啊

木夕筱梦

jishuang 发表于 2014-7-23 10:11
点击红叉，根据提示导入不同的包啊

红叉现在已经没了，一开始弄错了； 现在提示Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150037; 提示: 没有找到与当前数据库"MYSQL"匹配的SQL语句        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.util.Utils.check(Unknown Source)
        at com.justep.system.data.SQL.executeUpdate(Unknown Source)
        at com.justep.system.data.SQL.executeUpdate(Unknown Source)
        at Tardemo.insertDocName(Tardemo.java:52)
        ... 26 more

jishuang

2楼发的这个是oracle的自己改为，mysql的啊
String sql = "insert into SA_DOCNODE(sID,sParentid,sdocName,ssize,skind,sdocpath,sDocDisplayPath,sCreatorFID," +                        

                                        "sCreatorName,sCreatorDeptName,sCreateTime,sFileID,sDocLiveVersionID,sFlag,version," +

                                        "sLastWriterFID,sLastWriterName,sLastWriterDeptName,sLastWriteTime)"

                                        + "values('"+ sID+ "','defaultDocNameSpace','"+ sdocName+ "',"+ ssize+ ",'"+ skind+ "','"+ sdocPath+ "','"+ sDocDisplayPath + "','" + sCreatorFID + "'," +

                                                  "'" + sCreatorName + "','" + sCreatorDeptName + "',to_date('"+sCreateTime+"','yyyy-mm-dd hh24:mi:ss'),'"+sfileID+"',1,1,0," +

                                                        "'" + sCreatorFID + "','" + sCreatorName + "','" + sCreatorDeptName + "',to_date('"+sCreateTime+"','yyyy-mm-dd hh24:mi:ss'))";

                        HashMap<String, String> sqlMap = new HashMap<String, String>();

                       sqlMap.put(DatabaseProduct.ORACLE.name(), sql);