Mybatis常用注解

1. foreach注解

 @Select({"<script>", "select * from t_opened_device where deviceId in <foreach collection=\"deviceIds\" index=\"\" item=\"deviceId\" open=\"(\" separator=\",\" close=\")\">  \n" +
            "        #{deviceId} \n" +
            "    </foreach> ", "</script>"})
    List<OpenedDeviceEntity> getOpenedDevicesByDeviceIds(@Param("deviceIds") List<String> deviceIds);