xml version=10 encoding=UTF-8!DOCTYPE mapper PUBLIC -mybatisorgDTD Mapper 30EN httpmybatisorgdtdmybatis-3-mapperdtdmapper namespace=comdaoAddressDao !-- 可根据自己的需求是否要使用 -- resultMap type=comentityAdd

<!-- 定义结果集映射，将查询结果映射为实体类AddressEntity -->
<resultMap type="com.entity.AddressEntity" id="addressMap">
    <result property="userid" column="userid"/>
    <result property="address" column="address"/>
    <result property="name" column="name"/>
    <result property="phone" column="phone"/>
    <result property="isdefault" column="isdefault"/>
</resultMap>

<!-- 查询多条数据并返回AddressVO的List集合 -->
<select id="selectListVO"
	resultType="com.entity.vo.AddressVO" >
	SELECT * FROM address  address         
    <where> 1=1 ${ew.sqlSegment}</where>
</select>

<!-- 查询单条数据并返回AddressVO对象 -->
<select id="selectVO"
	resultType="com.entity.vo.AddressVO" >
	SELECT  address.* FROM address  address
	<where> 1=1 ${ew.sqlSegment}</where>
</select>

<!-- 查询多条数据并返回AddressView的List集合 -->
<select id="selectListView"
	resultType="com.entity.view.AddressView" >

	SELECT  address.* FROM address  address 	        
    <where> 1=1 ${ew.sqlSegment}</where>
</select>

<!-- 查询单条数据并返回AddressView对象 -->
<select id="selectView"
	resultType="com.entity.view.AddressView" >
	SELECT * FROM address  address <where> 1=1 ${ew.sqlSegment}</where>
</select>

</mapper