博客系统-按类型或者按日期统计博客

1.按类型统计博客数量：按类型统计需要做链接或者又链接按博客类型分组统计

2.日期统计首先需要对日期格式化，然后在按年月分组统计：

按类型统计

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.java1234.dao.BlogTypeDao">

<resultMap type="BlogType" id="BlogTypeResult">
<result property="id" column="id"/>
<result property="typeName" column="typeName"/>
<result property="orderNo" column="orderNo"/>
</resultMap>

<select id="countList" resultMap="BlogTypeResult">
SELECT t2.id,t2.typeName,COUNT(t1.id) AS blogCount FROM t_blog t1 RIGHT JOIN t_blogType t2 ON t1.typeId=t2.id GROUP BY t2.typeName ORDER BY t2.orderNo;
</select>

</mapper>

2.按日期统计

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.java1234.dao.BloggerDao">

<resultMap type="Blogger" id="BloggerResult">
<result property="id" column="id"/>
<result property="userName" column="userName"/>
<result property="password" column="password"/>
<result property="profile" column="profile"/>
<result property="nickName" column="nickName"/>
<result property="sign" column="sign"/>
<result property="imageName" column="imageName"/>
</resultMap>

<select id="getByUserName" parameterType="String" resultMap="BloggerResult">
select * from t_blogger where userName=#{userName}
</select>

<select id="find" resultMap="BloggerResult">
select * from t_blogger where id=1;
</select>
</mapper>