为了账号安全,请及时绑定邮箱和手机立即绑定

调用带输出参数的存储过程出错

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)

https://img1.sycdn.imooc.com//5b99c77f0001851b05860527.jpg

正在回答

3 回答

把你相关的java的代码贴出来一下

0 回复 有任何疑惑可以回复我~

CREATE PROCEDURE sp_select_count(OUT count INT(10))

BEGIN

SELECT COUNT(*) INTO count FROM imooc_goddess;

END


0 回复 有任何疑惑可以回复我~

SQL语法错误 第一行代码错了

0 回复 有任何疑惑可以回复我~

举报

0/150
提交
取消

调用带输出参数的存储过程出错

我要回答 关注问题
意见反馈 帮助中心 APP下载
官方微信