获取数据库中的二进制图片

xiaoxunv

如何获取数据库中二进制中的图片，我现在想获取系统表 SA_OPPerson 中sPhoto字段里的二进制图片，请问怎么获取
Table table=TableUtils.createTable(null, "photo","String","pName","String");
                Table t = KSQL.select("select SA_OPPerson,SA_OPPerson.sName as sName,SA_OPPerson.sPhoto as sPhoto from SA_OPPerson SA_OPPerson where SA_OPPerson='"+pid+"'", null, "/system/data", null);

                Iterator<com.justep.system.data.Row> it = t.iterator();
                while (it.hasNext()) {
                        com.justep.system.data.Row r = it.next();
                        com.justep.system.data.Row row=table.appendRow();
                        try {
                                String sName=r.getString("sName");
                                String url = "/UI2/system/service/common/bizAction.j?" + "DataModel=/system/data" // 数据模块目录
                                                + "&Concept=SA_OPPerson" // 概念名
                                                + "&Relation=sPhoto" // 关系名
                                                + "&ConceptValue=" + r.getValue("SA_OPPerson") // 行ID
                                                + "&process=/SA/OPM/system/systemProcess" // 流程名称
                                                + "&activity=mainActivity" // 环节名称
                                                + "&action=blobDownloadAction" // 调用的Action
                                                + "&$query-version=" + com.justep.system.util.CommonUtils.createGUID();
                                row.setString("photo", addBsessionid(url)); // 将url存入table对象
                                row.setString("pName", sName); // 将url存入table对象
                        } catch (Exception e) {
                                // TODO Auto-generated catch block
                                e.printStackTrace();
                        }
                }
                return table;


这样获取不到？请问有什么解决办法，急用。

jishuang

addBsessionid(url)这个url就可以直接显示图片

xiaoxunv

图片显示不出来，我把这个url  赋给<img>标签的src属性，图片并不显示，然后打开浏览器调试，拿到这个图片的全路径放到浏览器地址栏，就报下面的错：
<root>
<flag>false</flag>
<message>
"/system/logic/action/blobDownloadAction"没有定义参数"Concept"
</message>


<code>JUSTEP150084</code>
<reason/>
<stack>
com.justep.exception.BusinessException: 编码: JUSTEP150084; 提示: "/system/logic/action/blobDownloadAction"没有定义参数"Concept" at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.util.Utils.check(Unknown Source) at com.justep.system.transform.RequestTransform.transActionParams(Unknown Source) at com.justep.system.transform.RequestTransform.transform(Unknown Source) at com.justep.system.action.Engine.translateParameters(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.BusinessServer.excuteGETAction(Unknown Source) at com.justep.business.server.BusinessServer.excuteGETAction(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)
</stack>


<data/>
<messages>
["编码: JUSTEP150084; 提示: \"/system/logic/action/blobDownloadAction\"没有定义参数\"Concept\""]
</messages>



</root>

jishuang

参考http://docs.wex5.com/grid-blobimage/

xiaoxunv

我照着那个上面弄了，还是报错：<root>
<flag>false</flag>
<message>
"/demo/components/process/org/orgProcess"中找不到Activity "null"
</message>


<code>JUSTEP151069</code>
<reason/>
<stack>
com.justep.model.exception.ModelException: 编码: JUSTEP151069; 提示: "/demo/components/process/org/orgProcess"中找不到Activity "null" at com.justep.model.exception.ModelException.create(Unknown Source) at com.justep.model.impl.TemplateImpl.getActivity(Unknown Source) at com.justep.model.impl.ProcessImpl.getActivity(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.BusinessServer.excuteGETAction(Unknown Source) at com.justep.business.server.BusinessServer.excuteGETAction(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)
</stack>


<data/>
<messages>
["编码: JUSTEP151069; 提示: \"/demo/components/process/org/orgProcess\"中找不到Activity \"null\""]
</messages>



</root>

jishuang

process和activity的值不用变

4楼发的链接主要看看在拼接每个参数时参数名的写法

2楼的没有Concept是因为现在版本中用的是blobConceptValue

xiaoxunv

我现在这样写：
var url = biz.Request.setBizParams(require.toUrl("$UI/system/components/justep/blob/server/download.j")
                       + "?process=/SA/OPM/system/systemProcess" //流程名称
                     // + "?process=/SA/OPM/system/systemProcess" //流程名称
                       + "&amp;activity=mainActivity" //环节名称
                       + "&amp;action=blobDownloadAction"//调用的Action
                       + "&blobDataModel=/system/data"//数据模块目录
                       + "&amp;blobConcept=SA_OPPerson"//概念名
                       + "&amp;blobRelation=sPhoto"//关系名
                       + "&amp;blobConceptValue=" + pid//行ID
                       + "&amp;$query-version=" + justep.UUID.createUUID(),this.getContext().getBSessionID());


将url在浏览器地址栏访问，还是报错：
编码: JUSTEP151069; 提示: "/SA/OPM/system/systemProcess"中找不到Activity "null"

jishuang

把最终拼接的要显示的url发一下看看

xiaoxunv

/x5/UI2/v_d0ebf2cd56f3431981daee72d92d3907l_zh_CNs_d_m/system/components/justep/blob/server/download.j?process=/SA/OPM/system/systemProcess&amp;activity=mainActivity&amp;action=blobDownloadAction&blobDataModel=/system/data&amp;blobConcept=SA_OPPerson&amp;blobRelation=sPhoto&amp;blobConceptValue=PSN01&amp;$query-version=C79EBF8D6CC00001742E1AC011F015D3&bsessionid=B0A4836B6F7B1AEC1F3E07F497C2D629

jishuang

参数的连接附不正确
blobDataModel前面的才是对的