手机拍照上传

jishuang

类型转换的错误就是java的标准错误，把getValue的转换成String啊


/BIZ/demo/actions/logic/code/dsrc/Actions.java中的都是自定义的action，我前面发的案例中的action就是这里面定义

tlkj

您好这是自定义action中写的代码，输出uploadAddr的时候只能显示一条，不进行遍历，确定sql没有问题输出table.size()
也没有问题，代码附上，您帮着给看看是怎么回事儿。
public static Table show()throws ParseException, SQLException{
                String sql = "select uploadAddr from pic";
                HashMap<String,String> sqlMap = new HashMap<String,String>();
                sqlMap.put(SQL.DEFAULT_DB_NAME,sql);
                Table table = SQL.select(sqlMap,null,"/qx/qx/data");
               
                String uploadAddr = "";
                Iterator<Row> addrRows =  table.iterator();
                System.out.println(table.size());               
                while(addrRows.hasNext()){
                        Row addrRow = addrRows.next();
                       
                        uploadAddr =  (String) addrRow.getValue("uploadAddr");
                        //System.out.println(uploadAddr);
                        break;
                }               
                return table;

jishuang

uploadAddr =  (String) addrRow.getValue("uploadAddr");
你的这个就不是拼接，只是取了一条数据赋值了

java中字符串的拼接写看看基础吧

tlkj

这跟拼接不拼接有关系吗？之前就这样写过，在java里面这样写即使不拼接最起码得把里面的这些数据都能查询出来吧。跟基础什么关系？

jishuang

break;都已经跳出数循环了

把这个去掉

tlkj

您好把字符串已经拼接成功了，是不是还得需要封装到table里面？请问下怎么封装到table里面？

jishuang

再赋值给row中的这个列，或者在row中在加一列把拼接后的这个列，然后返回table

tlkj

怎么赋值给row中的列啊？您看下我应该在哪做这个赋值操作，能否用代码的提示一下？谢谢！

public static Table show() throws ParseException, SQLException {
  String sql = "select uploadAddr from pic";
  HashMap<String, String> sqlMap = new HashMap<String, String>();
  sqlMap.put(SQL.DEFAULT_DB_NAME, sql);
  Table table = SQL.select(sqlMap, null, "/qx/qx/data");
  String uploadAddr = "";
  Iterator<Row> addrRows = table.iterator();
  JSONObject j = new JSONObject();
  String m = "";
  while (addrRows.hasNext()) {
   Row addrRow = addrRows.next();
   uploadAddr = (String) addrRow.getValue("uploadAddr");
   m += uploadAddr + ",";
  }
  m = m.substring(0, m.length() - 1);
  String n = m.replace("[", "");
  String d = n.replace("]", "");
  String newJson = "[" + d + "]";
  
  
  return table;
}

jishuang

table中赋值用setValue
http://bbs.wex5.com/forum.php?mo ... 6&pid=164970537

tlkj

控制台报错

public static Table show() throws ParseException, SQLException {
                String sql = "select uploadAddr from pic";
                HashMap<String, String> sqlMap = new HashMap<String, String>();
                sqlMap.put(SQL.DEFAULT_DB_NAME, sql);
                Table table = SQL.select(sqlMap, null, "/qx/qx/data");

                String uploadAddr = "";
                Iterator<Row> addrRows = table.iterator();

                JSONObject j = new JSONObject();
                String m = "";
                while (addrRows.hasNext()) {

                        Row addrRow = addrRows.next();
                        uploadAddr = (String) addrRow.getValue("uploadAddr");
                        m += uploadAddr + ",";
                }
                m = m.substring(0, m.length() - 1);
                String n = m.replace("[", "");
                String d = n.replace("]", "");
                String newJson = "[" + d + "]";
                Row r = addrRows.next();        
                r.setValue("uploadAddr", newJson);
                return table;
        }


excute stream action, params:{"accept":"application/json","action":"showAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":"","process":"/QX/QX/process/attach_paizhao/attach_paizhaoProcess"}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        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.util.NoSuchElementException
        at java.util.LinkedHashMap$LinkedHashIterator.nextEntry(LinkedHashMap.java:396)
        at java.util.LinkedHashMap$KeyIterator.next(LinkedHashMap.java:405)
        at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
        at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
        at QX.show(QX.java:36)
        ... 27 more