Mybatis使用经验归档

<insert id="register" parameterType="com.hans.entity.User" useGeneratedKeys="true" keyProperty="id" keyColumn="id" >
        INSERT INTO USER ( usercode,PASSWORD,phone,NAME)
    　　 VALUES(#{phone},#{password},#{phone},#{name})
</insert>

<if test="list!= null and list.size > 0">
    <foreach collection="list" item="item" separator="," open="AND v.id in (" close=")">
        #{item}
    </foreach>
</if>

 <![CDATA[ AND  DATE_FORMAT(t.create_time,‘%Y-%m-%d‘) = DATE_FORMAT(#{createTime},‘%Y-%m-%d‘)]]>

 <sql id="Base_Column_List">
        t.name,
        t.id
  </sql>

<select id="getObjectById" resultType="com.t3.ts.resource.manager.dto.VehicleTaxDto">
        SELECT
            <include refid="Base_Column_List" />
        FROM
            person t
</select>