mybatis联合查询.docVIP

1、首先是实体里面，以前存的是string 现在肯定要修改为 对象 package bean; import java.sql.Timestamp;import java.util.Date; import baseparam.DeptBean;//存对象 public class StudentBean{?private String id;??private String name;??private String email;??private Date birthday;??private DeptBean dept;??public DeptBean getDept()?{??return dept;?} ?public void setDept(DeptBean dept)?{??this.dept = dept;?} ?public String getId()?{??return id;?} ?public void setId(String id)?{??this.id = id;?} ?public Date getBirthday()?{??return birthday;?} ?public void setBirthday(Date birthday)?{??this.birthday = birthday;?} ?public String getName()?{??return name;?} ?public void setName(String name)?{?? = name;?} ?public String getEmail()?{??return email;?} ?public void setEmail(String email)?{??this.email = email;?} ?public StudentBean(String name)?{??super();?? = name;?} ?public StudentBean()?{??super();??}?} ? 2、在配置文件中指定部门实体路径（/ibatis/src/SqlMapConfig.xml） ? ?xml version=1.0 encoding=UTF-8 ?!DOCTYPE configuration PUBLIC -////DTD Config 3.0//EN/dtd/ibatis-3-config.dtdconfiguration?typeAliases??typeAlias type=bean.StudentBean alias=studentBean /????!-- 指定部门实体路径--??typeAlias type=baseparam.DeptBean alias=deptBean/?/typeAliases??environments default=development??environment id=development???transactionManager type=JDBC /???dataSource type=UNPOOLED????property name=driver value=oracle.jdbc.driver.OracleDriver /????property name=url?????value=jdbc:oracle:thin:@01:1521:DEPPONIT /????property name=username value=deppon009 /????property name=password value=dpi/???/dataSource??/environment?/environments?mappers??mapper resource=Student.xml /?/mappers/configuration ? 3、最后一个就是修改mapper文件了（/ibatis/src/Student.xml） ?xml version=1.0 encoding=UTF-8 ?!DOCTYPE mapper PUBLIC -////DTD Mapper 3.0//EN/dtd/ibatis-3-mapper.dtdmapper namespace=student ?sql id=studentColumn??fid,??fname,??fbirthday?/sql?select id=getAll resultType=studentBean res