<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="mobile">
<resultMap id="userResultMap" type="Mobile">
<id property="id" column="id"/>
<result property="telnumber" column="telnumber"/>
<association property="user" javaType="User">
<id property="id" column="id"/>
<result property="userName" column="name"/>
<result property="password" column="pass"/>
</association>
</resultMap>
<select id="selectMobile" parameterType="int" resultMap="userResultMap" >
select m.id m_id,m.telnumber,u.id u_id,u.name,u.pass from t_mobile m,t_user u where m.userid = u.id and m.id = #{id}
</select>
</mapper>
public class User {
private int id;
private String userName;
private String password;
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
}
public class Mobile {
private int id;
private String telnumber;
private User user;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getTelnumber() {
return telnumber;
}
public void setTelnumber(String telnumber) {
this.telnumber = telnumber;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
}