mybatis 返回list对象集合

为什么80%的码农都做不了架构师？>>>   

user类

public class User implements  Serializable{
	
	private static final long serialVersionUID = 1L;

	private int  activeid;
	private String openid;
	private String name;
	private int sex;
	private String telphone;
	private String image_url;
	private int audit;
    ......
    set get

	
}

 返回就用resultMap，并且 自定义resultMap  

resultMap 里面的result 对应的要放回类的属性

 

	<resultMap type="org.ice.entity.User" id="users">
		<result column="openid" property="openid"/>
		<result column="sex" property="sex"/>
		<result column="telphone" property="telphone"/>
		<result column="image_url" property="image_url"/>
		<result column="audit" property="audit"/>
	</resultMap>	

   <select id="findAll" parameterType="map" resultMap="users" >
		select * from ice_user where 
		<if test="activeid !=null">
			activeid = #{activeid}
		</if>
		<if test="openid !=null">
			AND openid = #{openid}
		</if>
		<if test="audit !=null">
			AND audit = #{audit}
		</if>
	</select>

 

dao 层

 /**
   * 按条件查找users
   * @param where
   * @return
   */
  public List<User> findAll(Map<String, Object> where);
  

返回时list 对象。

 

 

如果dao是返回list，而mapp.xml 不是自定义resultMap 那么报错

 

 

转载于:https://my.oschina.net/jywm/blog/780028