2024-07-15 朱宝民 优化补卡接口之获取已挂失退款金额条件
 
	
	
	
	
	
	
	
	
	
	
	
	
	
 |  |  | 
 |  |  |       #name: sp | 
 |  |  |       type: com.alibaba.druid.pool.DruidDataSource | 
 |  |  |       driverClassName: com.mysql.cj.jdbc.Driver | 
 |  |  |       url: jdbc:mysql://192.168.40.166:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  | #      url: jdbc:mysql://192.168.40.166:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  | #      url: jdbc:mysql://127.0.0.1:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  |       url: jdbc:mysql://8.140.179.55:3306/pipIrr_sp?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull | 
 |  |  |       username: root | 
 |  |  |       password: dysql,;.abc!@# | 
 |  |  |       druid: | 
 
 |  |  | 
 |  |  |       AND ope.operate_type = 6 | 
 |  |  |       AND card.cardNum = #{cardNum} | 
 |  |  |     </where> | 
 |  |  |     ORDER BY ope.operate_dt DESC | 
 |  |  |     LIMIT 0,1 | 
 |  |  |   </select> | 
 |  |  | </mapper> |