sql:
SELECT DATE_FORMAT(create_time,'%Y%m') months FROM student GROUP BY months
mapper中:
List<String> hasmonths();
xml中:
<select id="hasmonths" resultType="java.lang.String"> SELECT DATE_FORMAT(create_time,'%Y%m') months FROM biao GROUP BY months </select>