多重循环存储过程

最新推荐文章于 2021-10-24 16:24:16 发布
最新推荐文章于 2021-10-24 16:24:16 发布
阅读量471 收藏
点赞数
分类专栏： SQL 文章标签： 存储过程
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/oShaGuaWoAiNi/article/details/83786559
版权 
DELIMITER $$

USE `gds_qa`$$

DROP PROCEDURE IF EXISTS `stage_tatment_stastics`$$

CREATE DEFINER=`root`@`192.168.0.%` PROCEDURE `stage_tatment_stastics`(accountId VARCHAR(20))
BEGIN
	DECLARE _cnt INT(3);
	DECLARE _userName VARCHAR(20);
	SET _userName = accountId;
	SELECT COUNT(A.rewardId) INTO _cnt  FROM `activity_v2`.`user_stage_reward_money` A LEFT JOIN activity_v2.`reward_money` B ON A.rewardId =B.rewardId WHERE A.rewardType=12 AND A.userName = _userName  AND B.firstAward IS NOT NULL ORDER BY  A.recordTime ASC;  
	IF _cnt=1 THEN
		BEGIN
			DECLARE no_more_departments INT(3);
			DECLARE _consumptionType VARCHAR(255);
			DECLARE _rewardType VARCHAR(255);
			DECLARE _gameSubClass INT(5);
			DECLARE _gameCount INT(3);
			DECLARE _rewardId INT(11);
			DECLARE _rewardTimes INT(3);
			DECLARE _eachStatmentTal INT DEFAULT 0;
			DECLARE _stageTimes INT DEFAULT 0;
			DECLARE _needStatment DOUBLE DEFAULT 0;
			DECLARE _firstStatement DOUBLE DEFAULT 0;
			DECLARE _secondStatement DOUBLE DEFAULT 0;
			DECLARE _thirdStatement DOUBLE DEFAULT 0;
			DECLARE _fourthStatement DOUBLE DEFAULT 0;
			DECLARE _fifthStatement DOUBLE DEFAULT 0;
			DECLARE _sixthStatement DOUBLE DEFAULT 0;
			DECLARE _seventhStatement DOUBLE DEFAULT 0;
			DECLARE _eighthStatement DOUBLE DEFAULT 0;
			DECLARE _ninthStatement DOUBLE DEFAULT 0;
			DECLARE _rewardMoney DOUBLE DEFAULT 0;
			DECLARE _statmentTal DOUBLE DEFAULT 0;
			DECLARE _winLossMoneyAfterTax DOUBLE DEFAULT 0;
			DECLARE _recordTime DATETIME;
			DECLARE _gameTime DATETIME;
			#定义用户规定流水游标
			DECLARE getUserStageRewardMoney CURSOR FOR
			SELECT A.rewardId,rewardMoney,rewardTimes,A.recordTime FROM `activity_v2`.`user_stage_reward_money` A LEFT JOIN activity_v2.`reward_money` B ON A.rewardId =B.rewardId WHERE A.rewardType=12 AND A.userName = _userName  AND B.firstAward IS NOT NULL ORDER BY  A.recordTime ASC;
			#定义实际流水游标
			DECLARE getRewardMoney CURSOR FOR 
			SELECT consumptionType,winLossMoneyAfterTax,gameSubClass,gameTime  FROM gds_qa.play_log WHERE playerName = _userName;
			DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_departments=1; 
			#打开规定流水游标
			OPEN getUserStageRewardMoney;
			FETCH getUserStageRewardMoney INTO _rewardId,_rewardMoney,_rewardTimes,_recordTime;
			#通过奖品rewardId查询每期需要的流水
			SELECT stageTimes, firstStatement,secondStatement,thirdStatement,fourthStatement, fifthStatement,sixthStatement,seventhStatement ,eighthStatement ,ninthStatement 
			INTO  _stageTimes,_firstStatement, _secondStatement,_thirdStatement,_fourthStatement,_fifthStatement,_sixthStatement,_seventhStatement,_eighthStatement,_ninthStatement
			FROM activity_v2.reward_money WHERE rewardId=_rewardId;
			#关闭规定流水游标
			CLOSE getUserStageRewardMoney;
			#统计规定流水
			SET _eachStatmentTal = CASE 
			WHEN (_stageTimes - _rewardTimes)=1 THEN _firstStatement 
			WHEN (_stageTimes - _rewardTimes)=2 THEN _secondStatement
			WHEN (_stageTimes - _rewardTimes)=3 THEN _thirdStatement
			WHEN (_stageTimes - _rewardTimes)=4 THEN _fourthStatement
			WHEN (_stageTimes - _rewardTimes)=5 THEN _fifthStatement
			WHEN (_stageTimes - _rewardTimes)=6 THEN _sixthStatement
			WHEN (_stageTimes - _rewardTimes)=7 THEN _seventhStatement
			WHEN (_stageTimes - _rewardTimes)=8 THEN _eighthStatement
			ELSE  _ninthStatement
			END ;
			#统计实际流水
			SET no_more_departments=0; 
			OPEN getRewardMoney;
			FETCH getRewardMoney INTO _consumptionType,_winLossMoneyAfterTax,_gameSubClass,_gameTime;
			WHILE no_more_departments !=1 DO  
				SELECT COUNT(*) INTO _gameCount  FROM DUAL WHERE _gameSubClass IN(1,2,3,4,5,12,13,14,15,16,17,18,19,20,21,23,24,1108,1110,1115,116,118,1103,5101,4101);	
				IF _gameCount>0 THEN
					IF _gameTime>=_recordTime THEN
						IF "CASH" =_consumptionType THEN
							SET _statmentTal = _statmentTal +ABS(_winLossMoneyAfterTax);
						END IF;
						IF "TANG_COIN" = _consumptionType THEN
							SET _statmentTal = _statmentTal +ABS(_winLossMoneyAfterTax/10000);
						END IF;
					END IF;
				END IF;
				FETCH getRewardMoney INTO _consumptionType,_winLossMoneyAfterTax,_gameSubClass,_gameTime;
			END WHILE;
			CLOSE getRewardMoney;
		        #显示数据
			SET _rewardType="钻石分期返奖";
			
			IF (_eachStatmentTal-_statmentTal)<0 THEN
				SET _needStatment = 0;
				SELECT _userName "用户名" ,_rewardType "奖励类型",1 "参加活动次数",0 "未完成活动次数",_statmentTal "已经完成的流水",_needStatment "还需要的流水",NOW() "时间";
		    
			ELSE
				SET _needStatment = _eachStatmentTal-_statmentTal;
				SELECT _userName "用户名" ,_rewardType "奖励类型",1 "参加活动次数",1 "未完成活动次数",_statmentTal "已经完成的流水",_needStatment "还需要的流水",NOW() "时间";
			END IF;
		END;
	END IF;
	IF _cnt>1 THEN
		BEGIN
			DECLARE i INT;
			DECLARE no_more_departments INT(3);
			DECLARE _z INT DEFAULT -1;
			DECLARE _x INT DEFAULT -1;
			DECLARE _y INT DEFAULT -1;
			DECLARE _v INT DEFAULT -1;
			DECLARE _statmentTotal INT DEFAULT 0;
			DECLARE _statmentTotal1 INT DEFAULT 0;
			DECLARE _rewardRate INT DEFAULT 0;
			DECLARE _need INT DEFAULT -1;
			DECLARE _consumptionType VARCHAR(255);
			DECLARE _rewardType VARCHAR(255);
			DECLARE _gameSubClass INT(5);
			DECLARE _gameCount INT(3);
			DECLARE _statmentCount INT(3);
			DECLARE _rewardId INT(11);
			DECLARE _rewardId2 INT(11);
			DECLARE _rewardTimes INT(3)DEFAULT 0;
			DECLARE _rewardTimes2 INT(3)DEFAULT 0;
			DECLARE _allStatment INT DEFAULT 0;
			DECLARE _eachStatmentTal INT DEFAULT 0;
			DECLARE _eachStatmentTal2 INT DEFAULT 0;
			DECLARE _stageTimes INT DEFAULT 0;
			DECLARE _stageTimes2 INT DEFAULT 0;
			DECLARE _needStatment DOUBLE DEFAULT 0;
			DECLARE _firstStatement DOUBLE DEFAULT 0;
			DECLARE _secondStatement DOUBLE DEFAULT 0;
			DECLARE _thirdStatement DOUBLE DEFAULT 0;
			DECLARE _fourthStatement DOUBLE DEFAULT 0;
			DECLARE _fifthStatement DOUBLE DEFAULT 0;
			DECLARE _sixthStatement DOUBLE DEFAULT 0;
			DECLARE _seventhStatement DOUBLE DEFAULT 0;
			DECLARE _eighthStatement DOUBLE DEFAULT 0;
			DECLARE _ninthStatement DOUBLE DEFAULT 0;
			DECLARE _firstStatement2 DOUBLE DEFAULT 0;
			DECLARE _secondStatement2 DOUBLE DEFAULT 0;
			DECLARE _thirdStatement2 DOUBLE DEFAULT 0;
			DECLARE _fourthStatement2 DOUBLE DEFAULT 0;
			DECLARE _fifthStatement2 DOUBLE DEFAULT 0;
			DECLARE _sixthStatement2 DOUBLE DEFAULT 0;
			DECLARE _seventhStatement2 DOUBLE DEFAULT 0;
			DECLARE _eighthStatement2 DOUBLE DEFAULT 0;
			DECLARE _ninthStatement2 DOUBLE DEFAULT 0;
			DECLARE _rewardMoney DOUBLE DEFAULT 0;
			DECLARE _rewardMoney2 DOUBLE DEFAULT 0;
			DECLARE _statmentTal DOUBLE DEFAULT 0;
			DECLARE _statment DOUBLE DEFAULT 0;
			DECLARE _winLossMoneyAfterTax DOUBLE DEFAULT 0;
			DECLARE _recordTime DATETIME;
			DECLARE _recordTime2 DATETIME;
			DECLARE _gameTime DATETIME;
			DECLARE _activtyTime DATETIME;	
			#定义用户规定流水游标
			DECLARE getUserStageRewardMoney CURSOR FOR 
			SELECT A.rewardId,rewardMoney,rewardTimes, A.recordTime FROM `activity_v2`.`user_stage_reward_money` A LEFT JOIN activity_v2.`reward_money` B ON A.rewardId =B.rewardId WHERE A.rewardType=12 AND A.userName = _userName  AND B.firstAward IS NOT NULL ORDER BY  A.recordTime ASC;
			#定义用户规定流水游标2，用户遍历当前位置的的后面游标数据
			DECLARE getUserStageRewardMoney2 CURSOR FOR 
			SELECT A.rewardId,rewardMoney,rewardTimes, A.recordTime FROM `activity_v2`.`user_stage_reward_money` A LEFT JOIN activity_v2.`reward_money` B  ON A.rewardId =B.rewardId WHERE A.rewardType=12 AND A.userName = _userName  AND B.firstAward IS NOT NULL ORDER BY  A.recordTime ASC;
			#统计实际流水建立游标
			DECLARE getRewardMoney CURSOR FOR 
			SELECT consumptionType,winLossMoneyAfterTax,gameSubClass,gameTime  FROM gds_qa.play_log WHERE playerName = _userName;
			DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_departments=1; 
			#打开规定流水游标
			SET no_more_departments=0; 
			SET i=-1;
			OPEN getUserStageRewardMoney;
			FETCH getUserStageRewardMoney INTO _rewardId,_rewardMoney,_rewardTimes,_recordTime;
			SET _activtyTime = _recordTime;
			read_loop0:LOOP 
				SET i = i+1;
				IF i=_cnt THEN
					LEAVE read_loop0;
				END IF;
			#获取礼品需要流水
			SELECT rewardRate,stageTimes, firstStatement,secondStatement,thirdStatement,fourthStatement, fifthStatement,sixthStatement,seventhStatement ,eighthStatement ,ninthStatement 
			INTO  _rewardRate,_stageTimes,_firstStatement, _secondStatement,_thirdStatement,_fourthStatement,_fifthStatement,_sixthStatement,_seventhStatement,_eighthStatement,_ninthStatement
			FROM activity_v2.reward_money WHERE rewardId=_rewardId;
			#统计规定流水
			SET _eachStatmentTal = CASE 
				WHEN (_stageTimes - _rewardTimes)=1 THEN _firstStatement 
				WHEN (_stageTimes - _rewardTimes)=2 THEN _secondStatement
				WHEN (_stageTimes - _rewardTimes)=3 THEN _thirdStatement
				WHEN (_stageTimes - _rewardTimes)=4 THEN _fourthStatement
				WHEN (_stageTimes - _rewardTimes)=5 THEN _fifthStatement
				WHEN (_stageTimes - _rewardTimes)=6 THEN _sixthStatement
				WHEN (_stageTimes - _rewardTimes)=7 THEN _seventhStatement
				WHEN (_stageTimes - _rewardTimes)=8 THEN _eighthStatement
				ELSE  _ninthStatement
			END ;
		        #统计需要流水的数量，开实际流水游标
			SELECT COUNT(*) INTO _statmentCount FROM gds_qa.play_log WHERE playerName = _userName;
			SET no_more_departments=0; 
			SET _statment=0;	
			OPEN getRewardMoney;
			FETCH getRewardMoney INTO _consumptionType,_winLossMoneyAfterTax,_gameSubClass,_gameTime;
			read_loop:LOOP	
				SET _z =_z +1;
				IF _z>_statmentCount-1 THEN
					LEAVE read_loop; 
				END IF ;
				#只统计手机端规定需要的流水
				SELECT COUNT(*) INTO _gameCount  FROM DUAL WHERE _gameSubClass IN(1,2,3,4,5,12,13,14,15,16,17,18,19,20,21,23,24,1108,1110,1115,116,118,1103,5101,4101);	
				IF _gameCount>0 THEN
					IF _gameTime>=_activtyTime THEN
						IF "CASH" =_consumptionType THEN
							SET _statment = _statment +ABS(_winLossMoneyAfterTax);
						END IF;
						IF "TANG_COIN" = _consumptionType THEN
							SET _statment = _statment +(ABS(_winLossMoneyAfterTax)/10000);
						END IF;
					END IF;
				END IF;	
				FETCH getRewardMoney INTO _consumptionType,_winLossMoneyAfterTax,_gameSubClass,_gameTime;
			END LOOP; 
			CLOSE getRewardMoney;
                       #核心处理逻辑，判断当前活动是否满足流水情况，不满足统计所有活动需要的流水，满足就需要看下个活动是否满足（满足的条件：当前流水大于所有活动的流水）
			SET _x=-1;	
			SET _v=-1;  
			IF  _statment >= _eachStatmentTal THEN     
				IF (i+1)<_cnt THEN
					#获取下一个活动规定流水游标位置
					OPEN getUserStageRewardMoney2 ;	
					FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					read_loop1:LOOP	
						SET _x =_x +1;
						IF _x=i THEN
							LEAVE read_loop1;
						END IF ;
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;     
					END LOOP; 
					#获取剩余活动礼品需要的流水
					SET no_more_departments =0;
					SET _y =_x+1 ;
					SET _statmentTotal = 0;
					read_loop2:LOOP	
						IF _y=_cnt THEN
							LEAVE read_loop2;
						END IF ;
						SELECT stageTimes, firstStatement,secondStatement,thirdStatement,fourthStatement, fifthStatement,sixthStatement,seventhStatement ,eighthStatement ,ninthStatement 
						INTO  _stageTimes2,_firstStatement2, _secondStatement2,_thirdStatement2,_fourthStatement2,_fifthStatement2,_sixthStatement2,_seventhStatement2,_eighthStatement2,_ninthStatement2
						FROM activity_v2.reward_money WHERE rewardId=_rewardId2;
						#统计规定流水
						SET _eachStatmentTal2 = CASE 
							WHEN (_stageTimes2 - _rewardTimes2)=1 THEN _firstStatement2 
							WHEN (_stageTimes2 - _rewardTimes2)=2 THEN _secondStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=3 THEN _thirdStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=4 THEN _fourthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=5 THEN _fifthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=6 THEN _sixthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=7 THEN _seventhStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=8 THEN _eighthStatement2
							ELSE  _ninthStatement2
						END ;
						SET _y= _y+1;
						SET _statmentTotal = _statmentTotal + _eachStatmentTal2;
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					END LOOP;	
					CLOSE getUserStageRewardMoney2;
					#如果当前活动和剩余活动规定流水大于了实际流水，不再做循环统计，反之把时间移动到下一个活动，继续循环
					IF _statmentTotal+_eachStatmentTal>_statment THEN
						SET _allStatment = _statmentTotal + _eachStatmentTal;
						SET _need = i+1;
						LEAVE read_loop0; 
					ELSE
						OPEN getUserStageRewardMoney2 ;	
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
						read_loop5:LOOP	
							SET _v =_v +1;
							IF _v=i THEN
								LEAVE read_loop5;
							END IF ;
							FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;     
						END LOOP; 
						CLOSE getUserStageRewardMoney2;
						SET _activtyTime= _recordTime2; 
					END IF;
				END IF;
			ELSE         
				IF (i+1)<_cnt THEN
					#本次活动流水已经不满足，直接统计剩下活动需要的流水，不再循环最外层循环
					OPEN getUserStageRewardMoney2 ;	
					FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					read_loop3:LOOP	
						SET _x =_x +1;
						IF _x=i THEN
							LEAVE read_loop3;
						END IF ;
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;     
					END LOOP; 
					#获取剩下活动游标礼品需要流水
					SET no_more_departments =0;
					SET _y =_x+1 ;
					SET _statmentTotal1=0;
					read_loop4:LOOP	
						IF _y=_cnt THEN
							LEAVE read_loop4;
						END IF ;
						SELECT stageTimes, firstStatement,secondStatement,thirdStatement,fourthStatement, fifthStatement,sixthStatement,seventhStatement ,eighthStatement ,ninthStatement 
						INTO  _stageTimes2,_firstStatement2, _secondStatement2,_thirdStatement2,_fourthStatement2,_fifthStatement2,_sixthStatement2,_seventhStatement2,_eighthStatement2,_ninthStatement2
						FROM activity_v2.reward_money WHERE rewardId=_rewardId2;
						#统计规定流水
						SET _eachStatmentTal2 = CASE 
							WHEN (_stageTimes2 - _rewardTimes2)=1 THEN _firstStatement2 
							WHEN (_stageTimes2 - _rewardTimes2)=2 THEN _secondStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=3 THEN _thirdStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=4 THEN _fourthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=5 THEN _fifthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=6 THEN _sixthStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=7 THEN _seventhStatement2
							WHEN (_stageTimes2 - _rewardTimes2)=8 THEN _eighthStatement2
							ELSE  _ninthStatement2
						END;
						SET _y= _y+1;
						SET _statmentTotal1 = _statmentTotal1 + _eachStatmentTal2;
						FETCH getUserStageRewardMoney2 INTO _rewardId2,_rewardMoney2,_rewardTimes2,_recordTime2;
					END LOOP;	
					CLOSE getUserStageRewardMoney2;	
					SET _allStatment = _statmentTotal1 + _eachStatmentTal;
					SET _need = i;
					LEAVE read_loop0; 
				ELSE 
					SET _allStatment = _statmentTotal1 + _eachStatmentTal;
					SET _need = i;		
									
				END IF;
			END IF;
			SET no_more_departments =0;
			FETCH getUserStageRewardMoney INTO _rewardId,_rewardMoney,_rewardTimes,_recordTime;
			END LOOP; 
			#关闭游标
			CLOSE getUserStageRewardMoney;
			#存储显示数据
			IF _need = -1 THEN
				SET _need = 0;
			ELSE
				SET _need = _cnt -_need;	
			END IF;
			IF _allStatment-_statment>0 THEN
				SET  _needStatment = ROUND(_allStatment-_statment,2);
			ELSE
				SET _needStatment= 0;
			END IF;
			SET _rewardType = "钻石分期返奖";
			SELECT _userName "用户名" ,_rewardType "奖励类型",_cnt "参加活动次数",_need  "未完成活动次数",ROUND(_statment,2) "已经完成的流水",_needStatment "还需要的流水",NOW() "时间"; 
		END;
	END IF;
