手机开发

wukongsky

问题1
如图手机端ui 外文本框使用的是textarea控件
在手机端浏览的时候，为什么会有这个符号呢？怎么去掉啊
问题2 不是手机上是计算机端
另外，textarea上可以上传图片，但是保存会报错




我现在设置就是  正文 用的是textarea控件，他关联的概念-关系是 string 我想这里的设置是有问题 ，应该怎么改正呢

yinlun

1.看下数据库里是否也有<p>
2.报什么错，把控制台信息发上来

wukongsky

数据库中没有。因为从计算机端浏览，就没有这个符号的。
控制台报错
2014-09-02 14:48:47 action:<?xml version="1.0" encoding="UTF-8"?>
<actions><action direct-execute="false" process="/hyoa/tonggaoguanli/process/tonggao/tonggaoProcess" activity="mainActivity" action-flag="__action_2__" executor="6453E3D29773478E93195381CE416923" execute-context="" name="saveHY_TGAction" accept="application/xml, text/xml, */*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="table"><xbiz:table><rows><userdata name="model">/hyoa/tonggaoguanli/data</userdata><userdata name="id-column-name">HY_TG</userdata><userdata name="id-column-type">String</userdata><userdata name="id-column-define">HY_TG</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">HY_TG.version,HY_TG.fTitle,HY_TG.fContent,HY_TG.fDocument,HY_TG.fCreatePsnID,HY_TG.fCreatePsnName,HY_TG.fCompanyID,HY_TG.fCompany,HY_TG.fCreateDeptID,HY_TG.fCreateDeptName,HY_TG.fCreateTime,HY_TG.fReleaseTime,HY_TG.fNoticeType,HY_TG.fNoticeTypeName,HY_TG.fApproverID,HY_TG.fApproverName,HY_TG.fApproveTime,HY_TG.fIsNeedDeptApprove,HY_TG.fBiz1ID,HY_TG.fBiz2ID,HY_TG.fBiz3ID,HY_TG.fBizType,HY_TG.fBizTypeName,HY_TG.fExtendStr1,HY_TG.fExtendStr2,HY_TG.fExtendStr3,HY_TG.fExtendStr4</userdata><userdata name="relation-types">Integer,String,String,Text,String,String,String,String,String,String,DateTime,DateTime,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String</userdata><userdata name="relation-alias">version,fTitle,fContent,fDocument,fCreatePsnID,fCreatePsnName,fCompanyID,fCompany,fCreateDeptID,fCreateDeptName,fCreateTime,fReleaseTime,fNoticeType,fNoticeTypeName,fApproverID,fApproverName,fApproveTime,fIsNeedDeptApprove,fBiz1ID,fBiz2ID,fBiz3ID,fBizType,fBizTypeName,fExtendStr1,fExtendStr2,fExtendStr3,fExtendStr4</userdata><userdata name="sys.rowid">HY_TG</userdata><userdata name="concept">HY_TG</userdata><userdata name="concept-alias">HY_TG</userdata><userdata name="update-mode">whereVersion</userdata><row id="92A7AA83ED054041A8E3A0E1027EB8AB" original-id="92A7AA83ED054041A8E3A0E1027EB8AB"><userdata name="recordState">new</userdata><cell original-value="0">0</cell><cell original-value="" changed="1">1111111</cell><cell original-value="" changed="1">%3Cp%3E%3Cimg%20src%3D%22%2Fx5%2FUI%2Fsystem%2Fcomponents%2Fueditor%2Fview.j%3Ffileid%3D76-defaultDocNameSpace%22%20title%3D%22189637839.jpg%22%2F%3E%3C%2Fp%3E</cell><cell original-value="" changed="1"/><cell original-value="6453E3D29773478E93195381CE416923" changed="1">6453E3D29773478E93195381CE416923</cell><cell original-value="%E5%90%9D%E5%AE%88%E8%83%9C" changed="1">%E5%90%9D%E5%AE%88%E8%83%9C</cell><cell original-value="8AFC569C878C46EB9F72F80E8A2DDCBA" changed="1">8AFC569C878C46EB9F72F80E8A2DDCBA</cell><cell original-value="%E5%AE%8F%E4%B8%9A%E9%9B%86%E5%9B%A2" changed="1">%E5%AE%8F%E4%B8%9A%E9%9B%86%E5%9B%A2</cell><cell original-value="F0C3C6A6CC804B7AAAA61E049F6346FE" changed="1">F0C3C6A6CC804B7AAAA61E049F6346FE</cell><cell original-value="%2F%E5%AE%8F%E4%B8%9A%E9%9B%86%E5%9B%A2%2F%E8%81%8C%E8%83%BD%E6%9C%BA%E6%9E%84%2F%E4%BF%A1%E6%81%AF%E7%AE%A1%E7%90%86%E9%83%A8" changed="1">%2F%E5%AE%8F%E4%B8%9A%E9%9B%86%E5%9B%A2%2F%E8%81%8C%E8%83%BD%E6%9C%BA%E6%9E%84%2F%E4%BF%A1%E6%81%AF%E7%AE%A1%E7%90%86%E9%83%A8</cell><cell original-value="2014-09-02T14%3A47%3A33.936Z" changed="1">2014-09-02T14%3A47%3A33.936Z</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="%E4%B8%8D%E9%9C%80%E8%A6%81" changed="1">%E4%B8%8D%E9%9C%80%E8%A6%81</cell><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/><cell original-value="" changed="1"/></row></rows></xbiz:table></parameter></parameters></action><action direct-execute="false" process="/hyoa/tonggaoguanli/process/tonggao/tonggaoProcess" activity="mainActivity" action-flag="__action_3__" executor="6453E3D29773478E93195381CE416923" execute-context="" name="externalStartProcessAction" accept="*/*">        <parameters xmlns:xbiz="http://www.justep.com/xbiz#">                <parameter name="process">                        <xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">/hyoa/tonggaoguanli/process/tonggao/tonggaoProcess</xbiz:simple>                </parameter>                <parameter name="attributes"><xbiz:map><item key="sData1"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">92A7AA83ED054041A8E3A0E1027EB8AB</xbiz:simple></item></xbiz:map></parameter>                <parameter name="control"/>                <parameter name="executor">                        <xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/>                </parameter>        </parameters></action><action direct-execute="false" process="/SA/doc/system/systemProcess" activity="mainActivity" action-flag="__action_4__" executor="6453E3D29773478E93195381CE416923" execute-context="" name="saveAttachAction" accept="application/json, text/javascript, */*"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="changeLog"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[{"items":[],"autoCreateVersion":false,"createVersionLogs":[],"operate":"saveDoc","url":"","process":"/hyoa/tonggaoguanli/process/tonggao/tonggaoProcess","activity":"mainActivity","isHttps":false}]]></xbiz:simple></parameter><parameter name="isSaveDocLink"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#Boolean">false</xbiz:simple></parameter></parameters></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)
       

