Ibatis sql书写经验
1 resultMap写在SQL之前
2 重复使用sql的方法:
<sql id="sql_selectHoliday">
??? ??? select .....deleted? from t_holiday
??? </sql>
???
??? <select id="selectHolidays" resultMap="holidayResultMap">
??? ??? <include refid="sql_selectHoliday"></include>
??? ??? ?where deleted!=1
??? </select>
3 比较日期的写法
<select id="selectHolidaysBetweenDates" resultMap="holidayResultMap">
??? ??? <include refid="sql_selectHoliday"></include>
??? ??? where deleted!=1 and
??? ??? <![CDATA[
??? ??? start_time <= to_date(#date1#,'yyyy-MM-dd HH24:MI:SS') and end_time >= to_date(#date2#,'yyyy-MM-dd HH24:MI:SS')
??? ??? ]]>
??? </select>
?