MYBATIS 的parameter.docVIP

MYBATIS 的parameter 博客分类： JAVA mybatisparameter Parameter1. 传入简单类型 JAVA代码: Java代码 public User get(Long id) { return (User) getSqlSession().selectOne(com.liulanghan.get , id); } public User get(Long id) { return (User) getSqlSession().selectOne(com.liulanghan.get , id); } MAPPER : Xml代码 select id=findUserListByIdList parameterType=java.lang.Long resultType=User select * from user where id = #{id}; /select select id=findUserListByIdList parameterType=java.lang.Long resultType=User select * from user where id = #{id}; /select 2. 传入List JAVA代码: Java代码 public ListArea findUserListByIdList(ListLong idList) { return getSqlSession().selectList(com.liulanghan.findUserListByIdList, idList); } public ListArea findUserListByIdList(ListLong idList) { return getSqlSession().selectList(com.liulanghan.findUserListByIdList, idList); } MAPPER : Xml代码 select id=findUserListByIdList parameterType=java.util.ArrayList resultType=User select * from user user where user.ID in ( foreach item=guard index=index collection=list separator=, #{guard} /foreach ) /where /select select id=findUserListByIdList parameterType=java.util.ArrayList resultType=User select * from user user where user.ID in ( foreach item=guard index=index collection=list separator=, #{guard} /foreach ) /where /select 单独传入list时，foreach中的collection必须是list，不不管变量的具体名称是什么。比如这里变量名为idList，collection却是是list。 3. 传入数组 JAVA代码: Java代码 public ListArea findUserListByIdList(int[] ids) { return getSqlSession().selectList(com.liulanghan.findUserListByIdList, ids); } public ListArea findUserListByIdList(int[] ids) { return getSqlSession().selectList(com.liulanghan.findUserListByIdList, ids); } MAPPER : Xml代码 select id=findUserListByIdList parameterType=java.util.HashList resultType=User select * from user user where user.ID in ( foreach item=guard index=index collection=array separator=, #{guard} /foreach ) /where /select select id=findUserListByIdList para