大侠们帮我看看我的ibatis-sql多表查询配置有什么问题
--------------------编程问答-------------------- 没人啊? --------------------编程问答-------------------- select a.sid,a.sname,b.id,b.name,b.sid
Javapublic class Person {
private int sid=0;
private String names=null;
private Timestamp timess=null;
private int id=0;
public class Student {
private int sid=0;
private String sname=null;
private String major=null;
private Date birth=null;
private float score=0;
private List persons;
<resultMap id="StudentMap" class="Student">
<result property="sid" column="sid"/>
<result property="sname" column="sname"/>
<result property="persons" column="sid" select="Student.PersonMap"/>
</resultMap>
<resultMap id="PersonMap" class="Person">
<result property="id" column="id"/>
<result property="sname" column="sname"/>
<result property="sid" column="sid" />
</resultMap>
<select id="com.wkw.bean.Student.selectAllStudent" resultMap="StudentMap">
select a.sid,a.sname,b.id,b.name,b.sid
from student a left outer join person b on a.sid = b.sid
</select>
总是报错误。配置问题。初学Ibatis,请帮忙检查下。
from student a left outer join person b on a.sid = b.sid
查询出来:表的列和bean要对应起来 --------------------编程问答-------------------- <select id="com.wkw.bean.Student.selectAllStudent" resultMap="StudentMap">
select
a.sid as sid,
a.sname as sname,
b.id as id,
b.name as sname
from student a left outer join person b on a.sid = b.sid
</select> --------------------编程问答-------------------- 我也看不懂啊。 --------------------编程问答-------------------- 就是你sql返回的colum要与resultMap里面的相对应 --------------------编程问答-------------------- 升级到mybatis吧 --------------------编程问答--------------------
补充:Java , Java EE