本文将为您描述JPA 中 in 的方法 注意参数一定要是List,具体完成步骤:@Query(nativeQuery = true, value = "SELECT aea.`create_date` AS createTime, aadd.`remark`, aad.`data` FROM acb_electricity_alarm aea LEFT JOIN acb_alert_datas aad ON aad.`acb_electricity_alarm_id` = aea.`id` LEFT JOIN acb_alert_datas_dictionary aadd ON aadd.`id` = aad.`dictionary_id` n" +
"WHERE aea.`break_device_id` = ?1 AND DATEDIFF ( aea.`create_date` , ?2 ) = 0 AND aadd.`type` in ( ?3 ) ")
List> getDynamicCurveByDay(String breakDeviceId, String time, List type);
jap 中如果要使用in 参数必须用list<>
JPA 中 in 的方法 注意参数一定要是List就为您介绍到这里,感谢您关注懒咪学编程c.lanmit.com.
本文地址:https://c.lanmit.com/bianchengkaifa/bianchengkaifajuhe/26019.html