Mybaits

最新推荐文章于 2021-08-03 15:51:08 发布

weixin_33716941

最新推荐文章于 2021-08-03 15:51:08 发布

阅读量58

点赞数

原文链接：http://www.cnblogs.com/Eeexiang/p/10027636.html

版权

1、Mybatis全注解形式（在注解上不能直接使用动态Sql，必须要在前后面加上<script>SQL</script>标签，否则会报错）：

 1     @Select("<script>" +
 2             "select discuss_id,discuss_content,parent_discuss_id,discuss_type,create_datetime from t_discuss " +
 3             "<where>" +
 4             "discuss_id in <foreach collection='discussIds' item='item' open='(' separator=',' close=')'>#{item}</foreach>" +
 5             "</where>" +
 6             "</script>")
 7     @Results({
 8             @Result(column = "discuss_id", property = "discussId"),
 9             @Result(column = "discuss_content", property = "discussContent"),
10             @Result(column = "parent_discuss_id", property = "parentDiscussId"),
11             @Result(column = "discuss_type", property = "discussType"),
12             @Result(column = "create_datetime", property = "createDatetime"),
13     })
14     List<TDiscuss> selectDiscussPushByPIds(@Param("discussIds") List<Long> discussIds);