- 博客(7)
- 收藏
- 关注
原创 【无标题】
json格式转换为对象 DingUserVo dingUserVo = JsonUtils.fromJson(rspGetResponse.getBody(), DingUserVo.class);
2021-12-24 08:36:38 209
原创 sql中特殊条件置顶排序
sql中特殊条件置顶排序 select v.*,i.plate_no plateNo,i.pri_user_name priUserName,i.car_type carType from vms_car_annual_verification v LEFT JOIN vms_car_info i ON v.car_id = i.id LEFT JOIN sys_user u ON v.pri_user_id = u.id WHERE v.is_delete = ‘0’ and v.is_under_war
2021-07-15 11:04:45 161
原创 按照时间排序的同时,同一个机构展示到一起
//自己关联自己将子表分组排序然后按照子表的数据排序 SELECT c1.* from cms_tj_out_ticket_templete as c1 RIGHT JOIN (SELECT * from cms_tj_out_ticket_templete where tj_num = 1 GROUP BY org_id ORDER BY create_time) as c2 on c1.org_id = c2.org_id where c1.tj_num = 1 and org_id LIKE conc
2021-07-10 09:54:25 39
原创 mysql 获取当月数据
mysql 获取当月数据** DATE_FORMAT( tjrq, ‘%Y%m’ ) = DATE_FORMAT( CURDATE( ) , ‘%Y%m’ )
2021-05-21 15:50:02 90
原创 使用httpClient获取微信accessToken
public class AccessTokenUtil { private static final String APPID = ""; private static final String APPSECRET = ""; private static Log logger = LogFactory.getLog(AccessTokenUtil.class); public static String getToken() throws Exception { .
2021-05-11 16:59:24 576
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人