客户类Customer id,name,username,password,addressLists
地址类Address id,province,city,address,customer
客户表tb_customer id,name,username,password
地址表tb_address id,province,city,address,cutomer_id
=========================================================================
n+1查询 查询全部地址,同时查询地址相应的客户数据
(N)根据主键(外键)查询客户
CustomerMapper.xml
<mapper namespace="com.demo.mapper.CustomerMapper">
<select id="selectById" resultType="Customer">
select id,name,username,password from tb_customer where id = #{id}
</select>
</mapper>
(1)查询地址在查询对应客户
n+1查询,先查询地址(1),在根据地址中外键查询对应客户(N)
AddressMapper.xml <association>中column对应的是CustomerMapper