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)
把你相关的java的代码贴出来一下
CREATE PROCEDURE sp_select_count(OUT count INT(10))
BEGIN
SELECT COUNT(*) INTO count FROM imooc_goddess;
END
SQL语法错误 第一行代码错了