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