Mybatis两表联合查询

SELECT * FROM goods_info i,user_order o WHERE i.goods_id = o.goods_id

<resultMap id="getAllOrder" type="com.xjw.bean.UserOrder">

<id column="order_id" property="orderId" jdbcType="INTEGER" />

<result column="goods_id" property="goodsId" jdbcType="INTEGER" />

<result column="order_count" property="orderCount" jdbcType="INTEGER" />

<result column="order_price" property="orderPrice" jdbcType="REAL" />

<result column="create_date" property="createDate" jdbcType="TIMESTAMP" />

<association property="goodsInfo" javaType="com.xjw.bean.GoodsInfo">

<id column="goods_id" property="goodsId" jdbcType="INTEGER" />

<result column="goods_name" property="goodsName" jdbcType="VARCHAR" />

<result column="goods_desc" property="goodsDesc" jdbcType="VARCHAR" />

<result column="goods_price" property="goodsPrice" jdbcType="REAL" />

<result column="create_date" property="createDate" jdbcType="TIMESTAMP" />

</association>

</resultMap>