SQL注解(动态SQL语句)

最新推荐文章于 2023-05-17 18:45:00 发布

ᅟᅟᅟᅟᅟ

最新推荐文章于 2023-05-17 18:45:00 发布

阅读量896

点赞数 1

文章标签： sql 数据库 database

本文链接：https://blog.csdn.net/manhengwei/article/details/118494614

版权

@Select({"<script>", 
"select
w.warn_status warnStatus,
w.warn_level warnLevel,
w.warn_type warnType,
c.DEVICE_CODE deviceCode,
c.APPLICATION_DEVICE_CODE applicationDeviceCode,
f.DEPARTMENT_CODE departmentCode,
f.DEPARTMENT_NAME departmentName,
f.VEHICLE_AGE vehicleAge,
f.DATA_SOURCE dataSource,
f.ASSETS_FORM assetsForm,
f.MMIS mmis,f.LICENSE_PLATE_NUMBER licensePlateNumber, 
f.ASSETS_CODE assetsCode, 
f.ASSETS_NAME assetsName,
f.ASSETS_CLASSIFY_CODE assetsClassifyCode,
f.ASSETS_CLASSIFY_NAME assetsClassifyName,
f.ENGINE_NUMBER engineNumber 
from
finance_office_hn.fixed_assets f 
left join 
finance_office_hn.assets_device_bind b 
on 
f.assets_code = b.assets_code 
left join 
finance_office_hn.cfg_device c 
on
b.device_code = c.device_code 
left join 
finance_office_hn.warn_event w 
on 
f.assets_code=w.assets_code", 
"<where>", 
"<if test= \"departmentCode != null and departmentCode != ''\">", 
"and f.DEPARTMENT_CODE=#{departmentCode}", 
"</if>", 
"<if test= \"assetsForm != null and assetsForm != ''\">", 
"and f.ASSETS_FORM=#{assetsForm}", 
"</if>",
"<if test= \"warnLevel != null and warnLevel != ''\">",
"and w.WARN_LEVEL=#{warnLevel}", 
"</if>",
"and w.WARN_STATUS=0 and w.IS_DELETE=0 and f.IS_DELETE=0 and c.IS_DELETE=0 and b.IS_DELETE=0 and w.WARN_LEVEL !=0", 
"</where>", 
"</script>"})
List<MonitorDto> findByAssetsForm(MonitorDto monitorDto);