1.xml写法
select
t.id, t.tasknumber, t.taskstarttime, t.taskendtime, t.taskclass, t.taskinfo, t.taskstatus, t.uid, t.executiontime,
u.numbers, u.name, u.positionid, u.phone, u.status, u.jurisdiction, u.deptid, u.currenttask, u.state,
d.deptnumber, d.deptname, p.positionname, p.positionnumber
from tasks t left join users u on t.uid = u.id
left join dept d on u.deptid = d.id
left join position p on u.positionid = p.positionid
2.实体类写法
package nanh.entity;
import java.io.Serializable;
public class Tasks implements Serializable{
private Users Users;
public Users getUsers() {
return Users;
}
public void setUsers(Users users) {
Users = users;
}
@Override
public String toString() {
return "Tasks [Users=" + Users + ", id=" + id + ", tasknumber=" + tasknumber + ", taskstarttime="
+ taskstarttime + ", taskendtime=" + taskendtime + ", taskclass=" + taskclass + ", taskinfo=" + taskinfo
+ ", taskstatus=" + taskstatus + ", uid=" + uid + ", executiontime=" + executiontime + "]";
}
/**
*
*/
private static final long serialVersionUID = 1L;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column tasks.id
*
* @mbggenerated
*/
private Integer id;
/**
* This field was generated by MyBatis Generator.
* This field corresponds to the database column tasks.tasknumber
*
* @mbggenerated
*/
private String tasknumber;
/**
* This field was generated by MyBatis Generator.
* This fie