//1--------复制属性
BeanUtils.copyProperties(memberReq, userBgd);
//2---------注解时间格式
@DateTimeFormat(pattern = "yyyy-MM-dd")
//3----mybates---模糊查询
criteria.andUserAccountLike("%" + req.getUserAccount() + "%");
//4--------------fastjson List转JSONArray------以及JSONArray转List
String res = hd.post(ipCenterService.getIpCenter(Constants.HALL_REQ_KEY), sendmap);
JSONArray jArray = JSONArray.parseArray(res);
// BookInfoResult result = gson.fromJson(res, BookInfoResult.class);
List<AgentDTO> list = JSONObject.parseArray(jArray.toJSONString(), AgentDTO.class);
//5------mybates注解查询-----和对应参数
@Select("SELECT create_name FROM data_bgd_b.bgd_special_rid WHERE rid = #{rid,jdbcType=INTEGER} ")
String selectTopAccountByBRid(@Param("rid") Integer rid);
//6--map去重
Map<Integer, BaseGameWinLoseModel> ok_map = new HashMap<>();
for (BaseGameWinLoseModel one : all_list) {
if (map.containsKey(one.getUserId())) {
BaseGameWinLoseModel map_in = ok_map.get(one.getUserId());
map_in.setGameGoldSend(one.getGameGoldSend() + map_in.getGameGoldSend());
ok_map.put(one.getUserId(), map_in);
} else {
ok_map.put(one.getUserId(), one);
}
}
//7--根据日期写sql
@Select("SELECT id, rid, rnick, gold_change AS goldChange, gold_after AS goldAfter, safe_box_after AS safeBoxAfter, create_time AS createTime, note, type FROM ${dbName} WHERE rid = ${rid} ${type}")
List<GameGoldWater> selectByDateList(@Param("dbName") String dbName ,@Param("rid") Integer rid,@Param("type") String type);
//根据日期写sql
@Select("SELECT COUNT(*) FROM ${dbName} WHERE rid = ${rid} ${type}")
long selectByDateCount(@Param("dbName") String dbName ,@Param("rid") Integer rid,@Param("type") String type);
//8----mybatis里面大于和小于
>--- > < -- <
<if test="days!=-1 and days !=null and days!=0">
and DATE_FORMAT(computeTime, '%Y-%m-%d') >= DATE_SUB(CURDATE(), INTERVAL #{days} DAY)
</if>