Mybaties实现多表查询

方法一：

用@Select注解

    @Select("select p.pg_id, p.name, p.sex, p.idc_type, p.id_card, p.pg_type, p.phone\n" +
            "        from users natural join hold_info h left join passenger p\n"+
            "        on h.pg_id = p.pg_id\n" +
            "        where user_id = #{user_id};")
    List<Passenger> listPassengersByUserId(@Param("user_id") int user_id);

 

方法二：

*mapper.xml配置

    <select id="selectPassengerByUserId" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        select p.pg_id,p.name,p.sex,p.idc_type,p.id_card,p.pg_type,p.phone
        from users natural join hold_info h left join passenger p
        on h.pg_id = p.pg_id
        where user_id = #{user_id};
    </select>

 

注：一定要保证查询语句的语法正确。