导入Excel表格里的数据时出错。

liuqiang221

... 38 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO basic_totalproject (basic_totalproject.ID, basic_totalproject.CREATEDATE, basic_totalproject.CREATEUSER, basic_totalproject.MODIFYDATE, basic_totalproject.MODIFYUSER, basic_totalproject.PROJECTYEAR, basic_totalproject.THEBUDGET, basic_totalproject.TOTALBUDGET, basic_totalproject.CONSTRUCTIONTYPE, basic_totalproject.IFACROSSYEARS, basic_totalproject.TOTALPROJECTNAME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [5B2ADC046A6A429FB3D81FA78DBD6DC2, 1900-08-17 00:00:00.0, null, null, null, 1, 201.0, 2016.0, 0, 5454, null]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 47 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'ifAcrossYears' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3845)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
... 48 more
insert语句插入时字段和参数对不上类型。

jishuang

http://docs.wex5.com/bex5-server-question-list-10005/

liuqiang221

jishuang 发表于 2017-5-18 10:47
http://docs.wex5.com/bex5-server-question-list-10005/

除了改数据库字段长度，还有别的办法没?

liuqiang221

jishuang 发表于 2017-5-18 10:47
http://docs.wex5.com/bex5-server-question-list-10005/

INSERT INTO basic_totalproject (basic_totalproject.ID, basic_totalproject.CREATEDATE, basic_totalproject.CREATEUSER, basic_totalproject.MODIFYDATE, basic_totalproject.MODIFYUSER, basic_totalproject.PROJECTYEAR, basic_totalproject.THEBUDGET, basic_totalproject.TOTALBUDGET, basic_totalproject.CONSTRUCTIONTYPE, basic_totalproject.IFACROSSYEARS, basic_totalproject.TOTALPROJECTNAME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [A485CDFF83294122A23BF846A334FA68, 1900-01-02 00:00:00.0, 2, 2017-11-12 00:00:00.0, null, 56456, 43040.0, 956456.0, 2016, 0, 1]出错
这个打出来的插入语句字段位置跟参数对不上。

jishuang

错误是数据库爆的，不是平台报的

你的sql中有11个？bind中有11个值是正确的

liuqiang221

jishuang 发表于 2017-5-18 14:15
错误是数据库爆的，不是平台报的

你的sql中有11个？bind中有11个值是正确的 ...

是的，11个。insert语句是平台自己的。我看也对着呢，是不是类型不匹配？

jishuang

错误已经报出来是哪个列的问题了，看看insert的值是什么

liuqiang221

jishuang 发表于 2017-5-18 14:15
错误是数据库爆的，不是平台报的

你的sql中有11个？bind中有11个值是正确的 ...

提示

编码：JUSTEP170009
隐藏详细
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: com.justep.excel.ExcelException: 编码: JUSTEP170009; 提示:
at com.justep.excel.ExcelException.create(ExcelException.java:32)
at com.justep.excel.ImportGenerator.formatDate(ImportGenerator.java:257)
at com.justep.excel.ImportGenerator.getValue(ImportGenerator.java:298)
at com.justep.excel.ImportGenerator.setCellsValue(ImportGenerator.java:238)
at com.justep.excel.ImportGenerator.generateRecord(ImportGenerator.java:203)
at com.justep.excel.ImportGenerator.generateSheet(ImportGenerator.java:198)
at com.justep.excel.ImportGenerator.generate(ImportGenerator.java:131)
at Excel.importExcel(Excel.java:88)
... 27 more
Caused by: java.text.ParseException: Unparseable date: ""
at java.text.DateFormat.parse(DateFormat.java:357)
at com.justep.excel.ImportGenerator.formatDate(ImportGenerator.java:255)
... 33 more

jishuang

java.text.ParseException: Unparseable date: ""
at java.text.DateFormat.parse(DateFormat.java:357)

确认日期的值正确吗？

liuqiang221

jishuang 发表于 2017-5-18 16:21
java.text.ParseException: Unparseable date: ""
at java.text.DateFormat.parse(DateFormat.java:357)

好了，我把Excel表的参数位置跟insert语句里的对齐了。谢谢啦。还有个问题，我导入的时候需要判断有没有重复的数据和空数据，平台有参照的代码吗？