mysql 存储过程

DROP PROCEDURE IF EXISTS f_qr_album;

DELIMITER $$

CREATE PROCEDURE f_qr_album
(
	IN	_albumid		VARCHAR(10),
	IN	_albumname		VARCHAR(10),
	IN	_releasedate	VARCHAR(10),
	IN	_publisher		VARCHAR(10),
	IN	_albumdesc		VARCHAR(10),

	IN	_recordstart	INTEGER(10),
	IN	_recordend		INTEGER(10),
	IN	_querytype		INTEGER(10),
	OUT	_recordnum		INTEGER(10),
	OUT	_recordsum		INTEGER(10),
	OUT	_ret			INTEGER(10)
)
BEGIN
	DECLARE _sql VARCHAR(500);
	DECLARE CONTINUE HANDLER FOR NOT FOUND set _ret = -1;
	set @sql = '';
	set _ret = 0;

	-- 1 查询总数 2 查询结果集
	-- IF ISNULL(_albumid) THEN
	IF _albumid IS NOT NULL THEN
		SET @sql = CONCAT(' from t_album ', 'where albumid = ', _albumid);
	ELSE
		SET @sql = CONCAT(' from t_album ', 'where albumname = ', _albumname);
	END IF;

	PREPARE _sql from @sql;
	EXECUTE _sql;
	DEALLOCATE PREPARE _sql;

END
$$

DELIMITER ;