java则行存储过程先修改操作,再查询返回 存储过程需要设置SET NOCOUNT ON
PreparedStatement.executeQuery
alter PROCEDURE xxx
AS
DECLARE @name
BEGIN
SET NOCOUNT ON
update ...
SELECT @name = name from user
RETURN
END
普通的业务操作存储过程没有return的则不需要加SET NOCOUNT ON
int count = pstmt.executeUpdate();