調用帶輸出參數的存儲過程出錯
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`count`)' at line 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:843)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:752)
at dao.ProcedureDAO.select_count(ProcedureDAO.java:65)
at test.ProcedureTest.select_count(ProcedureTest.java:48)
at test.ProcedureTest.main(ProcedureTest.java:26)
2018-11-07
把你相關的java的代碼貼出來一下
2018-10-20
CREATE PROCEDURE sp_select_count(OUT count INT(10))
BEGIN
SELECT COUNT(*) INTO count FROM imooc_goddess;
END
2018-09-19
SQL語法錯誤 第一行代碼錯了