DELIMITER $$
CREATE PROCEDURE CJ_Data(in_xh CHAR(6),in_kch CHAR(3),in_cj TINYINT)
BEGIN
	DECLARE in_count INT(4);
	DECLARE in_xf    TINYINT;
	DECLARE in_cjb_cj TINYINT;
	SELECT ѧ INTO in_xf FROM kc WHERE γ̺=in_kch;
	SELECT COUNT(*) INTO in_count FROM xs_kc WHERE ѧ=in_xh AND γ̺=in_kch;
	SELECT ɼ INTO in_cjb_cj FROM xs_kc WHERE ѧ=in_xh AND γ̺=in_kch;
	IF in_count>0 THEN
	BEGIN
		DELETE FROM xs_kc WHERE ѧ=in_xh and γ̺=in_kch;
		IF in_cjb_cj>60 THEN
			UPDATE xs set ѧ=ѧ-in_xf WHERE ѧ=in_xh;
		END IF;
	END;
	END IF;
	IF in_cj!=-1 THEN
	BEGIN
		INSERT INTO xs_kc VALUES(in_xh,in_kch,in_cj,NULL);
		IF in_cj>60 THEN
			UPDATE xs set ѧ=ѧ+in_xf WHERE ѧ=in_xh;
		END IF;
	END;
	END IF;
END$$
DELIMITER ;