@Select注解中动态sql处理MyBatis

在Java编程中,ORM框架MyBatis处理@Select注解中的动态sql处理方法

代码如下

public interface UserMapper {
	@Select("<script>select * from user u where u.id in <foreach collection=\"ids\" item=\"item\" index=\"index\" open=\"(\" close=\")\" separator=\",\"> #{item}</foreach> </script>")
	@Results(value = { @Result(property = "userSex", column = "user_sex", javaType = String.class),
			@Result(property = "userName", column = "user_name"), @Result(property = "userAge", column = "user_age") })
	List<User> list(@Param("ids")Long [] ids);
}

简单的说就是讲以前mapper.XML中的sql写法搬到Java代码中.用<SCRIPT></SCRIPT>包裹起来

java编程 MyBatis

https://www.leftso.com/article/92.html