- 博客(7)
- 收藏
- 关注
RSS订阅原创 【无标题】
json格式转换为对象DingUserVo dingUserVo = JsonUtils.fromJson(rspGetResponse.getBody(), DingUserVo.class);
2021-12-24 08:36:38
246
原创 sql中特殊条件置顶排序
sql中特殊条件置顶排序selectv.*,i.plate_no plateNo,i.pri_user_name priUserName,i.car_type carTypefrom vms_car_annual_verification vLEFT JOIN vms_car_info i ON v.car_id = i.idLEFT JOIN sys_user u ON v.pri_user_id = u.idWHERE v.is_delete = ‘0’and v.is_under_war
2021-07-15 11:04:45
235
原创 按照时间排序的同时，同一个机构展示到一起
//自己关联自己将子表分组排序然后按照子表的数据排序SELECT c1.* from cms_tj_out_ticket_templete as c1RIGHT JOIN (SELECT * from cms_tj_out_ticket_templete where tj_num = 1 GROUP BY org_id ORDER BY create_time) as c2on c1.org_id = c2.org_idwhere c1.tj_num = 1and org_id LIKE conc
2021-07-10 09:54:25
66
原创 mysql 获取当月数据
mysql 获取当月数据**DATE_FORMAT( tjrq, ‘%Y%m’ ) = DATE_FORMAT( CURDATE( ) , ‘%Y%m’ )
2021-05-21 15:50:02
147
原创 使用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
645
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人