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,请帮忙检查下。
解决方案 »
- 字符串分割问题
- JAXB生成带有CDATA区域的xml的问题(结合jersey)
- 关于FileInputStream错误的问题,请各位大侠帮忙
- java 抛的数据库连接异常,求解?
- 日本野村证券研究所的次世代框架,有谁做过,能讲解一下吗?以前CSDN下载频道有下的,现在找不到了.
- 哪位仁兄对iText熟悉的,很多问题请教,!加QQ:346685272
- 出乎意料的部署运行servlet未成功!!
- 求一份配置mysql和tomcat连接池文件
- tomcat5和IIS整合后经常出现The servlet container is temporary unavailable or being upgraded !
- 初学JAVA,用分换经验
- Java web项目 目录结构 讨论
- 求助
from student a left outer join person b on a.sid = b.sid
查询出来:表的列和bean要对应起来
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>