** 使用mysql sum统计函数 结果为null时返回值改为0**
select COALESCE(sum(1),0) from dual
–查询上周数据(addtime为时间戳)
SELECT id,addtime FROM mall_order WHERE YEARWEEK(FROM_UNIXTIME(addtime,’%Y-%m-%d’),1) = YEARWEEK(now(),1)-1;
– 查询上周数据(addtime为datetime格式)
SELECT id,addtime FROM mall_order WHERE YEARWEEK(date_format(addtime,’%Y-%m-%d’),1) = YEARWEEK(now(),1)-1;
–Mybatis 转义字符书写方式
<![CDATA[]]>:(1)<![CDATA[]]>不能适用所有情况,转义字符可以;
(2) 对于短字符串<![CDATA[]]>写起来啰嗦,对于长字符串转义字符写起来可读性差;
(3) <![CDATA[]]>表示xml解析器忽略解析,所以更快。
–jpa 升降序
分页条件:
Sort sort = new Sort(Sort.Direction.DESC,“createTime”); //创建时间降序排序
Pageable pageable = PageRequest.of(pageNum,size,sort);
自定义分页:
ORDER BY ?#{#pageable}
@ManyToOne
@JoinColumn(name="invoiceId")
private Invoice invoice;
获取当前月份前六个月,每个月的数据
select DATE_FORMAT(t.create_date,’%Y-%m’) month,count(t.id) as ‘人数’ from biz_account t
where
DATE_FORMAT(t.create_date,’%Y-%m’)>
DATE_FORMAT(date_sub(curdate(), interval 6 month),’%Y-%m’) group by month
获取当前 时间
SELECT NOW(),MONTH(CURDATE()),CURTIME()
Mysql:添加序列
第一种:
select (@i:=@i+1) as i,table_name.* from table_name,(select @i:=0) as it
第二种:
set @rownum=0;
@rownum:=@rownum+1
使用mysql sum统计函数 结果为null时返回值改为0
select COALESCE(sum(1),0) from dual
ssm框架 大于 小于 符号
<![CDATA[ < ]]>
<if test="dbName == 'oracle'">'%,'||#{id}||',%'</if>
<if test="dbName == 'mysql'">CONCAT('%,', #{id}, ',%')</if>
maven配置仓库
<localRepository>E:\maven\Repository</localRepository>
<!--阿里镜像地址-->
<mirror>
<id>alimaven</id>
<name>aliyun maven</name>
<mirrorOf>central</mirrorOf>
<url>http://maven.aliyun.com/nexus/content/repositories/central/</url>
</mirror>