1.dao方法
List<User> getUserList(@Param("jdbcType") String jdbcType);
2.xml示例:
<select id="getUserList" resultType="com.fxyt.system.entity.User"> SELECT <if test="jdbcType == 'mysql' "> DATE_FORMAT(create_time,'%Y-%m-%d') AS createDate </if> <if test="jdbcType == 'oracle' "> to_date(create_time,'yyyy-MM-dd') AS createDate </if> FROM js_sys_user </select>