JAVA 调用存储过程报NullPointerException,请教
调用Java程序如下:
.....
CallableStatement cs = null;
cs = conn.prepareCall("{call sp_rankquery(?,?)}");
cs.setString(1, badge);
cs.setString(2, aEntity.getPassword());
rs = cs.executeQuery();
......
存储过程为:
CREATE PROCEDURE sp_rankquery @workernumber0 nvarchar(50),@password0 nvarchar(16) AS
If exists(select ID from account where Password=@password0 and ID=@workernumber0)
select rank from account where rank is not NULL and rank<>'不聘' and rank <>'待定' and Password=@password0 and ID=@workernumber0
GO
报错如下:
在cs.setString(1, badge);位置报java.lang.NullPointerException
注: connection没有问题,其他数据库操作都可以.