mysq更新数据库错误:com.mysql.jdbc.MysqlDataTruncation
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'è??è?±2'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3564)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
at com.hugui.flower.dao.impl.FlowerDao4MySQL.modifyFlower(FlowerDao4MySQL.java:480)
at com.hugui.flower.manager.FlowerManagerImpl.modifyFlower(FlowerManagerImpl.java:88)
at com.hugui.flower.servlet.FlowerModifyServlet.doGet(FlowerModifyServlet.java:39)
at com.hugui.flower.servlet.FlowerModifyServlet.doPost(FlowerModifyServlet.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
数据库更新语句:
String sql = "update flower set name=? and descr=? and breed=? and price=? and lowerPrice=? and fileName=? and uses=? and person=? and festival=? and isIndex=? where id=?";
try {
conn = ConnectionManager.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "'"+flower.getName()+"'");
pstmt.setString(2, "'"+flower.getDescr()+"'");
pstmt.setString(3, "'"+flower.getBreed()+"'");
pstmt.setDouble(4, flower.getPrice());
pstmt.setDouble(5, flower.getLowerPrice());
pstmt.setString(6,"'"+ flower.getFileName());
pstmt.setString(7, "'"+flower.getUses()+"'");
pstmt.setString(8, "'"+flower.getPerson()+"'");
pstmt.setString(9, "'"+flower.getFestival()+"'");
pstmt.setInt(10, flower.getIsIndex());
pstmt.setInt(11, id);
pstmt.executeUpdate();
请问有谁知道吗?谢谢啦。。很急。。