1. 一下是我的实体类
- private int id;
- private Users users;//房屋持有者
- private Types types;//房屋类型
- private String title;
- private String description;
- private double price;
- private Date pubdate;//发布日期
- private int floorage;//建筑面积
- private int contact;//联系方式
- private Street street;//房屋所属街区
- public int getId() {
- return id;
- }
- public void setId(int id) {
- this.id = id;
- }
- public String getTitle() {
- return title;
- }
- public void setTitle(String title) {
- this.title = title;
- }
- public String getDescription() {
- return description;
- }
- public void setDescription(String description) {
- this.description = description;
- }
- public double getPrice() {
- return price;
- }
- public void setPrice(double price) {
- this.price = price;
- }
- public Date getPubdate() {
- return pubdate;
- }
- public void setPubdate(Date pubdate) {
- this.pubdate = pubdate;
- }
- public int getFloorage() {
- return floorage;
- }
- public void setFloorage(int floorage) {
- this.floorage = floorage;
- }
- public int getContact() {
- return contact;
- }
- public void setContact(int contact) {
- this.contact = contact;
- }
- public Users getUsers() {
- return users;
- }
- public void setUsers(Users users) {
- this.users = users;
- }
- public Types getTypes() {
- return types;
- }
- public void setTypes(Types types) {
- this.types = types;
- }
- public Street getStreet() {
- return street;
- }
- public void setStreet(Street street) {
- this.street = street;
- }
##下面是对应的xml文件,以及sql语句
<mapper namespace="com.rhit.dao">
<resultMap id="HouseMap" type="com.rhit.entity.House">
<id property="id" column="ID" />
<result property="title" column="TITLE" />
<result property="description" column="DESCRIPTION" />
<result property="price" column="PRICE" />
<result property="pubdate" column="PUBDATE" />
<result property="floorage" column="FLOORAGE" />
<result property="contact" column="CONTACT" />
<association property="types" javaType="Types">
<id property="id" column="ID" />
<result property="name" column="NAME" />
</association>
<association property="street" javaType="Street">
<id property="id" column="ID" />
<result property="name" column="NAME" />
</association>
<association property="users" javaType="Users">
<id property="id" column="ID" />
<result property="name" column="NAME" />
<result property="password" column="PASSWORD" />
<result property="telphone" column="TELEPHONE" />
<result property="username" column="USERNAME" />
<result property="isadmin" column="ISADMIN" />
</association>
</resultMap>
<select id="getHouse" resultMap="HouseMap">
select * from house h,users u,types t,street s where u.id=h.user_id and t.id=h.type_id and s.id=h.street_id
</select>
</mapper>
##下面是调用测试
public class Test {
public static void main(String[] args) {
SqlSession session=MyBatisUtil.getSession();
List<House> list=session.selectList("getHouse");
System.out.println(list.get(0).getStreet().getName());
System.out.println(list.get(0).getTypes().getName());
System.out.println(list.get(0).getUsers().getName());
}
}
##问题
1.测试结果只获取到了user的名字,而types和street的名字跟user的名字一样?
2.一个resultMap中可以有多个association么?这种多对多的关系该怎么处理?
3.一个resultMap可以有多个collection么?怎么写sql语句呢?
求大神么解答,在线等,先谢过!