mysql 统计存在加1_mysql 假设存在id则设数据自添加1 ，不存在则加入。java月份计算比較...

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

Calendar calDelM3 = Calendar.getInstance();

calDelM3.set(Calendar.MONTH, calDelM.get(Calendar.MONTH));

for (; calDelM2.compareTo(calDelM3) != -1;) {

System.out.println("================");

System.out.println("calDelM2:" + calDelM2.get(Calendar.MONTH) + " "

+ " calDelM:" + calDelM.get(Calendar.MONTH)+ " calDelM3: " + calDelM3.get(Calendar.MONTH));

System.out.println(calDelM2.compareTo(calDelM3));

calDelM.add(Calendar.MONTH, -1);

isdel = calDelM.get(Calendar.MONTH);

calDelM3.set(Calendar.MONTH, calDelM.get(Calendar.MONTH));

System.out.println("del:" + isdel);

System.out.println("================");

}