数据库查询到多条语句,但是ssm框架得到的数据显示只有一条

映射问题
resultMap的代码为

<resultMap id="BaseResultMap" type="com.bean.Joingame">
    <id column="jid" jdbcType="INTEGER" property="jid" />
    <result column="gid" jdbcType="INTEGER" property="gid" />
    <result column="uid" jdbcType="INTEGER" property="uid" />

    <association property="users" javaType="com.bean.Users">
      <result column="uname" jdbcType="VARCHAR" property="uname" />
    </association>
    <association property="game" javaType="com.bean.Game">
      <result column="gname" jdbcType="VARCHAR" property="gname" />
    </association>
  </resultMap>

若查询语句为

<select id="selectGameList"  resultMap="BaseResultMap">
    SELECT g.gid,g.gname,u.uname
     FROM joingame jg,game g,users u
    where jg.gid=g.gid and jg.uid=u.uid
  </select>

则只能得到一条
查询的内容添加jg.jid,就可以了

<select id="selectGameList"  resultMap="BaseResultMap">
    SELECT jg.jid,g.gid,g.gname,u.uname
     FROM joingame jg,game g,users u
    where jg.gid=g.gid and jg.uid=u.uid
  </select>

映射时需要id来对应数据