mybatis中jsp获取不同表字段显示

<resultMap id="BaseResultMap" type="com.fafukeji.model.Goods" >
  <id column="id" property="id" jdbcType="INTEGER" />
  <result column="description" property="description" jdbcType="VARCHAR" />
  <result column="attributes" property="attributes" jdbcType="VARCHAR" />
  <result column="pics" property="pics" jdbcType="VARCHAR" />
  <result column="urls" property="urls" jdbcType="VARCHAR" />
  <result column="numbers" property="numbers" jdbcType="INTEGER" />
  <result column="state" property="state" jdbcType="BIT" />
  <result column="status" property="status" jdbcType="BIT" />
  <result column="updated_at" property="updatedAt" jdbcType="INTEGER" />
  <result column="created_at" property="createdAt" jdbcType="INTEGER" />


  <association property="userId" javaType="com.fafukeji.model.User">
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="username" property="username" jdbcType="VARCHAR" />
  </association>
  <association property="categoryId" javaType="com.fafukeji.model.Categories">
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="parent_name" property="parentName" jdbcType="INTEGER" />
  </association>

</resultMap>

  <select id="selectGoods" resultMap="BaseResultMap" parameterType="com.fafukeji.model.Goods">
SELECT goods.id,goods.description,goods.attributes,categories.`name`,categories.ename,goods.user_id,goods.category_id,goods.pics,goods.urls,goods.numbers,goods.state,goods.`status`,goods.updated_at,goods.created_at
,categories.parent_name ,users.username
from ((goods inner join categories
on goods.category_id = categories.category_id)
INNER JOIN attribute on goods.attributes = attribute.name)
INNER JOIN users
  </select>
</mapper>

<c:forEach items="${goodsList.list}" var="goods">
<tr>
   <td>${goods.userId.id}</td>
   <td>${goods.userId.username}</td>
   <td>${goods.categoryId.name}</td>
   <td>${goods.categoryId.parentName}</td>
   <%--<td>${goods.description}</td>--%>
   <%--<td>${goods.attributes}</td>--%>
   <%--<td>${goods.numbers}</td>--%>
   <td>${goods.taskStateName}</td>
   <%--<td>${goods.createdAt}</td>--%>

</c:forEach>

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值