下拉列表从数据库无法获取数据

页面做了一个下拉列表  数据是从数据库查询出来的,数据预览没有问题




警告: Failed to sign in----USER:[admin].
2016-12-14 20:56:38
严重: design_open error
com.fr.web.core.A.pD: design_open error
        at com.fr.web.core.A.dD.A(Unknown Source)
        at com.fr.web.core.A.B.C.process(Unknown Source)
        at com.fr.stable.fun.impl.NoSessionIDOPService.process(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
        at com.fr.web.BaseServlet.doGet(Unknown Source)
        at com.fr.web.BaseServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        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:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 7
        at java.lang.String.substring(String.java:1934)
        at com.fr.web.core.A.B.D.actionCMD4User(Unknown Source)
        ... 22 more
2016-12-14 20:57:27
警告: Bad file descriptor
2016-12-14 20:57:27
警告: Bad file descriptor
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 20:58:04
严重: A JSONArray text must start with '[' at character 1 of -1
com.fr.json.JSONException: A JSONArray text must start with '[' at character 1 of -1
        at com.fr.json.JSONTokener.syntaxError(Unknown Source)
        at com.fr.json.JSONArray.<init>(Unknown Source)
        at com.fr.json.JSONArray.<init>(Unknown Source)
        at com.fr.fs.plugin.op.web.action.GetPluginsFromStoreAction.actionCMD(Unknown Source)
        at com.fr.web.core.WebActionsDispatcher.dealForActionNoSessionIDCMD(Unknown Source)
        at com.fr.fs.plugin.op.web.action.PluginOperatorService.process(Unknown Source)
        at com.fr.stable.fun.impl.NoSessionIDService.process(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
        at com.fr.web.BaseServlet.doGet(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
        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:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
        at java.lang.Thread.run(Thread.java:662)
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 20:58:04
警告: 插件列表读取失败
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 20:58:04
警告: Connection refused
2016-12-14 21:10:01
警告: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 12016-12-14 21:10:02
警告: design_preview_td error
com.fr.web.core.A.pD: design_preview_td error
        at com.fr.web.core.A.dD.A(Unknown Source)
        at com.fr.web.core.A.T.E(Unknown Source)
        at com.fr.web.core.A.T.process(Unknown Source)
        at com.fr.stable.fun.impl.NoSessionIDOPService.process(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
        at com.fr.web.BaseServlet.doGet(Unknown Source)
        at com.fr.web.BaseServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        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:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 1        at com.fr.dav.LocalEnv.previewTableData(Unknown Source)
        at com.fr.dav.LocalEnv.previewTableData(Unknown Source)
        at com.fr.web.core.A.eC.actionCMD4User(Unknown Source)
        ... 23 more
Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 1        at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source)
        at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source)
        at com.fr.data.impl.EmbeddedTableData.embedify(Unknown Source)
        ... 26 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 1        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
        at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at com.fr.data.core.db.dialect.AbstractDialect.executeQuery(Unknown Source)
        ... 29 more
2016-12-14 21:10:25
警告: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 12016-12-14 21:10:25
警告: design_preview_td error
com.fr.web.core.A.pD: design_preview_td error
        at com.fr.web.core.A.dD.A(Unknown Source)
        at com.fr.web.core.A.T.E(Unknown Source)
        at com.fr.web.core.A.T.process(Unknown Source)
        at com.fr.stable.fun.impl.NoSessionIDOPService.process(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
        at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
        at com.fr.web.BaseServlet.doGet(Unknown Source)
        at com.fr.web.BaseServlet.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
        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:859)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)
        at java.lang.Thread.run(Thread.java:662)
Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 1        at com.fr.dav.LocalEnv.previewTableData(Unknown Source)
        at com.fr.dav.LocalEnv.previewTableData(Unknown Source)
        at com.fr.web.core.A.eC.actionCMD4User(Unknown Source)
        ... 23 more
Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误
Query:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right synta
x to use near 'null' at line 1        at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source)
        at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source)
        at com.fr.data.impl.EmbeddedTableData.embedify(Unknown Source)
        ... 26 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use near 'null' at line 1        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
        at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at com.fr.data.core.db.dialect.AbstractDialect.executeQuery(Unknown Source)
        ... 29 more


FineReportzhucfsj 发布于 2016-12-14 21:22
悬赏:2 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共7回答
最佳回答
0
zsh331发布于2016-12-14 21:22(编辑于 2023-9-6 09:34)
555
  • zhucfsj zhucfsj(提问者)

    预览数据是正常的。你的截图也能出来
    回复
    2016-12-15 05:49 
最佳回答
0
星痕发布于2016-12-14 21:23(编辑于 2023-9-6 09:34)
555
最佳回答
0
星痕发布于2016-12-14 21:23(编辑于 2023-9-6 09:34)
555
最佳回答
0
看什么看发布于2016-12-14 21:56(编辑于 2023-9-6 09:34)
555
最佳回答
0
zhucfsj发布于2016-12-15 05:49(编辑于 2023-9-6 09:34)
555
最佳回答
0
zhucfsj发布于2016-12-15 05:49(编辑于 2023-9-6 09:34)
555
最佳回答
0
zsh331发布于2016-12-15 06:34(编辑于 2023-9-6 09:34)
555
最佳回答
0
fbczzf发布于2016-12-15 09:21(编辑于 2023-9-6 09:34)
555
最佳回答
0
zhucfsj发布于2017-1-18 15:54(编辑于 2023-9-6 09:34)
555
最佳回答
0
austin1122发布于2017-1-18 18:06(编辑于 2023-9-6 09:34)
555
  • 0关注人数
  • 1330浏览人数
  • 最后回答于:2017-1-18 18:06
    活动推荐 更多
    热门课程 更多
    返回顶部