<!-- 按条件分页查询数据列表 -->
<select id="findPageList" parameterType="committeeExt" resultType="committeeExt">
select
com.id,
com.courtCode,
cou.name as courtName,
com.name,
com.url,
com.description,
date_format(com.updateTime, '%Y-%c-%d %H:%i') as updateTimeStr
from
tb_committee com
left join tb_court cou on com.courtCode = cou.courtCode
where
com.status = '1'
<if test="name != null and name != ''">
and cou.name LIKE '%${name}%'
</if>
</select>
</select>
mybatis连接mysql 时间格式化显示页面
最新推荐文章于 2024-01-08 08:53:14 发布