mapper方法里写法 <select id="needSecretReformSchemeList" resultType="org.jeecg.modules.workstand.entity.WkRecordInformation"> SELECT wi.RECORD_NAME, wi.RECORD_TIME, wi.UNIT_NAME, wi.RECORD_PERSON, wi.BUDGET_YEAR, wi.DECLARE_TOTAL, wi.APPROVE_TOTAL FROM wk_record_information wi WHERE wi.status = '19' AND wi.update_time > dateadd(year,-1,now()) AND wi.RECORD_NAME LIKE CONCAT('%', #{dto.recordName}, '%') AND wi.UNIT_NAME LIKE CONCAT('%', #{dto.unitName}, '%') ORDER BY WI.RECORD_TIME </select>
sql
SELECT
wi.RECORD_NAME,
wi.RECORD_TIME,
wi.UNIT_NAME,
wi.RECORD_PERSON,
wi.BUDGET_YEAR,
wi.DECLARE_TOTAL,
wi.APPROVE_TOTAL
FROM wk_record_information wi
WHERE wi.status = '19'
AND wi.update_time > dateadd(year,-1,now()) 主要区别在这儿
为什么还没研究 就这么玩