- 博客(3)
- 资源 (6)
- 收藏
- 关注
原创 mysql select if 使用
SELECT cb.*,IF(cb.class_date_end_time > NOW(),1,0) is_endCourse,tc.id teacher_id,tc.head_pic FROM ( SELECT * FROM py_class_base ) cb LEFT JOIN py_teacher tc ON cb.teacher_id=tc.id
2019-04-19 23:27:37 12092
原创 MySQL两个时间字段相减
SELECT class_date_start_time ,class_date_end_time, (UNIX_TIMESTAMP(class_date_end_time)-UNIX_TIMESTAMP(class_date_start_time))/60/60 FROM py_class_base
2019-04-11 11:25:50 11784
原创 spring boot filter获得 request.getParameterMap()
@Order(1) @Component public class RequestParamFilter implements Filter { private static final Logger log = LoggerFactory.getLogger(RequestParamFilter.class); public static Map<String, String>...
2019-04-09 22:55:42 1715
mybatis dao xml 代码生成工具
2019-02-28
Activiti入门教程
2017-12-18
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人