打算从excel中的数据读取到mysql中从excel 中读出的数据放到float中去,总报exception:如下:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'Infinity' i
n 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1293)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1566)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1480)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1465)
at com.deversoft.oa.wages.dao.Wages.insertIntoDb(Wages.java:203)
at com.deversoft.oa.wages.dao.Wages.<init>(Wages.java:125)
at com.deversoft.oa.wages.dao.ParseXls2.doParser(ParseXls2.java:114)
at org.apache.jsp.ext.wagesmanager.doupload_jsp._jspService(org.apache.j
sp.ext.wagesmanager.doupload_jsp:78)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
91)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilte
r.java:123)是什么原因?
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'Infinity' i
n 'field list'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1293)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1566)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1480)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1465)
at com.deversoft.oa.wages.dao.Wages.insertIntoDb(Wages.java:203)
at com.deversoft.oa.wages.dao.Wages.<init>(Wages.java:125)
at com.deversoft.oa.wages.dao.ParseXls2.doParser(ParseXls2.java:114)
at org.apache.jsp.ext.wagesmanager.doupload_jsp._jspService(org.apache.j
sp.ext.wagesmanager.doupload_jsp:78)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
91)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilte
r.java:123)是什么原因?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货