case mybatis 不同表_MyBatis笔记----多表关联查询两种方式实现

数据库

方式一：XML

按照下面类型建立article表

Article.java

packagecom.ij34.model;public classArticle {private intid;privateUser user;privateString title;privateString content;publicString getContent() {returncontent;

}public voidsetContent(String content) {this.content =content;

}public intgetId() {returnid;

}public void setId(intid) {this.id =id;

}publicUser getUser() {returnuser;

}public voidsetUser(User user) {this.user =user;

}publicString getTitle() {returntitle;

}public voidsetTitle(String title) {this.title =title;

}

}

UserMapper.xml

颜色aid重点标出部分很重要，必须使用别名，不要最后结果获得article的id全是输入的id

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"<