Solve Java sql. Sqlexception: parameter number x is not an out parameter — turn

Recently, I wrote a project alone. I can't afford to hurt the program ape fighting alone!

When Java calls MySQL stored procedure with input and output parameters, the error is as follows: Java sql. Sqlexception: parameter number x is not an out parameter

As usual, immediately search Google for the above errors, and the answers are to delete the comments behind the output parameters as mentioned.

But I tried and still couldn't. There was no solution for me to ask my peers remotely about QQ group. Pit father's Day was wasted.

Today, I decided to rewrite a test specific stored procedure and call it again.

Sister Ni! cheat your papa!! It is found that the original name of the stored procedure to be called is wrong and the stored procedure does not exist!!!

The name used before was "prc_split_page". Later, the team leader insisted that I change it to "sp_split_page", but the project was suspended for two months and I always forgot to change it.

Then, then,

This ape hereby puts up a card in front of this pit. You are lucky to see that don't jump.

Original address: http://blog.csdn.net/lutinghuan/article/details/9271311