wukongsky

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 HY_TG HY_TG(HY_TG, HY_TG.version, HY_TG.fTitle, HY_TG.fContent, HY_TG.fDocument, HY_TG.fCreatePsnID, HY_TG.fCreatePsnName, HY_TG.fCompanyID, HY_TG.fCompany, HY_TG.fCreateDeptID, HY_TG.fCreateDeptName, HY_TG.fCreateTime, HY_TG.fReleaseTime, HY_TG.fNoticeType, HY_TG.fNoticeTypeName, HY_TG.fApproverID, HY_TG.fApproverName, HY_TG.fApproveTime, HY_TG.fIsNeedDeptApprove, HY_TG.fBiz1ID, HY_TG.fBiz2ID, HY_TG.fBiz3ID, HY_TG.fBizType, HY_TG.fBizTypeName, HY_TG.fExtendStr1, HY_TG.fExtendStr2, HY_TG.fExtendStr3, HY_TG.fExtendStr4) VALUES (:HY_TG, :version, :fTitle, :fContent, :fDocument, :fCreatePsnID, :fCreatePsnName, :fCompanyID, :fCompany, :fCreateDeptID, :fCreateDeptName, :fCreateTime, :fReleaseTime, :fNoticeType, :fNoticeTypeName, :fApproverID, :fApproverName, :fApproveTime, :fIsNeedDeptApprove, :fBiz1ID, :fBiz2ID, :fBiz3ID, :fBizType, :fBizTypeName, :fExtendStr1, :fExtendStr2, :fExtendStr3, :fExtendStr4)
        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 HY_TG (HY_TG.fID, HY_TG.VERSION, HY_TG.FTITLE, HY_TG.FCONTENT, HY_TG.FDOCUMENT, HY_TG.FCREATEPSNID, HY_TG.FCREATEPSNNAME, HY_TG.FCOMPANYID, HY_TG.FCOMPANY, HY_TG.FCREATEDEPTID, HY_TG.FCREATEDEPTNAME, HY_TG.FCREATETIME, HY_TG.FRELEASETIME, HY_TG.FNOTICETYPE, HY_TG.FNOTICETYPENAME, HY_TG.FAPPROVERID, HY_TG.FAPPROVERNAME, HY_TG.FAPPROVETIME, HY_TG.FISNEEDDEPTAPPROVE, HY_TG.FBIZ1ID, HY_TG.FBIZ2ID, HY_TG.FBIZ3ID, HY_TG.FBIZTYPE, HY_TG.FBIZTYPENAME, HY_TG.FEXTENDSTR1, HY_TG.FEXTENDSTR2, HY_TG.FEXTENDSTR3, HY_TG.FEXTENDSTR4) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [92A7AA83ED054041A8E3A0E1027EB8AB, 0, 1111111, <p><img src="/x5/UI/system/components/ueditor/view.j?fileid=76-defaultDocNameSpace" title="189637839.jpg"/></p>, null, 6453E3D29773478E93195381CE416923, 吝守胜, 8AFC569C878C46EB9F72F80E8A2DDCBA, 宏业集团, F0C3C6A6CC804B7AAAA61E049F6346FE, /宏业集团/职能机构/信息管理部, 2014-09-02 14:47:33.936, null, null, null, null, null, null, 不需要, null, null, null, null, null, null, null, null, null]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 35 more
