Mysql存储过程之登录模板（个人使用）

DELIMITER $$
USE `liweinan`$$
DROP PROCEDURE IF EXISTS `proc_sys_user`$$
CREATE DEFINER=`root`@`%` PROCEDURE `proc_sys_user`(IN uName VARCHAR(50), IN uPassword VARCHAR(50))
BEGIN
	DECLARE id_proc INT DEFAULT 0;
	DECLARE name_proc VARCHAR(50) DEFAULT '';
	DECLARE pwd_proc VARCHAR(50) DEFAULT '';
	DECLARE result VARCHAR(20) DEFAULT 'success';
	SELECT u_id,u_name,u_password INTO id_proc,name_proc,pwd_proc FROM sys_user WHERE u_name = uName;
	IF id_proc=0 THEN
		SET result='user_name error';
	ELSE
		IF pwd_proc!=uPassword THEN
			SET result='user_pwd error';
		END IF;	
	END IF;	
	SELECT * FROM (SELECT id_proc uId,uName,uPassword) b,(SELECT result) a;	
END$$
DELIMITER ;