mysql如果存在id则设数据自增加1,不存在则添加。java月份计算比较

2015-11-21 02:01:21 · 作者: · 浏览: 5
INSERT INTO invite_rejectlog_num (
	player_id,
	MONTH,
	count,
	last_modify_time
	)
	VALUES (#{playerId},#{month},#{count},#{lastModifyTime})
	ON DUPLICATE KEY UPDATE count=count+1;

需要唯一约束 id和月份

ava月份计算比较

Calendar calDelM = Calendar.getInstance();
		calDelM.set(Calendar.MONTH, 0);
		System.out.println(calDelM.get(Calendar.MONTH));
		
		calDelM.add(Calendar.MONTH, -1);
		System.out.println(calDelM.get(Calendar.MONTH));

		
		
		
		// ix 遍历需要删除的月份
		int isdel = calDelM.get(Calendar.MONTH);
		int ix = 8;// 缓存最小月份

		Calendar calDelM2 = Calendar.getInstance();
		calDelM2.set(Calendar.MONTH, ix);
		ix = calDelM2.get(Calendar.MONTH);

	
		// ix