Question

java修改数据时（mysql）时出错，添加数据显示成功，数据库没有数据

java.sql.SQLException: PROCEDURE updatecommodity does not exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2949)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:959)
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1233)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:3628)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:628)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)

Answer 1

updatecommodity PROCEDURE updatecommodity does not exist ；
说的很清楚了。 找不到存储过程“updatecommodity ”

Answer 2

你是批量Update的时候出错的吧

Answer 3

你的问题很神奇，谷歌百度都没有，你是一线开发人员？

Answer 4

执行存储过程报错了啊