END$$

DELIMITER ;

多重循环的存储过程，但不建议使用，复杂的逻辑最好使用合理的代码进行处理

烂红苕
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
存储过程双层循环_存储过程及双循环游标使用
weixin_39875832的博客
12-19 916
遇到了一个问题，有一张表，需要增加一列idx，根据collectionId分组查询数据，然后为idx赋值。分割出来其实就是两个循环。外层循环SELECT DISTINCT collectionId FROM collection_item。内层循环 SELECT id FROM collection_item WHERE collectionId = collection_id。然后更新 UPDA...
sqlserver 存储过程 游标 双层循环
最新发布
Fierceness901的博客
12-12 248
sqlserver 存储过程 游标 双层循环
python数据导出excel_Python-将数据表中数据导出到excel
weixin_39612297的博客
11-20 427
'''需求：写一个函数，随便输入一个表名，把这个表里面所有的数据，导出到excel里面思路：1、'select * from %s' ,查出这个表所有的数据2、再把所有的数据写到excel xlwt'''importpymysql,hashlib,xlwtdefop_mysql(sql:str):mysql_info={'host': 'XXX.XXX.XXX.XXX','port': XXXX...
存储过程 双层循环/批量新增
qq_43356111的博客
04-29 367
存储过程 双层循环 双循环 可以delete,update,insert 例子如下： begin for id in 45478 ..46470 loop for i in 1 ..2 loop insert into TBRANCHINFO(ID,ADDRESS,CITY,CONTACT,DEPNAME,DEPSTATUS,DUTY,PROVINCE,SUPERIORID,TELEPHONE,BRANCHCODE,ALIAS) values(hibern
Mysql存储结构多层循环的多种方式
懒虫的博客
03-24 829
1、通过Repeat方式 DELIMITER $$ DROP PROCEDURE IF EXISTS insertxxx $$ CREATE PROCEDURE insertxxx() BEGIN declare indexSidOut int;-- 内层循环索引936次 declare indexSidIn int;-- 外层循环索引31次 DECLARE fidC int; DECLARE...
循环保存
weixin_30591551的博客
07-18 213
foreach() { 　　中间出问题； 　　continue;不要break; } 转载于:https://www.cnblogs.com/wuhailong/p/3853770.html
4.多重循环+方法+递归作业1
08-08
1. **多重循环**：多重循环是指在一个循环内部嵌套另一个或多个循环。在Java中，常见的多重循环有for循环嵌套for循环，或者for循环嵌套while循环等。多重循环用于处理复杂的数据结构，如矩阵、多维数组等。在题目中...
汇编语言循环程序设计
01-10
汇编语言的循环程序设计是学习和掌握计算机系统运作的重要部分，它涉及到如何用有限的指令实现重复执行特定任务的能力。下面将深入探讨汇编语言中的循环程序设计。 首先，我们要理解循环的基本结构。在汇编语言中，...
多重选择：switch和break.7z
09-15
标题中的“多重选择：switch和break”指的是在编程语言中，特别是C/C++或类似的语法结构中，用于实现多路分支选择的结构——`switch`语句和`break`关键字。`switch`语句允许根据不同的条件执行不同的代码块，而`...
S7300多重背景数据应用
11-06
在编程环境中，多重背景指的是在同一个程序中可以有多个独立运行的程序段或任务，每个任务都有自己的数据存储区，互不干扰。这就像拥有多个工作台，每个工作台处理不同的任务，而工作台上各自的工具和材料都是独立的...
多重访问
02-14
在IT行业中，"多重访问"或"多路访问"通常指的是多个设备或用户同时访问同一资源，如网络带宽、数据库记录或者硬件设备。在C++编程语言中，这一概念可能涉及并发编程、多线程和共享数据结构。下面将详细讨论与这个...
mysql循环存储
做点儿扯谈的事儿
04-29 1039
这几个循环语句的格式如下： WHILE…[条件]…DO…[语句]…END WHILE REPEAT…[语句]…UNTIL …[条件]… END REPEAT [循环体名称]：LOOP …[语句]… [条件] then leave [循环体名称]; END LOOP delimiter $$ //定义结束符为 $$ drop procedure if exists wk; //删除 已有的 存储过程 create procedure wk() //创建新的存储
循环队列 (顺序存储)
想好了就去做吧 即便失败了 至少这条路上留下了你的脚印
10-24 6926
队列是一种操作受限的线性表。队列只能在表的一端进行插入操作，在另一端进行删除操作。其中，允许插入的一端叫队尾，允许删除的一端叫队头。 循环队列是对队列的一种改进，主要是为了解决队尾溢出而实际上数组仍有空余空间这种“假溢出” 问题
计算机二级循环储存,【日常干货】计算机二级基础知识（第三期）
weixin_42124497的博客
07-16 2176
原标题：【日常干货】计算机二级基础知识(第三期)即便是周末也不要忘了学习哦1.下列结构中属于线性结构链式存储的是A)双向链表B)循环队列C)二叉链表D)二维数组▼A【解析】双向链表也叫双链表，是链表(采用链式存储结构)的一种，它的每个数据结点中都有两个指针，分别指向直接后继和直接前驱。循环队列是队列的一种顺序存储结构。二叉链表和二维数组属于非线性结构。2.在线性表的链式存储结构中，其存储空间一般是...
存储过程中的3种循环
weixin_30502965的博客
06-11 3907
在MySQL存储过程的语句中有三个标准的循环方式：WHILE循环，LOOP循环以及REPEAT循环。 这几个循环语句的格式如下： WHILE……DO……END WHILE create procedure pro10() begin declare i int; set i=0; while i<5 do insert into t...
c语言实现数据的循环存储,数据结构C语言实现之循环队列
weixin_36378951的博客
05-17 799
#include #include //定义函数结果状态码#define OK 1#define ERROR 0#define TRUE 1#define FALSE 0//定义循环队列空间大小#define QUEUESIZE 20//定义数据类型typedef int ElemType ;//定义程序返回状态类型typedef int State;//循环队列存储结构typedef struc...
存储过程双层循环_mysql嵌套存储过程实现循环嵌套
weixin_34996214的博客
01-12 683
下面是工作中使用到的一个mysql嵌套循环存储过程，因为写的比较少，开始写花费了一点时间，特此记录一下DELIMITER //CREATE PROCEDURE handleHisNewCommentData()BEGINDECLARE done INT DEFAULT FALSE;DECLARE topId INT;DECLARE topComments_cur CURSOR FOR SELECT...
c语言实现数据的循环存储,顺序循环行列的c语言实现
weixin_33901087的博客
05-17 1171
顺序循环队列的c语言实现1.循环队列的顺序存储结构typedef struct{QElemType data[MAXSIZE];int front; /* 头指针 */int rear;/* 尾指针，若队列不空，指向队列尾元素的下一个位置 */}SqQueue;2.初始化一个空队列QStatus InitQueue(SqQueue *Q){Q->front=0;Q->rear...
队列的循环存储C实现
weixin_34256074的博客
04-05 176
队列是一种先进先出（FIFO）的线性表，只允许在一端（队尾）进行插入操作，另一端（队首）进行删除操作。 队列的顺序存储结构是用一组连续的地址空间存放队列元素。在队尾进行插入元素使空间不断减少，而在队首进行删除操作使空间增多。顺序队列的弊端在于增加的空闲空间不能重新利用，而循环队列的首尾连接在一起，进行删除操作增加的空间能够重新利用。 下面是代码：#incl...
pl/sql存储过程中的递归调用有哪些
03-29
在PL/SQL存储过程中，递归调用是指一个过程调用自身的过程。以下是几种常见的递归调用方式： 1. 简单递归调用：过程直接调用自身，直到满足某个条件停止递归。 2. 多重递归调用：过程调用多个其他过程，这些过程又可以调用自身或其他过程，直到满足某个条件停止递归。 3. 尾递归调用：过程的最后一条语句是对自身的调用，这样可以避免递归调用的栈溢出问题。 4. 直接递归调用：过程直接调用自身。 5. 间接递归调用：过程调用其他过程，而这些过程又调用该过程，构成间接递归调用。 6. 循环递归调用：过程调用自身时，参数不断变化，形成一个循环过程。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值