Caused by: java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 36 more

jishuang

1.如果手机端不让显示html的节点信息，UI中的textarea组件mediatype不能设置为"text/html"
2.java.sql.DataTruncation: Data truncation字段长度不够，如果用于textarea上传图片把字段类型设置为text或者把string的长度设置大点如2048等

wukongsky

jishuang 发表于 2014-9-2 16:16
1.如果手机端不让显示html的节点信息，UI中的textarea组件mediatype不能设置为"text/html"
2.java.sql.Data ...

1.如果手机端不让显示html的节点信息，UI中的textarea组件mediatype不能设置为"text/html"
没有看明白这句话。现在的问题是，手机端显示《/p》

手机端不让显示“html的节点信息”是什么意思，是链接的意思吗？
我如何让手机端不显示《/p》 ，取消  UI中的textarea组件mediatype设置"text/html"？那样 又影响了计算机端的使用了吧

jishuang

手机端会显示</p>就是因为在PC端编辑数据的是时候用的textarea的mediatype设置为"text/html"，存到数据库中的数据就是html片段，里面就有会</p>等类型的节点信息

手机端是不会去处理这些的，所以就按照数据库中内容全显示出来了

取消  UI中的textarea组件mediatype设置"text/html"就不能上传图片等，上传图片可以用附件组件实现

fpj

wukongsky 发表于 2014-9-2 16:45
1.如果手机端不让显示html的节点信息，UI中的textarea组件mediatype不能设置为"text/html"
没有看明白这 ...

1、平台 textarea 组件的 mefiatype属性 设置为 text/html 时 ，展示为富文本编辑器，
  即数据保存到数据库中的值包含 HTML标签
你可以将  mefiatype属性 设置为空，这样，你输入什么内容，保存到数据库中就是什么内容。

2、你在 textarea 上传图片，你是字段类型是什么类型，长度是多少，
如果你上传图片，字段小了肯定会报错的。 你按 5楼的方法改更一下试试。

btt132

把string的长度设置大点如10240以后就可以了

wukongsky

多谢，结贴