Cacher is the code snippet organizer for pro developers

<?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.xyzniu.mapper.FlowerMapper">
  
    <cache readOnly="true"></cache>
  
    <select id="selAll" resultType="Flower">
        SELECT * FROM flower
    </select>

    <select id="selById" resultType="com.xyzniu.pojo.Flower">
        SELECT * FROM flower WHERE id = '1'
    </select>

    <select id="selPage" resultType="Flower" parameterType="map">
        SELECT * FROM flower limit #{start},#{pages}
    </select>

    <select id="selSome" resultType="Flower" parameterType="int">
        <![CDATA[ SELECT * FROM flower id<#{0}]]>
    </select>
</mapper>