![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mybatis
Never_ever_ever
这个作者很懒,什么都没留下…
展开
-
SQL中的case when then else end用法
一:简单用法: 1.第一种写法: SELECT s.s_id, s.s_name, s.s_sex, CASE WHEN s.s_sex = '1' THEN '男' WHEN s.s_sex = '2' THEN '女' ELSE '其他' END as sex, s.s_age, s.class_id FROM t_b_student s...转载 2019-01-15 13:50:38 · 125 阅读 · 0 评论 -
MyBatis插入操作后利用Bean返回id
例子: AuditProcessBean processBean = new AuditProcessBean(); processBean.setOpen_id(auditSubmitDto.getOpen_id()); processBean.setCreate_time(new Date()); ...原创 2019-02-22 13:24:12 · 471 阅读 · 0 评论 -
MySQL数据库将多条记录的单个字段合并成一条记录
原SQL SELECT acc.id,acc.acc_username,acc.acc_showname,T_PM_ROLE.role_name FROM T_ACCOUNT acc,T_ACCOUNT_R_ROLE accRole ,T_PM_ROLE WHERE acc.is_active =1 AND (accRole.is_active =1 AND acc.id = accR...转载 2019-03-13 16:12:17 · 963 阅读 · 0 评论